Field becomes visible ONLY during edit

[bethany_d]

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?.

Thank you in advance!

Regards,

Beth

[Marc_Dillon · Accepted solution]

You can use CONTEXT() with show_if.

help.appsheet.com

CONTEXT()

Information about the running app.

help.appsheet.com

Show_If Column Constraint

Conditionally show or hide a column value.

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

[bethany_d]

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

[Steve]

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…

[bethany_d]

Thank you it helps a lot!