Help

Re: Date Past Automation

12552 0
cancel
Showing results for 
Search instead for 
Did you mean: 
AmandaC1121
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I am needing help with an automation. I am needing to change the status of our guest to moved out when the lease end date has past except for when it status is canceled. 

screencapture-airtable-apptbiKrv9KU2WNTS-tblK4kwTcELw2jPeO-viwDP8xhxaw8QEZQj-2023-03-30-19_04_26.png

screencapture-airtable-apptbiKrv9KU2WNTS-tblK4kwTcELw2jPeO-viwB8j2LmHgu9IxV2-2023-03-30-19_05_16.png

2 Replies 2

What is your automation trigger? If your automation trigger is “when record meets conditions” have the conditions be when the {Lease End Date} is before today, and the {EE Status} is not "canceled". Then have an “Update record” action that updates the status of the triggering record. 

if records are created without a lease end date or status (even momentarily for a fraction of a second) you might need to adjust the conditions to take that into account. 

AmandaC1121
5 - Automation Enthusiast
5 - Automation Enthusiast

Now I am getting invalid inputs

screencapture-airtable-apptbiKrv9KU2WNTS-wflYXFn398qm2ZDth-wacRflvhTXB5ArQmg-2023-04-03-12_54_45.png