...
- Open the record for the Orders entity in the Entities service.
Set the definition for the ShipToEmail virtual field:
ShipToEmail –Set virtual Field Type = Calculated
Set below Calculation:
Case p2.LastName
when '[Not Specified]' then c1.MainEmail
else
p2.Email1
EndSet the definition for the ShipToEmail virtual field:
BillToEmail –Set virtual Field Type = Calculated
Set below Calculation:
Case p3.LastName
when '[Not Specified]' then c.MainEmail
else
p3.Email1
EndSet the definition for the BillToName virtual field:
Update below Calculation expression:
(RTRIM(p2.FirstName) + ' ' + LTRIM(p2.LastName))
Save and close the Orders entity record.
...