Automation scheduled contingent on DB value

Ask the community
, ,
1

For my site, I’m using Corvid to handle new members. My site has a training component where once they complete the training, it sets a trainingComplete value in their row of the Members collection to true. I want to send users who have not completed this training an email reminder after a week.

Here are my ideas:

  1. Use Wix Automations. Trigger is a member approved. Automation is send email. It occurs after 7 days. When the training is completed, this automation is cancelled.

  2. Trigger the Automation as normal. The automation, after 7 days, should call a backend web module script that checks what the trainingComplete value is, and sends an email from the code if necessary.

  3. If an email must be sent, the email content is different based on the value of the trainingComplete value.

Are any of these feasible? I’m a bit stuck.

2

Okay the magical discussion board hasn’t provided an answer, but I’m going to do a workaround invented in my knowledge box.

We have cron in Wix right? So let’s schedule every day at 8 am ( “cronExpression” : “0 8 * * *” ) to run a script that will check which users have not trained and have 7 days since becoming a member by checking the database. If it finds such users, send an email using the email automations.

3

Bump… looking for similar feature

4

This is actually what our team’s going to be using in development. I had a function in a JS backend file to do the checks. Then, I scheduled for the function to be called every day at 6PM. Pretty simple and effective. Is this the same thing you are trying to do?