Discussions

Expand all | Collapse all

Using a shared field with multi select text

  • 1.  Using a shared field with multi select text

    Posted 21 days ago
    I would like to have a multi select text field, where the choices come from a combined text field. Is that possible? I can convert the combined text field into any format needed, but I'm not sure what the multi select field would need.

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Using a shared field with multi select text

    Posted 21 days ago
    Mike,

    Use a relationship instead of a multi text.



    Have the Formula Text field be the proxy for the Parent Table.

    I would recommend that you create a parent table instead of using the text field.  It is a little longer to build but is much more stable in the long run.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 3.  RE: Using a shared field with multi select text

    Posted 20 days ago
    Mike,

    If I'm understanding your question correctly, the short answer is that combined text fields are by nature Multi-Select Text fields, though they are static. To make them editable, you need to use an automation to copy those values into another (non-formula) Multi-Select Text field.

    A more complex answer, which may or may not speak directly to your challenge, I discovered just yesterday. I found the help documentation on Formula - Multi-Select Text fields to be helpful, particularly the section about combining checkboxes.
    https://help.quickbase.com/user-assistance/formula-multi-select-text.html

    My situation was similar to yours, except I had nested Combined Text fields (summary field of summary fields) that I wanted to convert to a single editable Multi-Select Text field. I used the following formula in a Formula Multi - Select Text field to convert the nested combined text field into a static Multi-Select Text field, using as many Part functions as I anticipated options being selected (or more, the result is null if there are not that many Parts in your string so not an issue to have extra functions).

    var text combinedlist = ToText([Combined Text Summary Field]);  

    Split(
         List("; ",
              Part($combinedtext,1,";"),
              Part($combinedtext,2,";"),
              Part($combinedtext,3,";"),
              Part($combinedtext,4,";"),
              Part($combinedtext,5,";")
         )
    )

    Since I wanted this field to be editable, I then used an automation to copy the result from the Formula field into a regular Multi-Select Text field, and now I can modify the values if I'd like.

    Note that I needed the ToText() and List() functions only because I was summarizing existing summary fields (combined text of combined text) and therefore needed to split my field beyond just the first layer into the full semi-colon-separated list. If I was going straight from a simple text field that is already in list (semi-colon separated) format to the Multi-Select Text, I believe you can just use the Split() function.

    ------------------------------
    Oana Toma
    ------------------------------