Title: Table Boolean Display
Last modified: July 30, 2023

---

# Table Boolean Display

 *  Resolved [grokwhy](https://wordpress.org/support/users/grokwhy/)
 * (@grokwhy)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/table-boolean-display/)
 * Hello,
   I have boolean data – tinyint(1) that is displayed in the table builder
   as 0 or -1. I’d like this to be displayed as Yes if -1, or Yes or No.I couldn’t
   find a reference to this through search, but it must be a common problem. I’m
   using the paid version.BTW, Data Access is great. I can imagine the possibilities.
   Thanks,Russ

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/table-boolean-display/#post-16934322)
 * Hi Russ,
 * We’re happy to know you’re enjoying **WP Data Access**. 😊
 * To display Yes or No depending on the data value, you need to add custom renderers
   to your table via [Advanced settings | WP Data Access](https://wpdataaccess.com/docs/data-tables-advanced-features/advanced-settings/).
 * A similar discussion from DataTables can be found here: [Replace 0 with No and 1 with Yes in Display — DataTables forums](https://datatables.net/forums/discussion/66564/replace-0-with-no-and-1-with-yes-in-display)
 * Hope that helps. Let us know if you have more questions.
 *  Thread Starter [grokwhy](https://wordpress.org/support/users/grokwhy/)
 * (@grokwhy)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/table-boolean-display/#post-16984219)
 * [@kimmyx](https://wordpress.org/support/users/kimmyx/) ,
   Sorry for being so dense,
   but could you give me a working example? I followed the link, but I can’t get
   that sample to work. Damn you! Red X!So say I have a column name isHappy and 
   if it’s 0 that’s NO, 1 is YES. I think if I had a working example of, if it’s
   column name X then do this code, like the render function in the example code,
   I could modify from there.Thanks!GrokWhy
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/table-boolean-display/#post-16993950)
 * Hi [@grokwhy](https://wordpress.org/support/users/grokwhy/),
 * Apologies for the delay in response. I realized you just wish to modify the display
   value on the table and not in the database.
 * The function you want requires JavaScript and before using them in **Advanced
   Options**, the function is wrapped between double-quotes to maintain JSON format.
 * I’ve managed to modify the function for your purpose. Please see my test here:
   [https://share.getcloudapp.com/geuP9yO0](https://share.getcloudapp.com/geuP9yO0)
 * Could you send us a message via [Contact | WP Data Access](https://wpdataaccess.com/contact/)
   as this is custom code exclusive for premium users.
 * We’ll wait for your email!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Table Boolean Display’ 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: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/table-boolean-display/#post-16993950)
 * Status: resolved