Skip to main content

I am trying to figure our how to use rollups. 

Let's assume I have a list of applicants and associated interviews. The interview has "interviewer name" field.
So
applicant1 -> (interview1; interview2)

Interivew1: John
Interview2: Rebecca

I am creating a roll-up and trying to figure out how can I access interviewer names (John, Rebecca).
Rollup references gives some formulas that can be used in rollups, but is there a way for me to access the values?

Let's say I want to send an automated email and sign it with the name of one of the interviewers. 
1. SQL allows me to do something like ANY() to get a random name from the list of interviewers. 
Is there something similar in Airtable?
2. What if I want to SORT BY interview date and access the name of the FIRST interviewer? (so not just any, but also do some manipulation with the array) is it possible?

Thanks!

Be the first to reply!

Reply