Skip to main content
Solved

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

  • July 15, 2022
  • 4 replies
  • 53 views
D

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.

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

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

Best answer by Ben_Young1

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.

    4 replies

    Ben_Young1
    Forum|alt.badge.img+22
    • Ben_Young1
    • Brainy
    • 520 replies
    • Answer
    • July 15, 2022

    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
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9814 replies
    • July 15, 2022

    @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.

    D
    • Dave_Martin
    • Author
    • New Participant
    • 3 replies
    • July 15, 2022

    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.


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

    D
    • Dave_Martin
    • Author
    • New Participant
    • 3 replies
    • July 15, 2022

    @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.


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


    Terms & ConditionsAccessibility statement