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

Retrieve info based on Array Index

Showing results for 
Search instead for 
Did you mean: 
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)

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

1 Comment
18 - Pluto
18 - Pluto

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


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