Hi everybody,
In the screenshot below, I try to grab a cell value from the table “Projets”, column “adresse rue” to the table “rapports” in the column “adresse liee”.
I wish to see the same value in both “origin” and “destination” cells. Thanks in advance for your help .
In the adresse liee column formula use:
$reference.adresse_rue
If I understand your question correctly, that should get you what you want.
You can use dot notation from a reference column, in your case reference to get values from other columns in the reference source.
You also have the option, in the settings for a reference column, to add other columns; ADD REFERENCED COLUMNS which effectively adds a new column to your table and sets the column formula the same as I provided above.
This is all pretty well documented in the Grist Help at:
Thanks a lot Phil, It’s working like a charm !
1 Like