I am trying to set up an automation to change the status of a project from “currently active” to “past” if the date entered in the end date field is before today. Yet when I create a new record with an end date in the future, the automation I’ve curr...
Could someone help me create a formula for the following scenario? We run an accreditation system, and have a policy that went into effect on January 1, 2018 saying that programs have five years from the date of their application to submit their repo...
I would love if someone could help me work through how to set up a formula for the following situation. We have a volunteer application form for which we ask for applicants to provide 3 references. When determining whether to approve their applicatio...
Hi there,
I’m new to Airtable and we’re setting up a database for our accreditation system. I have a table for Institutions and another table for Programs at said institutions. I want to link to the programs table from a field in the institutions tab...
I’ve got a partial formula working here that is returning the correct expiration date for those who applied on or after 01/01/2018, and returns a blank if no application date was entered. Now I just need help incorporating the other part of the equat...
Thank you! That’s not quite what I was hoping for (was hoping I’d be able to still have them act as linked records rather than just text) but it’s certainly good enough if that’s the only option.
Is there any way to separate the multiple programs in ...