+3We have a Number field that we use for height that is always entered as a whole number in inches. Example: 65 or 66. Yet, when we pull this data via API, it will change it to a decimal. Example: 65 turns into 64.8 or 65.2. We do not understand why this would happen.
Any help is appreciated, thank you
+3Check the source API is pulling up the height data...
It appears to be pulling the correct field, but 63.6 is not what is in the table.
+20Is the height actually input as whole numbers in the source, or is it just displayed as whole numbers in the source?
Ie. You can have an Excel/Google sheet holding the value 63.6, but it will appear as 64 based on the display settings on the cell. When exported somewhere else, the true value (63.6) is what gets passed along, not the displayed value.
+3Is the height actually input as whole numbers in the source, or is it just displayed as whole numbers in the source?
Ie. You can have an Excel/Google sheet holding the value 63.6, but it will appear as 64 based on the display settings on the cell. When exported somewhere else, the true value (63.6) is what gets passed along, not the displayed value.
Yes. The height is inputted as a whole number in the source.
+20The source in this case is an Airtable table/base, correct?
If so, can you duplicate the base and remove any sensitive info, then share the cleaned up version here so that we can look at it?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
