Form: Show a field only on edits (not when adding records)

Hello.
Consult I think elemetal, please:
How is it done so that some fields are not shown when generating a new record, but they are shown when that record is later edited?
Thank you. Marcos. 

Solved Solved
0 2 109
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

The following expression answers the question, does this row already exist?

IN([_ROWNUMBER], table[_ROWNUMBER])

This expression answers the question, is this a new row?

NOT(IN([_ROWNUMBER], table[_ROWNUMBER]))

In each, replace table with the table name.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-FILTER-LOOKUP-MAXROW-MINROW-REF-ROWS-and-SEL...

View solution in original post

2 REPLIES 2

Steve
Platinum 5
Platinum 5

The following expression answers the question, does this row already exist?

IN([_ROWNUMBER], table[_ROWNUMBER])

This expression answers the question, is this a new row?

NOT(IN([_ROWNUMBER], table[_ROWNUMBER]))

In each, replace table with the table name.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-FILTER-LOOKUP-MAXROW-MINROW-REF-ROWS-and-SEL...

Thank you very much @Steve.

Top Labels in this Space