+3Is it possible to aggregate a multi-pick list in GS to send to SFDC via a rule to populate a large text field?
Use case:
We want to send a survey response that is multi-pick list with an “other” option to type in freeform answer to SFDC. The field in SFDC is a large text field. The data is dropping off and not populating the field in SFDC. I want to aggregate the options the survey responder selected to one large text to send over
Best answer by andreammelde
Realized Survey User Answer aggregrates this already in Answer ID > Title and then Answer Text has the “other”. We cannot concatenate these to one field due to limitation on the large text field of Answer Text, so we created two fields in SFDC. One for the pre-aggregated multi select Answer ID > Title and one for the “other” Answer Text.
+1+3Realized Survey User Answer aggregrates this already in Answer ID > Title and then Answer Text has the “other”. We cannot concatenate these to one field due to limitation on the large text field of Answer Text, so we created two fields in SFDC. One for the pre-aggregated multi select Answer ID > Title and one for the “other” Answer Text.
+1+3Update - if the answer is a multi select, it is not already aggregated. There is a record per option selected. In order to get this to one field, you must pivot on the Answer > Title and then Concatenate.
It would be much more helpful if the Multi- Select was already aggregated so we did not have to do multiple steps to export a survey response
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
