This is a bit of an open question to the community. If I (or anyone else) changes the underlying config of a column in depot by adding in or removing a field, how should Depot account for that change in "older" files? I have no intention right now to ever change the data key/type for a given column, but if I add in meta to a column (like right now I'm adding in the ability to set a display type for multi-selects), should Depot auto update any loaded in sheet to the latest version? Or should it keep things as is and not try to change a loaded in file, but have any new columns have the new schema? I could also version the .dpo files so they would stay consistent across a given file, and a user could select a version when creating a new file?
This is a bit of an open question to the community. If I (or anyone else) changes the underlying config of a column in depot by adding in or removing a field, how should Depot account for that change in "older" files? I have no intention right now to ever change the data key/type for a given column, but if I add in meta to a column (like right now I'm adding in the ability to set a display type for multi-selects), should Depot auto update any loaded in sheet to the latest version? Or should it keep things as is and not try to change a loaded in file, but have any new columns have the new schema? I could also version the .dpo files so they would stay consistent across a given file, and a user could select a version when creating a new file?
Would love to know what people think here!