Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Send email when a record exit a view

Topic Labels: Automations
847 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Les_Gros_Becs
6 - Interface Innovator
6 - Interface Innovator

Hi all!

I need help with something! We use timesheets on Airtable for our staff. For each activity, we add staff members and use an automation to notify them via email about their new shift.

I would also like to find a way to notify them via email when they get removed from a shift. So here is what I would like to use :

  • When record exit a view (i.e. the employee’s schedule), send an email
    OR
  • When the name of an employee is removed from the ‘‘Ressource’’ field, send an email to that employee

Best,

David :slightly_smiling_face:

1 Reply 1
Bill_French
17 - Neptune
17 - Neptune

Detecting and acting upon the NULL is dicey. You also can’t act upon a deleted record (unless you use the Enterprise Events API). So, you are forced to do a little more work by moving shift changes through a view-based workflow - i.e., just have unassigned shifts flow into a view and announce based on that appearance in the unassigned view, a view that not only knows there’s no assigned shift, but the record also indicates it previously did have a shift.