Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
2 years ago
Solved

Concatenate A field based on if a checkbox is checked

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
------------------------------
  • Sure,
    Can you tell us the field type of these fields?
    [New Medical Plan]
    [New Dental Plan]
    [New Vision Plan] 


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

4 Replies

  • Sure,
    Can you tell us the field type of these fields?
    [New Medical Plan]
    [New Dental Plan]
    [New Vision Plan] 


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • KathyBenjamin's avatar
      KathyBenjamin
      Qrew Trainee
      Checkboxes

      ------------------------------
      Kathy Benjamin
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------