For a user selection in a survey, I have used a table "TableParticipants" to collect the names (which is imho the only way to get/store multiple values resp. something like an array - please correct if I'm wrong).
But now, when I would like to notify these users about the start of a survey, I can not select the table in the "Send an email" workflow activity; seems that the "Insert" function there only lists "Single Line Entry" fields...
Any recommendations how I can make that happen?
Just stumbled upon a sentence in a HCL presentation which might explain (or at least hint to) why a table might not be available in a workflow activity: Table fields cannot be used as inputs to services.
(If I'm not mistaken, the "Send Email" activity is a service as well.)
I found this in the "Training_Tables.pdf" on page 3, available via this link: HCL Domino Volt - Using Tables
But the question remains - I can concatenate the recipients from the table in a "Single Line Entry" field, but it's length is limited to 255 characters, so this is quite error-prone (10 users/mail addresses will already exceed the char limit, preventing submission of the form).
A "Multi-Line Entry" field does not have this limitation, but it is - also - NOT selectable in the workflow activity.
I managed to work around this limitation:
- first, I concatenate the entered/selected people into a "Multi-Line Entry" field
- then, I split the values via JavaScript into 10 Single Line Entry fields I put on the form in a hidden section
- finally, I select all these 10 fields in the recipients field on the mailing activity
