I am looking for insight on how best to manage custom form changes and existing data.
Currently, OpenSpecimen does warn me when I change or delete a question on a custom form, but it does not let me know if I have data stored under that question. This is fine, unless I am storing real data under these questions and not test data. I can delete data unknowingly. The system does not seem to have a concept of testing vs. real data collection.
How do other institutes manage data integrity and form changes? Are users allowed to manage forms, even after testing? Do users run queries on fields they may delete to see if there is any data in them first? I’m thinking of restricting form access in our production instance to only super users, and having regular users make changes in the testing instance and then I can import the changed form.
Any suggestions or insights would be helpful. Thanks!
Research Data Coordinator
BC Children’s Hospital