Refrence Issue

[CA_Ankur_Patida]

I have got a “Party Master” spreadsheet with columns :

Timestamp | Date | Party Name | Pit Holder | GSTN | Attachment

and “Billing Details” spreadsheet with columns :

Timestamp | Date | Seller | Party Name | Pit Holder | GSTN | Vehicle No | Product

Now i want that while filing the “Billing Detail” form user should directly get value for [Pit Holder] and [GSTN] after selecting the [Party Name] based on the "Party Master’’ spreadsheet.

Please help.

[Steve]

help.appsheet.com

App Formulas and Initial Values

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

help.appsheet.com

Dereference Expressions

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

[CA_Ankur_Patida]

thanks steve!