"Add a new row to another table..." updates instead of creating

I’m using an “Add a new row to another table…” action to create a entry in a subtable. But its updating the existing record instead of creating a new one. Is this a new bug or something?

recently APIs of Appsheet was bit unstable, I have been in touch with Appsheet dev team for almost month. Action to add new records might have connection with APIs, better to raise ticket to support@appsheet.com

2 Likes

I haven’t noticed this. Perhaps you should write to support@appsheet.com.

2 Likes

@tsuji_koichi & @Kirk_Masden I’ve emailed support with the issue. Thanks for your help :slight_smile:

3 Likes

If you attempt to add a record with the same key as existing record, the add will automatically be turned into an update. You can confirm whether this is happening by checking “Add” end record in the Audit History. If the “Add” end Audit History record contains the property “UpdateExistingRecord” and the key value of the updated record, then the “Add” was turned into an “Update”.

This is by design as part of the “last writer wins” conflict resolution strategy. If two users attempt to “Add” the same record, the first “Add” to reach the server is treated as an “Add”. The second “Add” to reach the server is treated as an “Update”. To signal that this has occurred, we set the “UpdateExistingRecord” property in the Audit History for the second add.

I am not certain that is what you are reporting here, but it sounds like it might be.

5 Likes

@Phil ok, I’ll check it out. I thought I’d set the key column to unique ID…