Transaction Workflow: Set eMail Field Value This s...
# suiteflow
r
Transaction Workflow: Set eMail Field Value This should be pretty simply but could use a suggestion or a few words of wisdom. I'm trying to set the eMail field (under the Communication -> Messages subtab) on a Transaction record (in this case, Sales Order) with the value from a custom field sourced from the customer record (and that also appears on the Transaction). This is a really simple single state workflow. The only way I've been able to get this value to populate the eMail field is by using Before Record Submit trigger. I was hoping the field would populate using Before Record Load or even an After Field Edit so the user sees the value before the record saved but no such luck. Is there something special about this particular field that is preventing that from happening, or am I using the wrong trigger? Many thanks.
b
you want to set the email address after netsuite sources the value from the customer record
r
Thanks for the reply. I thought I gave that a go but will give it another test and report back.
Hmm ... I've tried every which way imaginable but still no cigar. If I create a new custom transaction body field I have no trouble updating the contents with the field value from the customer record using After Field Sourcing. But I cannot seem to get the {email} or {emailaddr} field (per the XML) to update unless I use the Before Record Submit. Any other suggestions?
b
basics are to set any field, then upgrade to setting email with a hardcoded value, and then graduate to setting it to a value from a joined field
👍 1
otherwise you need to share a lot more of how you are trying to accomplish this