Two part question:
I have a start date and end date in my Contracts collection that users will enter. I need to calculate the number of days of each Contract and trigger a series of emails based on the number of days of the contract.
How to trigger the email series without any corresponding Adalo action. A Contract of 180 days or less will trigger a series of 5-10 emails. A Contract of 365 days or more will trigger a series of 20-30 emails. I think the Zap will look for a new record in Contracts collection in Adalo, and use the “Delay” function in Zapier, followed by a Sendgrid (my ESP) email, and then loop another Delay, followed by another Sendgrid email, etc until I’ve finished the email series.
I would be more than happy to pay someone to create this workflow for me in Zapier or Integromat, using dummy emails and arbitrary delays of 10 days. I can replace with my own. I just want to launch my app already! I’ve written a few experts who are all busy (this is good for Adalo, people are building!).