Hi guys, I’m trying to get message from automated notifications working which it is, but I want more details from modified row.
Notify(List([JB]),
“Start time of: " + thisRow.[Step 1 Result].ToText() + " was modified” )
I’m trying to get a modified time from the row but whatever I try I see either last item in a table, all of them or none.
Purpose of this notification is to let me know when someone changes on of the “Project” Start time and let me know what was modified and what is new time.
Does anybody have a solution for me please?
Try this:
Notify(List([JB]),
“Start time of: " + thisRow.[Step 1 Result].ToText() + " was modified to ” + thisRow.[Step 1 Result].[START TIME AND DATE])
But actually I would suggest 2 more changes:
- Use the proper name of the field instead of converting the row reference to text. I just assumed it to be
Name
- Use
format()
. It’s cleaner, easier to maintain and more versatile.
Notify(
List([JB]),
format(
"Start time of: {1} was modified to {2}”,
thisRow.[Step 1 Result].Name,
thisRow.[Step 1 Result].[START TIME AND DATE])
)
)
Hope this helps,
Pablo
1 Like