AnsweredAssumed Answered

Is there a way to make a schema change such as adding field and not have to create a new Survey and reload all previously collected data?

Question asked by on Apr 25, 2018
Latest reply on Apr 3, 2019 by juan.peralta

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!!!