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: