Skip to main content
Question

Text-multiple field - Maximum input values

  • October 16, 2019
  • 0 replies
  • 52 views
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
------------------------------
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
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
------------------------------
Forum|alt.badge.img+12
  • LauraThacker
  • Registered
  • October 16, 2019
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
------------------------------
Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
Terms & ConditionsAccessibility statement