I created a ZAP with which I import ORDERS from Shopify into Google Spread, the problem now is that the EUR information ends with "." instead of ",2 flow in, how can I optimize that in the ZAP? I've already tried FORMATTER, but I can't get it right.
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
+8
- Certified Zapier Expert
- 802 replies
-
30 January 2023
Hi
You can use the formatter to replace the period with a comma. What was the issue doing that?
in witch Position ...it DON Work ….
Userlevel 7
+8
- Certified Zapier Expert
- 802 replies
-
30 January 2023
Im a bit confused. It already shows the number with a decimal place? Shouldn't it show it as 536,80 ?
YES. 156.00 > 156,00
Userlevel 7
+8
- Certified Zapier Expert
- 802 replies
-
30 January 2023
You should use Text instead of Number and make it replace the “.” with “,” (if I understand you correctly)
Exactly
Hi, my name is Elizabeth Snowdon. I’m a user researcher at Zapier. We want to talk to Zapier customers who are also evaluating or using Make/Integromat. This research will enable us to discover opportunities to improve Zapier’s core workflow.
Fill out the short survey below, and if you’re qualified, we will contact you to schedule a 30-minute interview. Those scheduled for an interview will be provided a gift card for your time.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.