Copy/ Autofill feature in appsheet form

[sainikhushdeep]

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!!

[Suvrutt_Gurjar]

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

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

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

[Steve]

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.