How to create a random scenario to trigger others scenarios?

How To
9

My apologies, it’s not as straight forward in Airtable.

  1. In Make, create a scenario that starts with a Mailhook. The second module is a Make Run a Scenario. Or, you can just start the other scenario with a mailhook instead of whatever is triggering it now.
  2. In Airtable, you’ll have a date/time field with the randomly-generated date and time from some other source
  3. In Airtable, you’ll have a formula field that will use DATETIME_DIFF(Date,NOW(), ‘seconds’). This will show the number of seconds until the date/time will be reached, which is a positive number.
  4. In Airtable, create an Automation that will trigger when the record is updated and the number of seconds in the formula is 0 or less (indicating that it is now in the past). For the action, send an email to the mailhook email address generated by Make in the first step. This email action will run the scenario.

I think this should all work.

3 Likes