Hello,
A little help would be appreciated
I have two columns. Col1- โDo you wish to leave a commentโ & Col2-โCommentโ - The first is a yes/no. The second is a long text.
Iโve been unsuccessfully trying to create a scenario where if Col1 = โNoโ then Col2 is auto filled with text โNo commentโ.
And if Col1 = text โYesโ, then the user is allowed to leave a long text comment.
Can someone show how to achieve this please.
Solved! Go to Solution.
Please explore if following helps you.
In the Col2 , initial value setting , you could have an expression such as
IFS([Col1]=FALSE,โNo Commentโ)
In Col2, Editable ? Setting, you could have
[Col1]=TRUE
In Col2 's Reset on Edit? setting you could have
[Col1]=FALSE
Here Col1 is assumed to be AppSheetโs Y/N type column , so it evaluates to TRUE or FALSE based on enum selection. So TRUE and FALSE are used in expressions above.
Please explore if following helps you.
In the Col2 , initial value setting , you could have an expression such as
IFS([Col1]=FALSE,โNo Commentโ)
In Col2, Editable ? Setting, you could have
[Col1]=TRUE
In Col2 's Reset on Edit? setting you could have
[Col1]=FALSE
Here Col1 is assumed to be AppSheetโs Y/N type column , so it evaluates to TRUE or FALSE based on enum selection. So TRUE and FALSE are used in expressions above.
Thank you Mr. Gurjar.
It worked a treat! You wont believe how may hours I spent trying to figure that one out
Question - Is it possible for an empty field to be populated (with text or another field) if it is left blank?
Example. A column has no relation to any other column in the table. It is set โRequire?โ off. On save, the blank field is filled with text โN/Aโ.
I believe you can do so by using event actions on form save. You could set all those such columns to โN/Aโ by using action type, โSet the values ofsome columns in this rowโ and set this action as event action on form save.
Thank you for the update. Good to know the solution works as per your requirement.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |