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?
Solved! Go to Solution.
There is not enough information on your app structure and mechanism, but you can try:
- using dereferenced expression:
[yourColumnWithTypeRef].[ColumnYouWishToRetrieveInformationFrom]
- using action for updating on form save:
What does "tip an ID" mean?
Ah! Yes, that's easily doable, using Initial value and dereferences:
There is not enough information on your app structure and mechanism, but you can try:
- using dereferenced expression:
[yourColumnWithTypeRef].[ColumnYouWishToRetrieveInformationFrom]
- using action for updating on form save:
Fantastic!!! It's exactely what I need! Thankyou very much Aurelien.
What does "tip an ID" mean?
I think this is my understanding in the first post.
Maybe this documentation will help you ?
Dereference expressions - AppSheet Help
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?
Ah! Yes, that's easily doable, using Initial value and dereferences:
Fantastic!!! It's exactely what I need! Thankyou very much Steve.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |