Help creating Weekly Notifications

[elan_Bailey]

Hi all,

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:

1. 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.
2. 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

1. Is there a way to accomplish the above?
2. Is there a simpler way to design this?