Hey everyone,
So I formatted a line that comes in when someones registers for camp on shopify. I seperate with a “,” and only want the name of the camp. But using the split, it gives me two outputs. But, I only want the first. Even though I configure that step by asking only the first segment. When using the action ‘send to google sheet’ it still gives me both values (output 1 & 2) separated with a “,”. I don’t understand why this is happening.
Please provide a screenshot of how the Zap step is configured.
What is the desired output? (e.g. only “Skatekamp”)
I think then it is way easier to help 
Thank you
Hi
Looks like you’ve got a great conversation going with our Support team and they’re helping you out with this! If you have any further questions you can reply to that thread :)
I suspect they’re on the right track with it being related to your mapped field being line items from Shopify. While it may look like it’s just comma-separated and that you could split on that, they’re in a slightly different format. Support’s suggestion is what I’d recommend as well:
If that is the step - you could try changing it to a Formatter > Utilities > Line Item to Text action - which would split the line items into Text fields (and you could use the First output item).
The previous lines I already corrected manually, but the last line is how is looks. You see in the row ‘KAMP’ it mentions the output twice.
Thanks for helping
Hey
I think you use the field of the shopify zap in your “Kamp” field again. What you should refer to is the elements from the formatter that you just split:
Can you try this?
I’ve used utilities to choose one of both outputs!
It worked. Thanks all for contributing, you guys are the best.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.