Skip to main content

Field names have to be hard-coded into a formula, which makes it so you can't do something like indicate which field name to pull from in a multiselect field. You can only use a switch with hardcoded field names, or use a whole bunch of if statements to make different things happen depending on the multiselect options. I'd love to be able to write like:

FIELDS({multi-select that says which fields to return})

and have that return the value of all those fields as an array

It’s a great idea, but unlikely that Airtable will add this. However, this is a built-in feature of FileMaker Pro, which is the database system that was used as the inspiration for Airtable.


Reply