I want to automate this but I’m not sure on the setup, maybe this isn’t the best place to ask, but here we go…
I work in a university career center, we use Airtable to manage a student-alumni matching process. Alumni opt-in to be on the list, students can request a connection (OPEN the process), we facilitate via some automated emails, students (ideally) report on the outcome to CLOSE the process, rinse, repeat.
I would like to create a way to limit the number of OPEN requests that any one student has at a time. The unique ID for students is their email address, but we can only collect that via anonymous form because FERPA. So I don’t think we can have a linked table of students to use a count field, unless that can be dynamically created and updated behind the scenes.
So, how can I setup AT so that each time email@example.com submits the from, it will count how many existing requests with that same email address match certain conditions and then flag somehow so we pause the new request until the others are CLOSED i.e. completed? We already do some manual vetting so it’s OK if it’s not fully automated but just some way to indicate this student already has 3 OPEN connection requests, pause on this one for now.
Student form screenshot: