I am in the process of developing a survey to allow sea turtle nesting surveyors to catalog sea turtle nesting disorientations around the state of Florida. The goal is to allow the surveyors to catalog a disorientation while on the beach instead of filling out the usual field data sheet and submitting them for data entry. This is a big undertaking with the potential of 1,000+ surveyors using this tool. Our team is doing its best to test the survey and account for all possibilities, but it is inevitable that we may need to modify the survey based upon user feedback. I know changing the survey without changing the schema is not a major issue (except for getting all the surveyors to update the survey), but what if I have to make a schema change? Is there any way to republish the survey without overwriting the existing data or publishing a separate survey with the new schema? This goal is to have all the responses in one database, not two. It will already be a herculean task to get all the surveyors, permit holders to follow directions; we don't want to make things a lot worse by adding more complexity to the processes.
Any help you can provide is greatly appreciated.
Florida Fish and Wildlife Conservation Commission