Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 11, 2018 07:38 AM
I have an Employee Directory Base. My employees have professional licenses that have expiration dates. Is there a way to have it notify myself and/or the employee when the expiration date is coming up?
Oct 11, 2018 07:45 AM
I would make a new view “Licenses Expiring Soon” with a filter Expiration Date > “Is Within” > “The Next Month” or however soon you want to be notified.
Then use a Zapier integration “Get notifications about new Airtable records in a view via email”
Oct 11, 2018 07:48 AM
Hi Rebecca
Natively, in airtable, you could create a filtered view which would contain people due (say in the next month) those who’d expiration dates are approaching.
A better alternative would be to use Zapier or Integromat to alert you on the relevant day. I would use Integromat for this particular requirement because it’s able to query an Airtable base such that you could have the process run once a day and look for records with, say, today’s date as a reminder date - this is simpler that having to set a specific filtered Airtable view to filter records for Zapier.
Hope this helps!
Jun 27, 2019 09:09 AM
Hi Julian,
What is the code to do this in Integromat? I am trying to receive an email or slack notification about tasks when their due dates are 3 and 10 days away.
Jun 27, 2019 09:50 AM
If you’re using Slack, you can do as @drassi suggests and create formula fields that use DATETIME_DIFF()
to flag records where due dates are 3 and 10 days away. Then create a view filtered to show records new to that view, one that shows records where {Due In 3} = 1' and another showing records where
{Due in 10} = 1`. Finally, follow the instructions here to use Airtable’s built-in Slack integration to send notification whenever a record enters one or the other view…
Jun 28, 2019 04:02 AM
To answer the specific question about Integromat, you would use a Search Record option looking something like this (for the 3 day test):
Note that the Formula uses Airtable’s formula syntax.
Whatever you want to do next would then run for each record which matches the criteria. It’s even fairly simple to group together records so that a person could get a single email listing all tasks due that day.
Hope this helps.
Jun 28, 2019 06:16 AM
Many thanks to you both. I was able to use Zapier after creating two separate views for 3 days out and 10 days out.
Aug 21, 2019 08:42 AM
Hey @Julian_Kirkness ,
I’m trying to do something very similar with Integromat where I am alerted by email when certain employment length milestones are hit, see image below. It keeps saying Formula invalid but it appears to be correct, what am I missing? Field is Employment Length (Y) and I want the trigger to be once the field (which is a calculated formula field) says “0 years, 3 months”.
Aug 21, 2019 11:45 AM
Just tried a similar search:
and it worked as expected - I even tried changing the field name to {Length of employment (Y)} and it still worked (I wondered about the brackets in the field name). Have you checked you don’t have a typo in the field name?
Aug 21, 2019 12:04 PM
Wow, embarassing. I shortened the field to make it simpler and it must have been something where I missed a parenthesis . Thanks again Julian, brilliant as always.