Skip to main content
Question

Can Change in formula field trigger a Notification?

  • September 17, 2019
  • 0 replies
  • 39 views
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, This is not working. --> I suppose Quickbase is not considering the change in the Formula field as a Change to trigger the Notification.

Please Help me in this situation.



Thanks



------------------------------
Vivek Vishwanath
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • September 17, 2019
Hi Vivek,

Unfortunately a notification cannot be triggered off of a formula field updating due to a change like the day rolling over. Notifications trigger off of an action taken on a record that saves and updates it. So things like an update to the record via the form, grid edit, automations, or API could all trigger a notification to go off. If this is something that needs to go out daily you may want to look at the options available for subscriptions where you can send out a report of records that match a certain criteria on specific days of the week/month. Then you could use that formula field to indicate which records should be on that report each day and pick out a list of users in your app that subscription should go to. You can learn more about subscriptions here.

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Terms & ConditionsAccessibility statement