This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Allow formulas to select field names programatically

Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas

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

1 Comment
18 - Pluto
18 - Pluto

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.