Forum Discussion

VivekVishwanat2's avatar
VivekVishwanat2
Qrew Cadet
6 years ago

Can Change in formula field trigger a Notification?

Hi,  I have Created a Notification field, which has to be triggered every day. So I created a Today() field(a Formula-date field). --> Whenever Today() field Changes, trigger a Notification. But, ...
Formulas and functions
NotificationsEmail
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
QuickBase cannot natively send out email notifications based on formula Fields which changed due to the passage of time. 

The only native tool we have in QuickBase which can run things based on a certain time of day is a pipeline. You could probably contrive a pipe line that would run every hour (Well in fact, you would have to create your perfect pipeline and then copy it eight or nine times to cover every hour of the day)  And this would then need to update records which are past due in order to trigger an email.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
SrinathM_R2's avatar
SrinathM_R2
Qrew Member
5 years ago
Thanks Mark. But that will be a lot of step run consumption for us since most of our activities are short term.

------------------------------
Srinath MR
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Well QuickBase does not natively support Subscriptions based on the time of day.  I guess that you will need to calculate how many step runs would be used if it runs every hours for 10 hours a day, for example.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    5 years ago
    Srinath,

    Look at Juiced Triggers.

    https://www.juicedtech.com/triggers

    Their Scheduled Trigger can be set to the minute.  I use them to check and uncheck a field which then fires a Notification.  Very easy.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------