Copy/ Autofill feature in appsheet form

So, I have 2 Google sheet, each has 7 tabs (different cities but same columns) in it. I want to transfer data from sheet 1 to sheet 2 by a copy feature or autofill. Autofill like once I filled the unique id (from sheet 1) in sheet 2 form, the common fields should autofill. All the coulumns in sheet 1 is present in sheet 2 but sheet 2 has extra columns too. Please Help me!!

You may wish to take a look at the referencing / dereferencing between tables.

Sample App
https://www.appsheet.com/samples/A-basic-demo-of-table-references?appGuidString=6ffad040-b04a-4325-aa73-ace5df8ba1b5

1 Like
1 Like