Skip to main content
Question

Need Solution for Automated Notifications

  • March 17, 2023
  • 0 replies
  • 128 views

Forum|alt.badge.img+6

Hello All,

Happy St. Patrick's Day!  I have a group of people that I need to remind to sign in to a website every 30 days after their last sign-in.  I thought I had this all vetted out, but now after I've rolled out the new process, I've noticed one hiccup: 

I have a formula checkbox that will automatically check itself when today's date is 30 days after their last sign-in date.  This is supposed to trigger a modification notification that then sends them an email with instructions to sign back in.  However, the formula checkbox doesn't actually count as "modifying" the record.  So, I have to do this manually until I can figure out a fix.  Any ideas? 

I was thinking I could possibly create a pipeline that modifies a new field -- let's call it "today" date field -- on a daily basis, which I'm hoping would trigger the email to be sent.  Anyone have any insight or a similar experience they can relate to?



------------------------------
Aidon Olligschlager
Flight Support Specialist
Pentastar Aviation
Waterford MI
2482029587
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • March 17, 2023

You are on the right track. I would set up a date/time field called [date/time to trigger email].

Then set up a pipeline to run daily looking for any notifications that are due to be fired today and update that field with the current date/ time

you can use this for the current date and time.

{{ time.today }}



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------