How to detect a row is a newly inserted row

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.

Solved Solved
0 11 1,493
1 ACCEPTED SOLUTION

Good to know that.

View solution in original post

11 REPLIES 11
Top Labels in this Space