I’m reopening this topic, I’ve seen there was an old one and this issue seems to keep being not solved after 5 years, which is kinda ridiculous.
Out of the blue, without any reasonable explanation, the record IDs of one of my main tables have changed.
We use the Record IDs as the primary key to run reporting outside of Airtable. It fully broke our scheduling system. From the 31st of March to today, all the IDs of my records have changed.
This happens in a synced table, which might be the reason, although not logic at all. No record has been deleted an re-created.
How come this happens? A unique ID must be immutable, what’s the point of having IDs that change in time?
Question
RECORD IDs CHANGE
+1
+35
Are you referring to the Record ID’s changing in the DESTINATION of the sync? If so, that is expected behavior. Airtable’s “official” Record ID will become a new Record ID in the destination table.
However, you can sync the original Record ID from the source into the destination table as its own field, so you can still see the original Record ID in a new field in your destination.
Hope this helps!
- ScottWorld, Expert Airtable Consultant
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.