Hey . In a Gsheet I have a customers list builds with my app sheet form.
The first filed is “ID”.
Now I need that in my app sheet (in another tab) when I tip a Customer ID the system automatically update all the fields in gsheet (second tab) and in the app form too.
Can someone help me please?
There is not enough information on your app structure and mechanism, but you can try:
[yourColumnWithTypeRef].[ColumnYouWishToRetrieveInformationFrom]
What does “tip an ID” mean?
Sorry it mean that when I insert an ID the rest of the row fields
automatically update in App with the other data bring from the sheet .
Thanks
I think this is my understanding in the first post.
Maybe this documentation will help you ?
It’s not clear from your post whether your app is explicitly configured to use both worksheets. If not, the app cannot make any changes to the sheet that isn’t connected. But if the unconnected sheet has spreadsheet formulas that make use of values in the sheet the app does use, those formulas will be recalculated when the app makes changes. Does that answer your question?
Thanks Steve,
I will try to better explain my needs.
I’ve a spreadsheet with 2 sheets (or tabs) and an App connected with it.
The first sheet is a “seller” sheet and the second is a “buyer” sheet.
Now I need that (in the app) when I type an ID in a field named “Seller
ID” automatically the other seller fields about this ID (Name, phone,
ecc) are brought from the “Seller” sheet and appear in the form. I hope
it’s clearer now.
–
+39 3281638511
Ah! Yes, that’s easily doable, using Initial value and dereferences:
Fantastic!!! It’s exactely what I need! Thankyou very much Aurelien.
Fantastic!!! It’s exactely what I need! Thankyou very much Steve.
