Skip to main content

Allow formulas to select field names programatically

  • September 22, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img+3

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 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 23, 2023

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.