Skip to main content

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  

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

Terms & ConditionsAccessibility statement