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:
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |