- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 06:08 AM
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
![Deep_Vyas Deep_Vyas](https://community.airtable.com/legacyfs/online/avatars/3X/f/7/f76e325f74263b1902b6f82269030a3a0e70dd7d.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 06:02 AM
Check the source API is pulling up the height data...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 06:07 AM
It appears to be pulling the correct field, but 63.6 is not what is in the table.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 12:44 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 12:48 PM
Yes. The height is inputted as a whole number in the source.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 12:51 PM
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?
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)