Thanks Mark,
Got it. As I was typing, I was thinking that was the case.
So if I ran a pipeline every morning that checks for records with the send date of today and sets the checkbox to true, would that work? I'd make the "send today" checkbox just a checkbox, rather than a formula checkbox. Does that count as making an actual update to the record?
Qrew LegendYes. Exactly. That should work perfectly.
when a pipe line runs in a For Each loop, QuickBase sees these as individual record changes and will fire off individual Notification emails.
Thanks Mark,
So, I want to look for all records where the TR1 reminder date is equal to today, but I can't see how to do that. What am I missing?
I don't see an "Equals" or "Is" option. Is there another way to search?
Thank you,
Qrew LegendThe low tech solution is to just make a formula checkbox field in your Quickbase table. Then you have a clean checkbox field to hook on for your formula.
That works. Thanks again Mark.
Happy Canada Day!
