I have an existing survey with approximately 10k records, some with attachments, so without. The challenge I face is to add a field, simple text field no more than 10 characters and republish for our users to continue using. My understanding is that I cannot make a schema change without losing all previously collected data, thus requiring a rebuild of the survey, download of current data, publish new survey and load data.
The problem with this workflow is that I have scripts that reference CreationDate which is used as an accountability measure for when the survey is completed. When I download an republish the current data the original CreationDate is overwritten for the SysDate, which is a major problem for historic reporting.
I would appreciate any help!!!