• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

  • Due to Diwali and Bhai Dooj celebrations, our team will have limited availability. While we’ll continue to monitor threads, responses may be slightly delayed. Normal operations will resume on Friday, 24th October 2025.

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

Pabblymember11

Guest
Hey @Roberto

Could you please share the name of the workflow along with the registered email address with Pabbly?
 
P

Pabblymember11

Guest
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