I have this tables:
Maintenances with this columns: [ID], [CAR], [KM]
Work_Shifts_Details with this columns: [ID], [INSPECTOR], [CAR], [WORK_SHIFT], [KM]
Then i have a bot for sending an email when Work_Shift_Details record is updated
So the Email Body Template goes like this:
The Car <<[CAR].[NAME]>> has surpassed the maintainance KM scheduled to <<Start: SELECT(Maintenances [ID], [CAR]=[_THISROW].[CAR])>> <<[KM]>><<End>>, its actual KM is <<[KM]>>
The CAR ID is <<[_THISROW].[CAR]>>
But the SELECT() part it's not showing nothing, any thoughts on this?
Solved! Go to Solution.
@Ccuadros wrote:
<<Start: SELECT(Maintenances [ID], [CAR]=[_THISROW].[CAR])>>
Try with [CAR]=[_THISROW-1].[CAR]
@Ccuadros wrote:
<<Start: SELECT(Maintenances [ID], [CAR]=[_THISROW].[CAR])>>
Try with [CAR]=[_THISROW-1].[CAR]
User | Count |
---|---|
41 | |
27 | |
24 | |
17 | |
12 |