Boolean or tinyint(1) not null data entry

  • Resolved Kooyaya

    (@kooyaya)


    4 years, 5 months ago

    The boolean non-null field shows as a mandatory checkbox in the data entry form. If it is not checked, the validation complains the field is missing.

    If the field has to be checked, it is not possible to enter false or 0 for the field.

    Is it a bug? Is there any workaround?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi kooyaya,

    The implementation of a checkbox in the plugin uses value 1 for enabled and null for disabled. It designed this way, but I understand this implementation gives an error for not null columns. It can be changed in the next release.

    Can you modify your column to allow null values? That could be a workaround and a permanent solution as well.

    Best regards,
    Peter

    Thread Starter Kooyaya

    (@kooyaya)

    That works! Thanks Peter!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Great! ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Boolean or tinyint(1) not null data entry’ is closed to new replies.