Need Solution for Automated Notifications
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 aft...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou 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
------------------------------
Mark,
I had some trouble with the {{time.today}} on the updated records. Some kind of error saying "today() is invalid," so I tried a different approach:
I created two fields: "previous count" and "new count." Previous being a numeric field, and New being a numeric formula field that adds 1 to Previous. I then created a pipeline that updates Previous Count with the New Count daily (effectively counting up by 1 every day). This seems to be working - the record is modified everyday in this regard, so if any one of my checkbox fields are marked, the emails will be sent out accordingly.
Appreciate the help! This is pretty much my first pipeline I've created, and I can see just how helpful this feature can become.
------------------------------
Aidon Olligschlager
Flight Support Specialist
Pentastar Aviation
Waterford MI
2482029587
------------------------------
