We 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
Check the source API is pulling up the height data...
Check 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.
Is 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.
Is 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.
The 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.