# Bools In Vision Table

**URL:** <https://forum.inductiveautomation.com/t/bools-in-vision-table/30408>\
**Category:** Ignition\
**Tags:** ignition79, database\
**Created:** [December 3, 2019, 2:47pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408 "2019-12-03T14:47:00Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![lmirka](https://avatars.discourse-cdn.com/v4/letter/l/a87d85/32.png) [@lmirka](https://forum.inductiveautomation.com/u/lmirka)\
**Post date:** [December 3, 2019, 2:47pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/1 "2019-12-03T14:47:00Z")

</div>

I have a table on a high-resolution screen with native scaling. One of my columns is boolean, and linked to a SQL query that I would like to still be able to update. No matter what I try with any of the Translations, I can’t seem to get the boolean values to display as anything other than the checkbox, which doesn’t scale with row height and is incredibly small on the high-res client. Is there a way to get the boolean values to display as anything else in the table?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 3, 2019, 4:49pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/2 "2019-12-03T16:49:24Z")

</div>

If it’s a power table, you can implement your own renderer using the `configureRenderer` extension function, but it requires some knowledge of scripting, unless you just want to display an image or something instead.

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [December 3, 2019, 5:30pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/3 "2019-12-03T17:30:11Z")

</div>

And if it’s not?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 3, 2019, 5:34pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/4 "2019-12-03T17:34:56Z")

</div>

Then you should make it one 🙂  
The regular table is more simple (and therefore, less customizable) by design. You can probably use the image rendering mode, but anything more custom than that you’re better off using the power table.

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [December 3, 2019, 5:39pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/5 "2019-12-03T17:39:35Z")

</div>

I understand that.  
But the option to use Translation List in the ‘regular’ table is there for booleans also, even if it doesn’t work… that’s confusing.👎  
But the ‘problem’ isn’t that the Translation list is not working for booleans…  
The problem is that scaling doesn’t work.

---

<div class="post-metadata">

**Author:** ![lmirka](https://avatars.discourse-cdn.com/v4/letter/l/a87d85/32.png) [@lmirka](https://forum.inductiveautomation.com/u/lmirka)\
**Post date:** [December 3, 2019, 6:31pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/6 "2019-12-03T18:31:27Z")

</div>

Displaying an image would be fine as well. Is that easier to implement?

---

<div class="post-metadata">

**Author:** ![lmirka](https://avatars.discourse-cdn.com/v4/letter/l/a87d85/32.png) [@lmirka](https://forum.inductiveautomation.com/u/lmirka)\
**Post date:** [December 6, 2019, 9:52pm UTC](https://forum.inductiveautomation.com/t/bools-in-vision-table/30408/7 "2019-12-06T21:52:36Z")

</div>

So I ended up just changing my data in the trouble column from bool to an int, which finally allowed me to do any translation my heart desired. Feels like this is a bug - especially with the “boolean” checkbox unchecked in the column properties…
