Hi everyone,
I’m receiving data that is in line item format, and one is just a single value not in line item format, when I write these line-items to google sheets I want each row to contain the value from the single value, not just the first row. How do I do this? And no I do not know how many line items there will be, sometimes one, sometimes 50.
Thanks!
Best answer by AndrewJDavison_Luhhu
View original
+10
Hi
Luckily, this one is quite simple. If you're using the "Google Sheets -> Create Spreadsheet Row(s)" step, and you map line item fields alongside just a normal text field, the text field will appear on each row that is created, regardless of whether that it is 1, 3, or 50.
Example:
Column A input = [dog,cat,mouse]
Column B input = Hello
Result:
Column A | Column B
dog | Hello
cat | Hello
mouse | Hello
====
Edit: Just had to do this for a client, so here you go:
"Name" & "Type" are line item lists with 3 items in, where as "Order" is just a single text field.
When written to Google Sheets, you'll end up with this:
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
