Updating existing row

[Tony_W]

Hi all.

Complete newbie so please be gentle.
My app is to allow me to print labels for electrical consumer units.
Based on a Google sheet which has 4 sheets/tables.
1 for lookup of switch positions
1 for lookup of allowable values (e.g. Kitchen)
1 for holding the current “result” (which is a set of 12 switch references with each having one allowable value e.g. Kitchen)
1 for printing (not part of my problem yet).

I have an app now that call all the data I need to app and allows me to select and alter data in the app but once I try and save to the results table I get an error saying that the row already exists (which it does). I do not wish to add a new row on SAVE, I want to update the relevant row.

Any pointers?

Thanks in advance.

[Heino_Matthee]

Does your app need to be able to add new entries or do you just want to update existing entries?

[Tony_W]

Just update existing

[Bellave_Jayaram]

I would recommend using a quick edit, if possible. See https://help.appsheet.com/ux/views/quick-edit

[Tony_W]

Many thanks - will look at that as a solution.

[Heino_Matthee]

Also select UPDATES ONLY for your tables and appsheet will remove all the new entry possibility which would stop you having that first problem

[Tony_W]

Thank you

Will give that try also