What is the correct number format for Airtable?

How To
,
1

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!

2

Up
Anyone can help here?

3

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.

4

The problem is that I need decimals…

5

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??