I’ve connected my Checkmarket survey to Smartsheets via Zapier however some of the questions are multi-line questions - such as “your information” there is are separate lines within the same question for first name, last name, email, etc however when I am in the Action part of adding the response to Smartsheet its mapping these as a string with comma separator (John, Smith, john.smith@test.com). What I need is for those to be separate fields on the smartsheet which is already setup with the separate columns. So how do I parse the string - mind you I need a no code/low code response please.
How do I parse multi-line Checkmarket survey answers into separate Smartsheet fields?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+6
- Zapier Staff
- 4058 replies
-
21 August 2023
Hi
Welcome to the Community! 🎉
You can use Text in Formatter by Zapier - Split Text to parse the string and map them to separate fields in Smartsheet. Here’s an example:
You can learn more about modifying text formats in Zaps here: https://help.zapier.com/hc/en-us/articles/8496304469261-Modify-text-formats-in-Zaps#1-add-a-formatter-step-0-0
Hopefully, this helps! 😊
This doesn’t seem to work with commas as the delimiter between the text.
Userlevel 7
+6
- Zapier Staff
- 4058 replies
-
22 August 2023
Hi
Have you tried setting the “Segment Index” field to All (as Separate Fields)? This is what it’ll look like based on your example (John, Smith, john.smith@test.com):
(view larger)
(view larger)
You can then map the output individually:
Please give that a try, and let me know how it goes! 😊
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.