Hi!
I'm trying to set up an automation for weekly reminders if certain conditions are met / not met, and from what I can tell everything has been entered correctly, yet when I run it to test it seems to fail. Any help is appreciated! Here's a description of the situation and what I have set up:
Several farmers markets have to fill out a form every week, in which they provide their market's name and the date of the market for which they are reporting data. They operate every Saturday. They are expected to fill it out within 7 days of market, so the day before their next market (day 6) is when I would like them to receive a reminder.
TRIGGER: When a date is reached / every week on Friday
CONDITIONS: Where MARKET NAME is equal to [Market Name] AND where MARKET DATE is not in the last 6 days
I've tested this with the farmers market that my organization runs, and I know it's a couple weeks behind on reporting and therefore I should receive a reminder when I run the automation, but nothing happens.