I have a properties sheet. I have a Form Button Add properties, that allows me to create property (UUID, address, type, GPS location)
Show the list of properties in an inline list and when I click on a property it shows me all the details (basic table). I add a Form Button on this details page “Add residents” that allows me to add the different people living in the property (fName, lName, email, contact num, etc…) The residents are held in a different sheet as there could be multiple residents in one property.
I need to link the residents to the property, I have a column called PropertyID in the residents table which I want to set with the UUID of the property. When I click the “add resident” from button how can I carry the UUID of the property I am in to be set in the residents sheet row ?
Thanks