Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 31, 2022 11:08 PM
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:
Thank you as always!
Sep 01, 2022 02:15 AM
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
Sep 01, 2022 07:27 AM
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?
Sep 01, 2022 07:32 AM
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.
Sep 01, 2022 01:09 PM
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.
Sep 01, 2022 01:41 PM
Can you share a screen shot of your input fields?
Sep 01, 2022 02:12 PM
They were just look up fields but I just changed them.
Sep 01, 2022 02:13 PM
Sep 01, 2022 03:57 PM
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"),
))
Sep 01, 2022 04:35 PM
Perfect!! Thank you.
So now how do I turn these into the rich text bullet format?
-1
-2
-3
-4
Thank you again.