I’ve been working on an automated loop for a couple of weeks and I don’t seem to be making much progress. This is for a research participant database.
I have a record of the last time they were contacted. In 90 days past the date of last contact, I would like an email sent automatically asking if they would like to continue to be in our database. They fill out a form, hopefully with their names/usernames/emails/phone numbers already populated, but with the option to edit their personal info in case something has changed. The form also asks if they want to participate in future research. This form automatically updates their entry in the database and timestamps when they opted in/out of future research. After 90 days, those who opted in get another automated email, and the cycle repeats.
So after a couple of weeks of research/trial/error, this is the process I imagine I should be creating but have not yet been successful in executing:
I’m trying to get Integromat to identify when the field “Next Contact Date” is =TODAY. When this happens, it creates a new record in the “Interactions” table of my database. This new entry triggers the automated email via Zapier, which contains a link to a form (not sure if I should be using a FormNano or simply the “form” view of another table in my database). I would rather have the “next contact date”=Today to trigger the email, but that doesn’t seem to be an option. The research participant fills out the form, which automatically updates the newly created record in the Interactions table with the questions I’ve asked (name, email, future participation?). This is record update is timestamped, 90 days is added to the timestamp in the “next contact date” field, and the cycle continues.
I’m getting a little lost in which 3rd party apps do what. Just generally integrating the 3rd party apps into airtable has only partially worked, mainly because the options they give for setting them up are not quite the options that I feel like I need. Any advice would be great. Thanks