Yes/No where no opens long text for more info

AppSheet AppSheet Q&A
, ,
1

for Yes/no columm, if no was selected, how would I have that open a long text box for user input? I have a second table set up for results.

Again, Thanks in advance

2

You need a new column, the type is LongText and the “Show_IF” expression is

NOT([YesNoColumn])

Since you are wanting it to be shown when the value is no, not() changes it to the opposite

3 Likes
3

The new column would be on table “RESULTS”, which is part of the same google workbook. I have a few occasions where I need it to be the opposite, where a yes answer requires added information too.

4

Ah Ha, Figured it out, thanks to your answer, skipping the results table, too complicated for now anyway.

A follow-up, How do I not show the LongText box until No is chosen? Currently it is shown when both unchecked, or until I check Yes, then it goes away. For when I want added info for a yes answer, I see I just enter the column name in the ShowIF, but that doesn’t show until I select Yes, then the LongText opens. I would like all the extended information to be not visible until actually selected for, if possible.

5 
AND(
  ISNOTBLANK([YNColumn]),
  NOT([YNColumn])
)
6

Exactly what I needed, Thanks again and greatly appreciated.

1 Like