Hi there
I am having an issue with the 'send email' action on a workflow.
The field the workflow is sourcing the email address from is a field called 'First Approver'. This is a field on a custom record which has the employee linked on it:
Screencap of the custom record the 'Approval Limits' field is linking to and the employee field the 'first approver' field on the vendor bill is sourcing from:
There is another workflow that is triggered by this workflow on a before record submit event
The second workflow is the one that is supposed to send the email
There is a field on the vendor bill called 'first approver email' which has the email address for the approver:
From my perspective, the field values for the approver (the employee) and the approver's email address are set before the record is submitted to the database
With that being the case, why would the email address be considered blank?
I am assuming that it might be linked to the 'approval limits' being populated after record submit (while the transition to the next state happens on before record submit)
Though I can't get the 'approval limits' record to populate in before record submit or any other trigger
Currently, the approval limits field is being set by a workflow action script which uses the 'first approver key' field to filter the approval limits custom records and find the one that matches
This field is set after the department is set (post sourcing trigger per the screenshot above) though it's value doesn't populate until the record is saved and submitted
Why would that be the case?
Thanks