We have an Airtable sync set up currently but noticing when an ID field is being synced to Hubspot the leading zeroes are left off (two zeroes in the front of each ID). Anyway, to stop this from happening and have the full ID synced? The HubSpot field is an unformatted number field.
Hey @cclark2,
Thanks for bringing this to the Community!
Great question! It seems this would be the expected behavior when utilizing the number field. Have you attempted to use any other field types?
Tagging in a few folks from the community to see if they have any specific suggestions for you!
Hey @karstenkoehler, @Josh, @UlianaV – do you have any experience with something like this? It looks like they’re attempting to have their IDs read as something like 00xxxx, but its automatically removing the leading 0’s.
Thanks in advance!
-Sam, Community Manager
This is expected behavior for a Number property. Leading zeros aren’t stored because the value is treated as a number, so 001234 and 1234 are considered the same value.
If the leading zeros are significant and are part of the ID, I’d recommend storing it in a Single-line text property instead. Identifiers are generally better stored as text since you’re not performing calculations on them, and the original formatting will be preserved during the sync.