Title: Boolean or tinyint(1) not null data entry
Last modified: June 5, 2020

---

# Boolean or tinyint(1) not null data entry

 *  Resolved [Kooyaya](https://wordpress.org/support/users/kooyaya/)
 * (@kooyaya)
 * [6 years ago](https://wordpress.org/support/topic/boolean-or-tinyint1-not-null-data-entry/)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years ago](https://wordpress.org/support/topic/boolean-or-tinyint1-not-null-data-entry/#post-12945744)
 * 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](https://wordpress.org/support/users/kooyaya/)
 * (@kooyaya)
 * [6 years ago](https://wordpress.org/support/topic/boolean-or-tinyint1-not-null-data-entry/#post-12945784)
 * That works! Thanks Peter!
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years ago](https://wordpress.org/support/topic/boolean-or-tinyint1-not-null-data-entry/#post-12945800)
 * 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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/boolean-or-tinyint1-not-null-data-entry/#post-12945800)
 * Status: resolved