Discussions

Expand all | Collapse all

Too many entries in multi-select text field. Need solutions, please?

  • 1.  Too many entries in multi-select text field. Need solutions, please?

    Posted 10 days ago
    I have an app for project managers. When they create an activity, they can assign that activity to a project team member or other resource. The Assigned To field in the Activities table is a multi-select text field. The Assigned To field is pulling from the Resource Name field in the Resources table. As project managers identify new resources, they can add those resources to the Resources table. The problem now is the Resources table has 118 resources. The Assigned To field, being a multi-select text field, can only handle 100 maximum entries (I didn't know that when I set up the field. Argh!). So, now I can't edit that field, because when I do, I get this error: Choices too long. 118 choices specified. Field may not have more than 100 choices. And over time, we're going to have more than that.

    My research shows I should have created a one-to-many relationship between the Activities and Resources tables and use the reference field as the source for the dropdown. So, I did that. The problem is I can only select one resource. We need to be able to select multiple resources that will work on that activity, hence why we originally set it up as a multi-select text field.

    Ideas anyone?? Thank you, in advance, for your help and consideration!

    ------------------------------
    Tom
    ------------------------------


  • 2.  RE: Too many entries in multi-select text field. Need solutions, please?

    Posted 10 days ago
    Edited by Michael Tamoush 10 days ago
    TL/DR: Link to a formula field with less choices, then change the formula field to all the choices.

    You can trick the system. In your resources table, make another field 'Resource Name for MultiSelect'. This should be a formula text.

    Link your multiselect to this field. AFTER you have it linked and saved, make your formula in the new field you created [Resource Name].

    Now you will have all the choices.

    The trick is, any time you want to edit and save the original multi select field, it will give you that error. So the process in the future is, comment out the formula field so there are 0 choices (or you can make the formula whatever you want, so long as its under 100 choices), edit and save your multi select field, un-comment your formula field.



    ------------------------------
    Michael Tamoush
    ------------------------------



  • 3.  RE: Too many entries in multi-select text field. Need solutions, please?

    Posted 10 days ago
    In the long run, a better approach is to have a many to many relationship. One Resource has many Resource Activity Assignments.  And one Activity has many Resource Activity Assignments.  There is a technique that I could help you implement which would allow you to quickly add resources to a particular activity.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------