Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula for rich text

3189 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

Hello!

I need help trying to make these comma separated fields into a bullet rich text format and the extra comma’s to be removed at the end if they are present, help please!

55 Cards, 1 Rulebook with 5 Mini-games, 1 Tin, , , , , , , , , , , ,

Looking for:

  • 55 Cards
  • 1 Rulebook with 5 Mini-games
  • 1 Tin

Thank you as always!

10 Replies 10

Hi @Scott_Gardner1 ,

What is the field type of the original field? Because if it is a Lookup or Rollup then you dont need to worry about the comma.

The extra commas make it seem its a Lookup or a Rollup

I did a concatenation in excel, but I could do a roll up in Airtable and then I would just copy the data and paste it in an open non formulated field ideally that is set up like I had listed in the rich text bullet format. So as it stands, how do I get from comma separated to a bullet format?

If this is a rollup, try

IF(
  values,
  "- " & ARRAYJOIN(ARRAYCOMPACT(values), "\n- ")
)

Then if you want to move the result to a rich text field for true bullets, move it over using an automation or using cod. A regular copy/paste from the user interface will not give you actual bullets.

Scott_Gardner1
7 - App Architect
7 - App Architect

Thank you!

So I have this:

ARRAYJOIN({Component 1}, ", ")

& ", " &

ARRAYJOIN({Component 2}, ", ")

& ", " &

ARRAYJOIN({Component 3}, ", ")

& ", " &

ARRAYJOIN({Component 4}, ", ")

& ", " &

ARRAYJOIN({Component 5}, ", ")

& ", " &

ARRAYJOIN({Component 6}, ", ")

& ", " &

ARRAYJOIN({Component 7}, ", ")

& ", " &

ARRAYJOIN({Component 8}, ", ")

& ", " &

ARRAYJOIN({Component 9}, ", ")

& ", " &

ARRAYJOIN({Component 10}, ", ")

& ", " &

ARRAYJOIN({Component 11}, ", ")

& ", " &

ARRAYJOIN({Component 12}, ", ")

& ", " &

ARRAYJOIN({Component 13}, ", ")

& ", " &

ARRAYJOIN({Component 14}, ", ")

& ", " &

ARRAYJOIN({Component 15}, ", ")

And I need a formula to remove the empty “,” if the Component is blank.

I am currently getting this: 6 Custom sculpted dice, Tin carrying case, , , , , , , , , , , , , (Since only 2 of the components are filled in.

Can you share a screen shot of your input fields?

Capture

They were just look up fields but I just changed them.

Scott_Gardner1
7 - App Architect
7 - App Architect

Capture

It looks like all the fields are single line text fields. Try this pattern.

TRIM(CONCATENATE(
  IF({Component 1}, "- " & {Component 1} & "\n"),
  IF({Component 2}, "- " & {Component 2} & "\n"),
  IF({Component 3}, "- " & {Component 3} & "\n"),
  IF({Component 4}, "- " & {Component 4} & "\n"),
))
Scott_Gardner1
7 - App Architect
7 - App Architect

Perfect!! Thank you.

So now how do I turn these into the rich text bullet format?

-1
-2
-3
-4

Thank you again.