Updating existing row - Page 2

Tony_W · 06-04-2019 06:45 AM

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.