Current solution is
- add a virtual column name TempKey which is set identical to a table’s key named _Key. Set the column as a reference column which will point back to the current table
- add another virtual column named isNew in which we check the TempKey reference. E.g ISBLANK([TempKey].[_Key]). If the column is true, the current row is brand new.
Is there better way to detect the newly-inserted row? What’s your trick?
Thanks in advance for sharing.
Note - we use the information to make some columns editable at the insertion state or at re-editing state.