Enlace: rework survey creation and editing

[cecilia-donnelly]

Enlace has new surveys and may want to edit existing surveys. We need to investigate whether it makes sense to add a "survey generator," to use SurveyMonkey or similar, or for us to manually make changes in the codebase. More information will come soon from @kevinrak9 and we can make a decision based on that.

[cecilia-donnelly]

If we were to add a new survey generator (TBD: @cecilia-donnelly, come back and explain this better), these would be the steps:

• add the new questions to questions database table (currently called Baseline_Assessment_Questions)
  • we don't currently have a way to account for the same question in different languages, so we'd need to add that.
• add responses and their values to a table of responses (called Assessment_Responses) (note that there's probably a better way to do this than the current one, especially if almost all responses will be of the Strongly Agree -> Strongly Disagree range)
• write a loop through these questions and responses on the html page and generate a table
• add or reformat a db table to store responses to the new survey.
  • if we designed this well, it would be a one-time effort and would work for all future surveys. I'm imagining columns like ID, question ID, survey ID (really we wouldn't need this, if each question was already linked to a survey in the Baseline_Assessment_Questions table), response value, and participant ID. Then we could construct each participant's survey responses without needing the long rows we currently have.
• add AJAX to the page to save the responses to the table
  • I think this would be a lot easier than it is in the old code, too. When I'm looping through the questions I can append the responses to an object (or something similar) and just send that object in my POST request.