I have a workflow that collects various data from custom fields and sends it out in an email.
I have one field called Buyer, which is a user lookup field. When I use the field within the email, it returns DOMAIN\username - how can I strip the "ULTRA\" from this and add our email suffix "@company.com"?
The end result would look like: firstname.lastname@example.org - essentally, I want to include it in a mailto link.
Assuming that this is possible, I'm guessing i would need to build a dynamic string to do this, but I am unsure of the operators I need to use.
Please advise :)