Field becomes visible ONLY during edit

AppSheet AppSheet Q&A
,
1

Hello everyone,

How can I enable or show a hidden field ONLY if a user edits the existing record.
What I wanted to happen is that if ever they changed their mind and to wanted to edit the record they’ve submitted, i wanted to show the hidden field “Edit reason”, t hat way when they re-submit this form that they are editing, we would know why they edited it?.

3X_1_5_15b65fa7b812d36d1c0999b75d6750fd8ec8c592.png
3X_1_5_15b65fa7b812d36d1c0999b75d6750fd8ec8c592.png478×777 20.7 KB

Thank you in advance!

Regards,

Beth

2

You can use CONTEXT() with show_if.

Or you can use the column order setting on the views in question.

3X_a_b_ab8d8dde65b588832b7caa1a289f96be712bfbe5.png
3X_a_b_ab8d8dde65b588832b7caa1a289f96be712bfbe5.png634×382 19.1 KB

3 Likes
3

Thank you very much for your swift reply! appreciate it and yes it works

3 Likes
4

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?

Is this a new row?/Does this row already exist? Is this a new row? NOT(IN([_ROWNUMBER], My Table[_ROWNUMBER])) or: ISBLANK( FILTER( “My Table”, ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER]) ) ) Does this row already exist? IN([_ROWNUMBER], My Table[_ROWNUMBER]) or: ISNOTBLANK( FILTER( “My Table”, ([_ROWNUMBER] = [_THISROW].[_ROWNUMBER]) ) ) In the above, replace My Table with the name of the table about which you’re inquiring. When modifying rows, such as in forms or wi…

5

Thank you it helps a lot!

1 Like