Does anyone have an example of how to set up the data model and then workflow to trigger an email based on the creation of a sales order, using a field in the itmmaster as a filter (and this data point isn't in any of the SORDER tables).
I want the email to be sent to the SO creator immediately.
See my example below. Once you have the data model created and saved in the workflow - then the itmmaster table should be available in the formula wizard of the conditions.
I do list out all the SO lines that meet my condition in a single email. See pics below. You have to tell the workflow to group by SO (in Regrouping lines) and then in the text box type |LIG| (which tells the system to use the Line info). The Line field uses same 4GL syntax so you can construct a "complex" statement using line record information.
