Skip to main content
← Data, API & Backend
Data, API & Backend August 12, 2022 · 3 replies

The number store in Airtable is 37.17... why the number I return via API is…

Archived from the Bravo community forum (2021–2026). Some answers may refer to older versions of Bravo.

The number store in Airtable is 37.17... why the number I return via API is 37.169999999999 ? This case is not just happening once.

How can I solve this issue?

Data in Airtable

image.png

Data return via API

image.png

3 replies

Marta Serrano Bravo team August 12, 2022

Hello  ! 
This data comes directly from Airtable. Bravo does not have control on that. I suggest to contact Airtable support team to learn more about it.
Thanks

Masi August 12, 2022

What you are seeing in Airtable is a rounded number, the actual number behind it has more decimals (37.1699999...).

You need to round your number in Airtable first before retrieving it with the API.

You can use "ROUND(value, precision)" for this in Airtable.

See August 12, 2022

By using a formula?

Isn't Airtable already set the formatting value when we're creating the column?

image.png

Wrote something in this thread and want it removed? Request removal

Still stuck?

Ask the community on Discord

This archive is read-only. New questions, office hours and product updates now happen in the Bravo Discord.

Join the Discord