Hi all...seems like this relates to the new Realtime Database functionality, but would really appreciate if someone could help me connect the dots here.
I've got a table with a column that auto-updates every hour, that calculates the remaining weeks in a user's pregnancy. This column updates via a scheduled task, with the result based on the difference between their pregnancy due date, and the current date and time. The scheduled task runs through a series of functions and returns that data (the difference between [current timestamp] and [pregnancy due date] as a decimal. The records I need to pull are tagged with this decimal. For example, if a user is 12.325 weeks pregnant, the goal is that in the front end, they will view all records tagged 12.325.
So yes...trying to figure out how to create a trigger where a database record is pushed to my front end, based on a tag that matches the number of current weeks pregnant. My thought is--I could use a conditional (IF <[decimal] and >[decimal], THEN-->)...I just don't know how to pull a tagged record in the THEN section.
In a nutshell: how do I create a trigger to push the correct tagged record to my front end, based on the current contents of the auto-update column?
Also...does it make sense to do this via database triggers, or a scheduled task?
TYSM.