• 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

Airtable number field doesn't accept numbers

school

Member
I'm trying to update a record in Airtable. The field is in number type, but doesn't accept number.

The error message is:

error > type INVALID_VALUE_FOR_COLUMN
error > message Field "search past 30d" cannot accept the provided value

How to correct this?
 
P

PabblyMember3

Guest
I'm trying to update a record in Airtable. The field is in number type, but doesn't accept number.

The error message is:

error > type INVALID_VALUE_FOR_COLUMN
error > message Field "search past 30d" cannot accept the provided value

How to correct this?
Can you please provide the screenshot of the module and response here?
 

Roberto

Member
I'm having a similar issue trying to copy data from Google Sheets to an Airtable number field. The number appears fine in Google Sheets. It is mapped in Airtable: Create Record, but the number is changed. If for example the number in Google Sheets is 72,309.25, it gets copied to my Airtable Base as 72. When I change the Airtable field from a "Number Field" to a "Single Line Text" field, the complete number appears. Leaving it as text is useless to me because I need to include this number in a formula to do other things in other fields.
 

Supreme

Well-known member
Staff member
Hey @Roberto

If you are using the number field in your Airtable action step then you need to pass the amount in the following manner.

E.g. - 79500.12

1670911624981.png
 
Top