Formula: How to pull the value out of the JSON object returned through Linked Table column?

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: