Transfer multiple choice field to Excel -->Unexpected result
Hello, dear team:
I have met an issue today regarding transfer multiple choices field to word file and excel file.
1. I set a template word to get the multiple choice field
2. I set a template excel to get the multiple choice field
3. I selected all the choices in the field
4. Action "Word: Create a word document" is performed, the word file get the field value which is OK
5. Action "Excel: Populate template" is performed, the excel file get the field value which is not OK, unexpected symbols [ " " ] are added
Is it possible to get the same result in excel as word?
Thank you.
Best Answer
-
Hi, @BIN_127767.
It looks like this is formatted as an array. Can you please try using Field: Set value of a text field with
{{your-field}}
as the input? Doing so should convert to a text string for usage in your Excel template.Thomas
5