Skip to main content
Solved

How to Separate Linked Records in a Single Field

  • April 25, 2019
  • 3 replies
  • 53 views

Forum|alt.badge.img+3

My experience with using functions is very limited. Please see my current function and result in the screenshot below (I was not able to post an image to this post, I will try to add it in the comment below).

I would like the result to be:

Brand Guide Webpage or Database - STK, SZ, UWP, TC

What should my function be to achieve the desired result?

Best answer by JonathanBowen

Hi @Reuben - try this:

Intro & ' - ' & ARRAYJOIN(Abbreviation, ', ')

JB

3 replies

Forum|alt.badge.img+3
  • Author
  • Inspiring
  • April 25, 2019

Here’s the screenshot.

Screen Shot 2019-04-25 at 7.59.10 AM.png

Google Drive file.


JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • Answer
  • April 25, 2019

Hi @Reuben - try this:

Intro & ' - ' & ARRAYJOIN(Abbreviation, ', ')

JB


Forum|alt.badge.img+3
  • Author
  • Inspiring
  • April 25, 2019

Hi @Reuben - try this:

Intro & ' - ' & ARRAYJOIN(Abbreviation, ', ')

JB


Thanks @JonathanBowen! Works like a charm.