Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Passing a currency field to Zapier doesn't arrive in the correct format

Solved
Jump to Solution
1671 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Dave_Martin
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Folks,
I have a Zapier Zap that is working beautifully to create invoices in Craftmypdf and then email them, but I have noticed a problem.
The Airtable view I get the data from has a rollup field that is a sum of charges in another table, a currency filed that contains any money due from previous months and a formula filed that adds those 2.
Regulars_ Invoice Summary - Airtable 2022-07-15 16-23-00

In Zapier I use the dictionary function to assign the value in the field Due to a key, also named due but the value is no longer 51.90 but 51.900000000000006
Monosnap 2022-07-15 16-28-34

Is Airtable passing this or is Zapier corrupting it? What can i do about it?

2 Solutions

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

Hey @Dave_Martin!

So everything you’re seeing is working as intended.
The true number value of your Due field is in fact 51.900000000000006.

Airtable is just formatting that number value into a currency format, which brings it down to the 51.90 that you’re seeing.

All things considered, the solution is pretty simple.


I dusted off Zapier and popped it open to play around with the problem you’ve been having.
Add a new action using the Formatter.
You’ll want to use the Format Currency transform action under the Number category.

Input your Due value, and then set the formatting you’d like to have Zapier output to Craftmypdf.

That should force the formatting to remain in a currency format of your choice.


Lemme know if I’m missing something or if you have any questions about what’s happening.

See Solution in Thread

ScottWorld
18 - Pluto
18 - Pluto

@Dave_Martin Your actual value is the one that you are seeing in Zapier. If you don’t want to see that value, then just use the ROUND() function in an Airtable formula field to round the value to however many decimal points that you want (presumably 2). Then send that formula field to Zapier instead.

See Solution in Thread

4 Replies 4
Ben_Young1
11 - Venus
11 - Venus

Hey @Dave_Martin!

So everything you’re seeing is working as intended.
The true number value of your Due field is in fact 51.900000000000006.

Airtable is just formatting that number value into a currency format, which brings it down to the 51.90 that you’re seeing.

All things considered, the solution is pretty simple.


I dusted off Zapier and popped it open to play around with the problem you’ve been having.
Add a new action using the Formatter.
You’ll want to use the Format Currency transform action under the Number category.

Input your Due value, and then set the formatting you’d like to have Zapier output to Craftmypdf.

That should force the formatting to remain in a currency format of your choice.


Lemme know if I’m missing something or if you have any questions about what’s happening.

ScottWorld
18 - Pluto
18 - Pluto

@Dave_Martin Your actual value is the one that you are seeing in Zapier. If you don’t want to see that value, then just use the ROUND() function in an Airtable formula field to round the value to however many decimal points that you want (presumably 2). Then send that formula field to Zapier instead.

Wonderful, thanks for your help. Can’t fathom how I arrived at 51.900000000000006 but nice easy fix

Thanks, Scott :thumbs_up: :thumbs_up: :thumbs_up: :thumbs_up: