Shopify Flow is an ecommerce automation platform that enables you to automate tasks and processes within your store and across your apps.
I am trying to use Shopify Flow to automate some of my order processes by creating a new row in Google Sheets everytime an order comes in.
Some columns I use formulas which contain " , ' ( ) and various other symbols. My question is how can I add a comma without making it a separator? I have tried "," which sadly does not work.
Solved! Go to the solution
This is an accepted solution.
We'll try to document this better. Part of the issue is that some characters affect things in Flow and some in Sheets. Anyway, I looked at past answers and think that actually backslash solves this. So try:
field 1, "My string\, mystring()", field3
Try putting quotes (") around them, for example:
field 1, "My string, mystring()", field3
Thank you Paul, that's what I tried but unfortunately the quotes did not do anything
This is an accepted solution.
We'll try to document this better. Part of the issue is that some characters affect things in Flow and some in Sheets. Anyway, I looked at past answers and think that actually backslash solves this. So try:
field 1, "My string\, mystring()", field3
Thank you Paul, that worked a treat! The only problem I got stumped on now is that the shipping addresses would sometimes contain commas, which I don't think I will have a solution to since they are variables, but this might be something you guys need to take note of!
You can find and replace using liquid. Something like
{{ variable | replace: ",","" }}
How would this be implemented? I'm receiving a syntax error in Shopify Flow when I try this:
{{"{{product.title}}"|replace: ",",""}}
You don't nest brackets in liquid
{{ product.title | replace: ",",""}}
We recently spoke with Zopi developers @Zopi about how dropshipping businesses can enha...
By JasonH Oct 23, 2024A big shout out to all of the merchants who participated in our AMA with 2H Media: Holi...
By Jacqui Oct 21, 2024We want to take a moment to celebrate the incredible ways you all engage with the Shopi...
By JasonH Oct 15, 2024