May 27, 201510 yr Hello, Hopefully somebody may know this and i bet its really easy but scripting to me is still the dark arts but I'm trying to learn. I have a field that is a value list of names and i want this name to be changed to an email address so that it can be sent to that person. i.e. "Paul" = [email protected]. "bert" = [email protected] etc How do i do this in the calculation field. Many Thanks
May 27, 201510 yr calculationfield = namefield & "@address.com" calculationfield must have text result
May 27, 201510 yr Author Brilliant !! How clever is that :-) easy when you think of it i suppose Thanks for that Kris
May 27, 201510 yr How do i do this in the calculation field. Why do you need a calculation field for this? If this is for sending mail, you can calculate the address directly in the Send Mali script step.
May 27, 201510 yr Far from brilliant. Just a simple string concatenation. My advice it to get intimate with all of the string manipulation functions before you try to build anything really complex. Also look into the Send Mail script step as comments question is on point.
Create an account or sign in to comment