Custom Y/N Text

Currently, the Yes/No column type creates two buttons with text “Y” and “N”, which cannot be changed. Similarly, showing the Y/N column type outside of the form results in a “Y” or “N”.

As per @Benoit_Gramond

We need the ability to customize the text for TRUE or FALSE values in the Y/N column type.

For example, a table may have a boolean column ‘status’, with two options: ‘Visible’ or ‘Hidden’.

Currently, the only way to achieve the first option is to use an ENUM column type rather than Y/N. This this has two drawbacks, namely:

  • We are saving a string to our database, rather than a simple boolean value
  • Application or server-side formulas which take the boolean value as an input must perform the additional step of decoding the string back into a boolean (e.g. IF([status]=“Visible”,TRUE,FALSE) rather than just [status])

Also, the current Y/N column data does not present itself neatly when displayed elsewhere in the app. Take for example, this screenshot:


There is no column header to give any idea what the Y/N value is indicating. Users must create an additional virtual column to convert the BOOL into a useful string to be displayed.

In other words, give us this:

On all accounts.