Extracting the record ID from linked record and formatting

[Anxious]

I have a situation where I need to display the linked records in a field like this (including the double “” on either end):

[““recFMVIujI5jqSiSD””,““recf8rGUjcM0li5f4"”,”“recztuGU7Tl4GSSYU”"]

Is this possible?

I have this code to format it, I just need the ID part.

'["' & 
SUBSTITUTE(
  {Relations},
  ', ',
  '","'
) & 
'"]'

Which displays:
[“record1”,“record2”,“record3”]

Instead of the record primary field name, I need it to display the record ID in a text field as formated above.

I have a linked record column, then I added a new text field column that grabs the name from that linked column but I need it to be the record ID. Does that make sense?

(replace the name with the record ID in the brackets)

[Anxious]

kuovonne:

IF(
  values,
  CONCATENATE(
    '[""',
    ARRAYJOIN( values, '""][""'),
    '""]'
  )
)

Thanks, that worked! Just tweaked the code a bit. :grinning_face_with_smiling_eyes:

IF(
  values,
  CONCATENATE(
    '["',
    ARRAYJOIN( values, '","'),
    '"]'
  )
)

[kuovonne]

Anxious:

Just tweaked the code a bit.

Glad you got it to work for you. Your original post had double, double quotes, so that was what I was trying to reproduce.

[Anxious]

Yea, I thought they had to be formatted with double quotes in the beginning. I was wrong though, so I had to use single quotes in the end.

Thanks for catching that detail though!