Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula Help Needed: Multiple Checkboxes into one text field

Topic Labels: Formulas
Solved
Jump to Solution
311 6
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m looking for help with a formula/script/automation. I have 5 fields that are checkboxes noting a user’s role. Some users have none checked, some have some, or even all. Also, these fields may be updated at any time by the user, so need something that updates automatically (both adding or removing a role).

I need another field that uses the title of the checkbox field (or text I provide), and puts them into one field. I’m struggling with adding commas, because they only need a comma if another role needs to show up behind the prior one.

Screen Shot 2022-09-19 at 5.40.58 PM

1 Solution

Accepted Solutions

I forgot a comma on one line. Try again.

See Solution in Thread

6 Replies 6

Hi @Ashley_Eidbo,
Is there a reason that the options are checkboxes?

Why not a multiselect or link to another record. Then you would not need a formula at all.
image

In any case, post your current formula and I can try to help you remove the commas.

unfortunately I need to keep the checkboxes for some integrations that run off of it. I do, however, have some formula fields with the correct words showing. Those formulas are: IF({Curricular Lead}=1

,“Curricular Lead”)
Screen Shot 2022-09-19 at 8.54.02 PM

The formula in the prior screenshot is coming from those: CONCATENATE({CL for HS},", “,{IL for HS},”, “,{SL for HS},”, “,{IA for HS},”, ",{TC for HS})

I’m assuming I need many IFs for this to work, but everything I try gives me an error.

REGEX_REPLACE(
  CONCATENATE(
    IF({Curricular Lead, "Curricular Lead, "),
    IF({Implementation Lead},"Implementation Lead, "),
    IF({School Leader},"School Leader, "),
    IF({Inquiry Advocate},"Inquiry Advocate, "),
    IF({Tech Contact}, "Tech Contact, ")
  ),
  ", $",
  ""
)

I copied and pasted this, but I cannot get it to work (keep getting an error and cannot save). I’m not familiar with the dollar sign in this context, but wondering if that’s the issue? Any other ideas?

Thank you so much for your help.

I forgot a comma on one line. Try again.

it worked! thank you SO much. have been trying to figure this out for awhile.