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: