"Yes/No" column--UX question

[yumei]

With a "Yes/No" column, I only want "Yes" to display in a table and the "No" be a blank. However, if I make the "No" value to be blank, ie "", then that will also show up as a blank in the form--That'd be weird for users. Is there any workaround on this one?

 

 

[dbaum · Accepted solution]

CONTEXT() - AppSheet Help 

[yumei]

But if I specify context=Form, then that applies to the "Yes" field too, wouldn't it? I want "Yes" to display in tables and both "Yes" and "No" to display in form.

[dbaum]

try using a CONTEXT expression in the custom "No" value--e.g., if form, then "No", else "".

[dbaum]

Another idea would be to define a Format Rule that somehow hides the "No" value in tables--maybe make the text the same color as the background. Note, however, this would apply only to visual rendering but not, for example, screen readers used by visually impaired users.

[yumei]

This may work, but you gave me another idea: I went back to your first suggestion but added another condition: if the response=True. That did it! Thanks you!