Yes / No Checkboxes?

Hi Johnny,

I see in this post that in V3 checkbox_boolean isn’t implemented… And as far as I can tell it doesn’t work trying it with code.

I would really like a forced yes / no choice presented to the user. The best I think I can do right now is:

$crud->fieldType('Active','dropdown',['0' => 'No', '1'=>'Yes']);

However, it permits the NULL value too. Yes, my database for historical reasons permits NULL, but I would prefer the user to pick yes or no. (And not have the NULL option). Ideally via a radio button since a drop down takes longer.

Any thoughts on how to best handle this?

Thanks,

Ira

@heruprambadi - only checkbox_boolen is in the field type list for V3.0.9 (GCE) but it does not appear to do anything. Hence the question.

Hi @Johnny,

Thanks for the suggested work arounds of callbackInsert and callbackUpdate. I think it would be more complicated to use those and that would make the UI a bit clumsy… I’ll wait for a radio button in a future release.

That said, I would argue that accepting a NULL is unexpected behavior. Yes it is valid in my MySQL field which is enumerated. However you see I only enumerated two values in the fieldType:

['0' => 'No', '1'=>'Yes']

The input routine should only allow those but not NULL. Another example if the table had enumerated values of (Yes, No, Maybe, Crazy) and one specified the fieldType with only Yes or No. In this case, the drop down only show Yes or No as choice. It shouldn’t show Maybe or Crazy.

Perhaps if one wanted to provide a NULL option then NULL would also go in the list like this:

['0' => 'No', '1'=>'Yes', NULL]

Does this make sensse?

Thanks,

Ira