• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Sheets to Airtable - numbers not working!

shane6836

Member
Hi team,

Trying to pass an account value to AirTable from Google Sheets with no luck.
The example I have - account value is $49,691.25 and no matter what I do (formatting number or currency in Pabbly, or formatting from Google Sheet side) it either updates to $49.00 or $0

1717845685961.png
 

Supreme

Well-known member
Staff member
Hey @shane6836

Please ensure that the dollar sign is not included in the amount field. You can eliminate the dollar sign from the number using the Text Formatter action step. The dollar sign will automatically be added by Airtable.

1717846103559.png
 

shane6836

Member
Hey :)

So that didn't solve the issue, however i worked out that if the ',' is removed (eg 49,691.25 to 49691.25 it solved the issue) - is there any reason we can't pass numbers with ',' to airtable?
 

ArshilAhmad

Moderator
Staff member
Please allow me some time to discuss this with my team. We will get back to you with an update soon.
 

ArshilAhmad

Moderator
Staff member
I had a discussion with the technical team, and they have informed me that in the Currency type field, you need to pass the value without any commas. The API does not accept commas in the amount.
 
Top