Hi
Apologies for the simple question but I am hitting a wall!
I am trying to get a workflow action to update rows on one form if a column entry matches the row that has the button that triggers the workflow on another form.
Basically, table 1 is a list of employees. Table 2 is a list of training course instances, where each employee has a number of rows. If an employee is marked as left in table 1 by clicking a button, the workflow should take the employee number from table 1 and update any matching rows in table 2.
If I hard code an employee number into the conditional IF statement, it works fine, however if I try to put the field name into the workflow (which works with non numeric statements), I get a missing ";" error.
How should I be handling a numeric comparison where one side of the statement is a dynamic field name?
The screenshot attached should illustrate the issue I'm having! Thank you