I’ve created a text formatter step to split into multiple fields so that I can populate a google sheet. When I test it it looks fine, but when I try to select individual fields in the next step they are not there. I only see 1 field again. Why don’t I see the individual fields that I created in the prior step? What am I doing wrong?
Best answer by Troy Tessalone
View original
+14
Hi
The output should look like this. (instead of returning an array with line items like shown in your screenshot)
Try testing the Formatter step again.
I’ve tried retesting at least 10 times and the output is not showing the separate fields in the next step.
+14
Try using a different Formatter option: Formatter > Utilities > Text to Line Items
Text to line item, gets the same result (plus it only lets me split by comma and I have commas in my data.
+14
Can you show an example of the original data you’re using?
When I test the original data I see this:
I want to capture what is in simpleValue (there are several of them in the data) and put each one in a cell in google sheets
However when I try to select it I only have this option. I went through all of the available fields and this is the only one that contains any and all of the data I want.
+14
Try this…
Action: Formatter > Utilities > Line Items to Text
That will return something like this:
Then you can use a Formatter > Text > Split OR a Formatter > Utilities > Text to Line Items step.
OMG, that worked.
This has been driving me CRAZY
THANK YOU !!!!!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
