Help

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

Retrieve info based on Array Index

cancel
Showing results for 
Search instead for 
Did you mean: 
Zollie
10 - Mercury
10 - Mercury

The formula field reference is missing the most basic array functionality - retrieving information based on index. If implemented, there are many use cases. Here’s one:

Assignments collaborators
Amy, Peter, Tanya

Stage number (int)
2

Current Assignment formula
{Assignments}[ {Stage} ]
=> Peter

1 Comment
Justin_Barrett
18 - Pluto
18 - Pluto

Great idea, though it would more likely be implemented so that your example would look like this:

{Assignments}[{Stage}]

Airtable uses 1-based indexing for strings (i.e. for FIND, SEARCH, etc), so my gut says it would do the same for arrays.