I’m wondering if what I am looking to do can be done via an out the box automation, or if I need a script writing. Or both!
In short, we are a villa rental agency and send an email to our property owners regularly to ask them to update us with their latest availability. We are then updating the ‘last updated on’ date field at property record level as and when we receive the updates.
I was then going to run an automation to send an email to the owner when the ‘last updated on’ date is more than 7 days ago. This would then run in the background and would email owners accordingly when the availability data is out of date by 7 days, correct?
However, in some cases owners have more than one property and may have recently updated us on one of them, but not the others, so ideally we would implement something that could check the owner record first for the total number of properties linked to them, then check the last updated on date for each and then bring across the name of each property that is out of date into the email. For example if an owner has 3 properties and 2 are out of date, the automation would only include the names of the two properties that are out of date in the email body…
Does anyone know if this would be possible?
Many thanks in advance!