Skip to main content
Solved

Format values from multiple fields (formula or automation)

  • July 19, 2023
  • 2 replies
  • 17 views

Briana_Wertalik
Forum|alt.badge.img+7

I am hoping there is a formula to achieve this... but not sure. I want to automatically generate the formatting that is in the "IDEAL" field on the right, that way this does not have to be done manually.

Any help/thoughts would be appreciated!

Best answer by Sho

In this case, Add a Formula field to the "Speaker" table and generate a string in that format.
Reference the field you added in the Rollup field to that table (Session?).
Rollup Field Formula : ARRAYJOIN({field name},"\n")

How about this?

 

2 replies

Forum|alt.badge.img+21
  • Inspiring
  • 560 replies
  • Answer
  • July 19, 2023

In this case, Add a Formula field to the "Speaker" table and generate a string in that format.
Reference the field you added in the Rollup field to that table (Session?).
Rollup Field Formula : ARRAYJOIN({field name},"\n")

How about this?

 


Briana_Wertalik
Forum|alt.badge.img+7
  • Author
  • New Participant
  • 3 replies
  • July 20, 2023

In this case, Add a Formula field to the "Speaker" table and generate a string in that format.
Reference the field you added in the Rollup field to that table (Session?).
Rollup Field Formula : ARRAYJOIN({field name},"\n")

How about this?

 


Thank you!!! So much easier than I made it out to be 😓

Worked great using ARRAYJOIN((values),"\n")