Creating a blackout date in Airtable calendar

643 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there,

I'm working on an integrated communications calendar for the upcoming year, and there are some dates where we do not want multiple communications going out. So, I'm trying to figure out the best way to either black out the date (i.e. if someone enters the date no comms should go out when creating a record or filling out a form to create a record, they are forced to choose another date), or at least have a prompt that says "no communications this day, please select another date." Unsure if this would be a function, automation, etc. -- slightly new to Airtable, so any insight would be helpful. Thanks! 

1 Reply 1
7 - App Architect
7 - App Architect

Hi @JennaC

This is unfortunately not a native feature to Airtable, and wouldn't be possible with current capabilities. 

The best option I could suggest to address this issue is to allow your form to be filled out with any date, and then create an automation that checks all new submissions to see if they fall on a blackout date. If it did you could email/slack the submitter to let them know that the date needs to change and input a dynamic link back to the record to redirect them to Airtable to do so. This does assume all form submitters have access to your Airtable, and that you know who is submitting the form.