Concatenate A field based on if a checkbox is checked

Question

I'm trying to create a formula based on the following and having no luck. If you have any suggestions they would be truly appreciated.

If [New Medical Plan] is not null OR [New Dental Plan] is not null OR [New Vision Plan] is not null Concatenate [Control],[Suffix],[State]

Thank you

------------------------------
Kathy Benjamin
------------------------------

markshnier__you · Accepted Answer

Sure,Can you tell us the field type of these fields?[New Medical Plan][New Dental Plan] [New Vision Plan]&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

Right, sorry, I guess that was in your headline.

I'm a checkbox field is inherently true or false so you can just do this.

If([New Medical Plan] OR [New Dental Plan] OR [New Vision Plan],

List(", ", [Control],[Suffix],[State]))

In the code above I am separating those three fields with a comma, and a space.

Note that you could also do this if it makes you feel better for readability, but its not necessary.

If(
[New Medical Plan] = true
OR
[New Dental Plan] = true
OR
[New Vision Plan] = true,
List(", ", [Control],[Suffix],[State]))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

kathybenjamin · Answer

Checkboxes------------------------------Kathy Benjamin------------------------------

kathybenjamin · Answer

Thank you.&nbsp; Worked perfectly!------------------------------Kathy Benjamin------------------------------

Forum Discussion

Concatenate A field based on if a checkbox is checked

4 Replies

Related Content

Autofill user field when a checkbox is checked

Rule If Checkbox1 is Checked then Uncheck Checkbox 2 not Working

Pipeline to Concatenate Text and Increment Numbers

Checkbox in Docusign

Defaulted checkbox

Recent Discussions

Updating predecessors in a pipeline

Create Child Record, Save and then Edit button

Date to show as MMM YY

Pipeline Make Request - Return Make Request JSON Output into fields

An API(?) button to copy fields from the form, to other fields