All,
I’m trying to send an e-mail from a form and I’m inserting several fields, but my issue is that if I insert a CheckBox field and the user selects more that one value, the @MailSend formula repeats all the other fields in the e-mail. For example, in the formula below, the field ‘roles’ is a CheckBox field and if the user selects two items I get:
"NAME: " + New_Full + @NewLine +
"Roles " + roles + @NewLine +
"E-mail Address: "+ email_add +
John Smith
HR
John Smith
IT
Can you help?
Subject: CheckBox field in a @MailSend
Is that really all the code? If there’s more, it might help if we could see it all.
But I’m thinking you might just need a few well-placed @implode .
Subject: RE: CheckBox field in a @MailSend
This is the code, the CheckBox field is ‘core_roles’. Thanks and let me read up on @implode.
@Do(@MailSend(“Pedro L Carrillo”;Requestor;“”;"PeopleSoft Security Request for " + @Name([CN]; New_Full);"PeopleSoft Security Request submitted by " + @Name([CN]; Requestor) + ". "+ @NewLine+@NewLine+
"Type of user: " + country_ty + @NewLine +
"Type of Request: " + Action_Needed + @NewLine + @NewLine +
"NAME: " + New_Full + @NewLine +
"GUID: " + Guid + @NewLine +
"EmplID: " + emplid + @NewLine +
"Core Roles " + core_roles + @NewLine +
"E-mail Address: "+ email_add + @NewLine + @NewLine +
“Please follow this link to view the request to setup —>”;“”;[IncludeDoclink]);
@Command([FileSave]);
@Command([CloseWindow]);
Subject: RE: CheckBox field in a @MailSend
This did it:
“Core Roles " + @Implode(core_roles;”,") + @NewLine +
Thanks!!!