Create a special value which is a UUID (or other unique ID feature). This will enable less brittle associations between records. I also think this will work super well with the new data editor. Copied from Spectrum

Unique ID Special Value

Topic		Replies	Views
Need Plain English Explanation of Unique identifier Ask for Help	3	894	November 15, 2019
Row IDs General	25	3470	April 6, 2020
Special Value Unique Identifier not working Report a Bug	5	678	November 18, 2019
Filter rows by signed in user's unique id Feature Requests	21	3301	January 19, 2021
Thoughts About Row ID / Unique ID / Actions Ask for Help	25	1764	July 10, 2025