Is there a way to detect in an expression tha...

expressions
(Steven Aung) #1

Is there a way to detect in an expression that a user is editing or creating a new row?

(Jacob Lin [AppSheet]) #2

@Steven_Aung Are you asking for a way to differentiate between editing or creating a new row?

A simple solution that might not work all the time is to check if a column is blank or not (ISBLANK([Column]) or ISNOTBLANK([Column])); assuming that the column is filled before editing, since when you create a new row all the columns will be empty.

(Steven Aung) #3

For my current use case, that will be good enough. Thanks.

(Grant Stead) #4

plus.google.com - Hello! Im trying to determine when my app is adding a new record, or editing … Hello! Im trying to determine when my app is adding a new record, or editing … plus.google.com