AirTable currencies integration with Pabbly cannot accept strings

[JeffreyYu]

It's currently impossible to send a value to an airtable with a currency field, as Pabbly is passing in strings for all values. However, for the Currency field, it requires sending it without strings.

Could someone at Pabbly create a workaround for this? Thanks!

Getting Error with POST to currency field

I am working in Postman. The field in question is "Taxes Owed - PDF". I get the error shown below. If I change the field type to single-line text I don't get an error. I don't want to change the field type. How do I avoid the error? I have also tried other values: $3333, $3333.00, 3300.00...

community.airtable.com

 

[ArshilAhmad]

Hi @JeffreyYu,

In our testing, we successfully passed the value in the currency field. Please verify this on your end.

 

[JeffreyYu]

Oh, I was running it with a decimal: $0.24 and 0.24 did not work on my end. Does that work on Pabbly's end?

 

[ArshilAhmad]

Please allow us some time to look into this concern. We will get back to you with an update soon.

 

[JeffreyYu]

Sure, thank you!

 

[Pabblymember11]

Hey @JeffreyYu

We are checking on your concern, please allow us some time.

 

[Pabblymember11]

Hey @JeffreyYu

Thank you for your patience. Regarding your concern, our technical team has updated the integration to display the currency with zero decimal places.

Please give it a try and let us know.

 

[JeffreyYu]

Oops, sorry I just saw this message! I will try it soon. Thanks!

 

[JeffreyYu]

It now works! When I put just 0.24. Thank you!

 

[Pabblymember11]

Thanks for the update @JeffreyYu!!