# What is the correct number format for Airtable?

**URL:** <https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856>\
**Category:** Questions\
**Tags:** error, airtable\
**Created:** [June 15, 2024, 5:07pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856 "2024-06-15T17:07:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ONG\_Zoe](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ong_zoe/32/38309_2.png) [@ONG\_Zoe](https://community.make.com/u/ONG_Zoe)\
**Post date:** [June 15, 2024, 5:07pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856/1 "2024-06-15T17:07:51Z")

</div>

Hello everyone,

I’m encountering an issue with integrating Make (Integromat) and Airtable, and I’m hoping someone can help me resolve it. I’m trying to update a number field in Airtable with values parsed from a JSON file. However, I keep getting the error: `Field "Valor Bruto" cannot accept the provided value`.

Here’s what I’ve tried so far:

1. **Basic Parsing and Formatting:**  
`{{parseNumber(6.valor_bruto)}}`

2. **Removing Commas:**  
`{{formatNumber(parseNumber(6.valor_bruto; "."); 0; "."; ",")}}`

3. **Simple Multiplication to Ensure Number Type:**  
`{{6.valor_bruto * 1}}`

4. **Ensured Airtable Field Type:**

- Double-checked that the “Valor Bruto” field in Airtable is set to “Number”. Also tried currency. **When I put text it works**!

Despite these efforts, I’m still facing the same error. The JSON data I’m working with contains numeric values as strings, and I need to convert them to numbers for Airtable.

Any suggestions on what might be going wrong or how I can fix this? Has anyone encountered a similar issue and found a solution?

Thank you in advance for your help!

---

<div class="post-metadata">

**Author:** ![ONG\_Zoe](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ong_zoe/32/38309_2.png) [@ONG\_Zoe](https://community.make.com/u/ONG_Zoe)\
**Post date:** [June 26, 2024, 4:35pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856/2 "2024-06-26T16:35:34Z")

</div>

Up  
Anyone can help here?

---

<div class="post-metadata">

**Author:** ![Mr.Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mr.make/32/93066_2.png) [@Mr.Make](https://community.make.com/u/Mr.Make)\
**Post date:** [June 26, 2024, 6:27pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856/3 "2024-06-26T18:27:29Z")

</div>

I’v had this issue before and it was due to the decimal places in the number in airtable vs the one you are sending.

Best bet set the decimal places to 0 in airtable and try that.

---

<div class="post-metadata">

**Author:** ![ONG\_Zoe](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ong_zoe/32/38309_2.png) [@ONG\_Zoe](https://community.make.com/u/ONG_Zoe)\
**Post date:** [June 26, 2024, 6:45pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856/4 "2024-06-26T18:45:28Z")

</div>

The problem is that I need decimals…

---

<div class="post-metadata">

**Author:** ![Mr.Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mr.make/32/93066_2.png) [@Mr.Make](https://community.make.com/u/Mr.Make)\
**Post date:** [June 26, 2024, 7:03pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856/5 "2024-06-26T19:03:04Z")

</div>

So make sure you configure the exact decimal count in airtable and in Make and send over the same number of decimals. Have you done this??

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [September 24, 2024, 7:06pm UTC](https://community.make.com/t/what-is-the-correct-number-format-for-airtable/41856/6 "2024-09-24T19:06:18Z")

</div>