Forum Discussion

RyanAnderson2's avatar
RyanAnderson2
Qrew Cadet
6 years ago

Text-multiple field - Maximum input values

For the field type called Text-Multiple Choice, how many values can be stored in the Input Type when the "From List" is selected?  Is there a maximum noted anywhere as I'm not finding it.  Not sure if the max (if there is one) changes based off the type of values you store either.

Thanks

------------------------------
Ryan
------------------------------
Tables and fields
  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    6 years ago
    How many are you trying to put in the list? Most likely it's not an actual limit, but rather a best practice not to do that as it could affect the size and/or performance of your table.

    Typically, you would store those values in a different table, use a relationship and downdrop to select. (If over 1000, the dropdown will not show any choices and you have to search)

    ------------------------------
    Everett Patterson
    ------------------------------
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    6 years ago
    If you are concerned about the number of options; instead use a table to house your list of options. Make the Key Field the field-value; and this can then be connected by relationships anywhere across your Application.  The advantage/benefits of this are that you can add other characteristics about the field value option that can be used in your relationships; and you get the use of Summary fields to tell you where those options are used.

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------
    • RyanAnderson2's avatar
      RyanAnderson2
      Qrew Cadet
      6 years ago
      Thanks.  Mostly you gave what I was looking for.  Seems there is no real max, but it will affect performance, so it's best to generate a "best practice" when deciding on the number of values you add into this field compared to using a table relationship instead.

      ------------------------------
      Ryan
      ------------------------------