Retrieve info based on Array Index

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 Like

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.

1 Like