Hello,
Here is my test app : https://test-og.glideapp.io
I have a relation field in sheet “Sujets”
Is it possible to add just one or many fields of “Membres” sheet in this screen :
For example, i’d like to add the phone number of the member.
For example, i’d like to add the phone number of the member.
Hello! We call this a ‘lookup’ and will add it as a kind of computed column in a few weeks.
1 Like
Good news, i wait for.
This will be very helpful in normalizing the data in the spreadsheets. Sounds great!
Hi Olivier
Is this what you mean?
If so, here is an option until the new feature is avail. You can use a vlookup in your excel file, in the ‘Sujets’ worksheet. I’m posting another reply separately with another screenshot (at present I’m only allowed one image per post).
You’ll need to add two columns, Membres_Nom and Membres_Tel.
The vlookup formula to use in the Membres_Tel column is as follows:
=VLOOKUP(D2;Membres!$A$2:$E;3;False)
…more to come
Part 2:
In Sujets, you’ll need to add two columns, Membres_Nom and Membres_Tel.
The vlookup formula to use in the Membres_Tel column is as follows:
=VLOOKUP(D2;Membres!$A$2:$E;3;False)
Screenshot here:
Additional info on VLOOKUP here:
https://support.google.com/docs/answer/3093318?hl=en
The reason for adding the Membres_Nom column in addition to the Membres_Tel column is because of how VLOOKUP works…
Per GoogleSheets documentation: “The first column in the range is searched for the key specified in search_key .”
Per Excel documentation: “Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.”
Nom is the first column in the search range from the Membres worksheet …if ‘Nom_Prenom’ were the first column, you could use that.
Good luck!