Skip to main content

How to view a numeric value as it is stored in AirTable (floating point)

  • July 23, 2024
  • 1 reply
  • 16 views
S
Forum|alt.badge.img+1

Hello,

I am importing AirTable data into a SQL server database via SSIS and some numeric values are being imported with a floating point error.  In order to get some help from my local AirTable admin, I need to be able to show them that the currency-formatted values in the Air table interface are not the exact value of the data that were entered and stored in the AT base worksheet.

Is there a way to view through the AirTable UI the stored value without the format?

Example:  $0.090 is the column value as displayed in the AirTable UI.
Here is that same value when imported from SSIS 8.9999999999999997E-2  

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, seems like you've already tried setting it to show as many decimal places as possible.  Maybe try converting it to a text field?

For the import, what if you created a formula field and used the "ROUND()" function, then imported that field instead? 
https://support.airtable.com/docs/formula-field-reference

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement