I’m trying to use a Formula that combines the values of a few columns, and one of the columns is a Link to another Table. That column reference returns a JSON value with [{ id: 1, value: ‘VALUE’ }. I just want the value out of it. How do I isolate that given this data structure?
Hello @mpstaton ,
could you please provide more information about your table structure and the formula used in the Unique-String field?
You can use the join formula to concatenate all the referenced values in a single string as shown below.
Also, referencing a Link to Table field should create a field like in the pictures attached below:
Looking at exactly the same. Basically lookup at a JSON field so that I can get several fields from the referenced table. Is this possible?
Found the solution and sharing for the community. It is possible via the REST API by using the {field}__join parameter. Super useful deployment! Cheers
1 Like
Thank you for sharing the solution for future readers, @christos! 