Can anyone advise on the best way to set up my app so i can so edit the fields used as the Primary Key?
I have several Google sheets in my Appsheet app that contain static data (like Personnel Usernames and Location records). I am using these sheets as a reference to another dynamic sheet that display all data. (The dynamic data sheet contains columns that reference the static data sheets)
However, i would still like to be able to edit the primary key in the static data sheets (as usernames for my users change from time to time) . Can anyone offer advise on the best way i can organize my sheets to do this?