Skip to main content

Limiting the number of selections in a multiple select field

  • February 25, 2022
  • 2 replies
  • 42 views

I want to create a multiple select field and on the form limit the number of selections. As an example, there would be 10 possible choices but I want the respondent to select five, no more or less. Can this be done in Airtable?

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9814 replies
  • February 25, 2022

Welcome to the community, @Neal_Miller!

That cannot be done natively.

You may want to create 5 different single-select fields for your form, and then create a formula field in your table that concatenates all of the choices together (separated by commas).

After form submission, you can then use an automation to take the formula field and put it into the real multi-select field.

There might be other clever workarounds that others come up with as well.


  • Author
  • New Participant
  • 3 replies
  • February 25, 2022

Thank you for your advice. I will play with it to see what I can do and whether it would be effective in my situation.