Forum Discussion
Triggering Alert when Data is added
foodd Thank you for this. While this is not an available option yet, hopefully soon the data will be synced with our ticketing system. This may be the route I end up going.
SaiTejaTalasila Thank you, I will explore this.
christinepayton I actually started at the source and the workflow to set this up is not easy to set up. We got about 1/2 way there, but due to an unforseen circumastance, we had to pivot to get notifications up quicker.
I was thinking the UTC conversion may be the issue. I made an adjustment to the timing of refreshes and such and this may have fixed it to give us a workable solution, even if it is temporary.
Thanks all for the responses.
What is your data source? It's usually better to build the notifications onto the source rather than on the reporting end, they usually have a literal trigger for "row added" that you can use instead of checking the latest date on a schedule.
If you want to stick with what you're currently doing, I would try adding hours to the datetime you're using for today's date to convert it to your timezone (and make sure your source timezone matches whatever you're using). What normally happens with these things is they default to UTC, so they will overlap what you think of as "days" if you're far from UTC zone - might be what's causing it to trigger twice.