+18The 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
+20Great 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
