Automatically custom filed update when I tip an ID

[Denis_Dal_Soler]

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?

[Aurelien · Accepted solution]

Hi @Denis_Dal_Soler 

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:

[Steve · Accepted solution]

What does "tip an ID" mean?

[Aurelien · Accepted solution]

Hi @Denis_Dal_Soler 

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:

[Denis_Dal_Soler]

Fantastic!!! It's exactely what I need! Thankyou very much Aurelien.

[Steve · Accepted solution]

What does "tip an ID" mean?

[Denis_Dal_Soler]

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

[Aurelien]

I think this is my understanding in the first post.

Maybe this documentation will  help you ?

Dereference expressions - AppSheet Help

[Steve]

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?

[Denis_Dal_Soler]

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.

--


denisdalsoler.com

+39 3281638511

[Steve · Accepted solution]

Ah! Yes, that's easily doable, using Initial value and dereferences:

Define App formulas and Initial values - AppSheet Help

Dereference expressions - AppSheet Help

[Denis_Dal_Soler]

Fantastic!!! It's exactely what I need! Thankyou very much Steve.