2 replies to this topic

[HumbleMonk]

I use a lot of number fields in my application. It is hard to read large numbers at a glance without some type of indicator, e.g. compare 1345600 to 1,345,600. The grocery crud number filter prevents commas from being entered into the field.

Is there some way to allow commas to be entered in the number field but stripped before the item is saved? I've poked around but can't figure out where GroceryCrud prevents anything but numbers from being entered.

Ideally the flow would be something like this:

Read number field from database
Automatically populate with commas
Automatically adjust commas if field is edited
On save, strip commas and then submit

[Alvin Lesmana]

Put this on your controller

$crud->callback_column('price',array($this,'format_num'));


and add this function :

function format_num($value, $row){
return number_format($value, 0);
}

[HumbleMonk]

Thank you for the answer.

That results in a formatted field, like I want, however it is not editable. I need this field to be editable.