Thanks for the clarifying images.
You wrote “How can I access the row of “monthly_drivers” that triggered the workflow inside the start: expression? [_THISROW].[month] does not work since it looks inside of “tours” instead of “monthly_drivers””.
Actually, when [_THISROW] appears inside a Start expression like the one below, it refers to the current row of “monthly_drivers”. Admittedly, the term [_THISROW] is a
bit confusing, but it is referring to the current row of the table containing the Start expression. That is “monthly_drivers” in your example.
To verify this, I did the following: 1. I created two tables that contain the fields listed in your image.
I created a Report for table “monthly_drivers” that specifies “For each row in table”.
I created a Body template that contain the test template shown below.
I saved and verifying the template.
I ran the Report
Report For monthly_drivers
driver: <<[driver]>> year: <<[year]>> month: <<[month]>> is_ready: <<[is_ready]>>
Driver1: <<[driver_1]>> Driver2: <<[driver_2]>> Driver3: <<[driver_3]>> Driver4: <<[driver_4]>>
The Start: SELECT expression condition I specified is not realistic, but it confirms that [_THISROW] is referring to the current row of “monthly_drivers” and that it retrieves the value of the “month” field in that row.
Forgive me if I have misunderstood what you are reporting. If so, please do the following:
- Create an simple sample app that illustrates the problem. 2. Provide me with: 2a. Your account id from the Account pane 2b. The app name 2c. The steps to reproduce the problem.