How to use add a new row Action to logging over time

[eusy1327]

Hello~ I have a sheet that use below Action to recode edit log.
and also has a key value that unique 9 characters in the each row data.
It works do logging first time in case of none of same key data to log sheet.
but in case of in there log sheet same key data, only edits some changed column existing data.
I want to add row data even if it has the same key data in the sheet.
Because I want to log data over time.
Please advise~

Action
Data: add a new row to another table using values from this row

[Kirk_Masden · Accepted solution]

eusy1327:

same key data

I’m not sure I understand your situation correctly, but your keys should always be unique. Are you using UNIQUEID() on new records? I suggest that you do so.

help.appsheet.com

UNIQUEID()

Pseudo-unique ID

[eusy1327]

Thank you. solved the issue~