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:
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
Solved! Go to Solution.
The first argument to LINKTOROW() should be (an expression that produces) the key column value of the row you want to display. It might be as simple as:
LINKTOROW([_THISROW], โCompassโ, โThrivifyPro3-141441โ)
See also:
Ok I managed to get this working. The only thing I havenโt figured out is how to create a deep link that points directly back to the specific Commitment Row for that notification in the Commitments table.
Hereโs what I have:
LINKTOROW(โCommitmentโ, โCompassโ, โThrivifyPro3-141441โ)
When I click on each notification though it just takes me to the Compass view not to the specific commitment
The first argument to LINKTOROW() should be (an expression that produces) the key column value of the row you want to display. It might be as simple as:
LINKTOROW([_THISROW], โCompassโ, โThrivifyPro3-141441โ)
See also:
Makes sense in theory. Works on the test. But in live action it just takes me to the view instead of to the specific row.
I also tried swapping out _THISROW with Plan ID
Thanks Steve, I got this working.
I was using the wrong view. Once I switched to the right view, I got the results I expected.
Cheers.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |