I’m trying to create a notification and need some help in designing it.
I have a table called Commitments, with a child table called Ratings.
I’d like to run a per user query on Friday and Saturday morning to:
- check the Latest Ratings column for each row in the Commitments table for any items that have not had a Rating within the last 7 days.
- And then send one notification for each commitment that needs a rating.
The default template does this by itself but I want to create my own template.
Here’s what I have:
‘<<_USERNAME>>’, Don’t forget to head over to ‘<<_APPNAME>>’ and rate your week. How well aligned were your actions and results with your commitment to ‘<<[Commitment]>>’ for this week?
Here’s the result of that:
elan, Don’t forget to head over to Stryze Pro and rate your week. How well aligned were your actions and results with your commitment to ‘Commitment’ for this week?
I want the word commitment to be replaced with the actual name of each Commitment.
I also want to be able to include a deep link that points back to that Commitment row in the table
- Is there a way to accomplish the above?
- Is there a simpler way to design this?