In a request db with a text list field (not rich text), when we send back a ‘work complete’ email and include the original request, it truncates the string at the first comma in the request…
i.e if we are sent:
“Need to add 2 new users to existing ACL, remove one that is existing.”
the email goes back as “Need to add 2 new users to existing ACL”
Know the comma is “special” and tried to replace the , with a space, with something like this:
Subject: RE: Using Text list in email body truncates at commas
Use @Implode to convert the list to a scalar.
The list actually doesn’t contain a comma; that’s only used to display the value to you. When you use operators on a list and a scalar, the result is a list. (“A”:“B”) + " hello" = “A hello”:“B hello”. @MailSend, when you give it a list value as the message body, only looks at the first element of the list.
Subject: Using Text list in email body truncates at commas
Sounds to me like the comma is acting as an item delimiter in your field. So in your example, the field really contains two items…
Need to add 2 new users to existing ACL
remove one that is existing.
Now I can’t tell why it only keeps the first item. Are you manipulating the field with LS somewhere and addressing it as doc.MyField(0) or something like that? Maybe you are building the email using mailDoc.Body = tempDoc.MyField(0). That syntax would only grab the first item.
Turn commas as delimiters off in the field properties. Look into ‘Implode’ in Designer help.
