We need to manage a repository of questionnaires, a bit like we do with compliance packages:
This would imply people can:
- import questionnaires TEMPLATES
- edit, add, etc them
When they create a OA they will choose from the available templates, this will create a few changes as now when a user imports a template is “attached” to an OA…this makes the DB insanely large as we are duplicating data (imagine same questionnaire to 100 different OAs)
This will require a migration:
- take every OA
- take their questionnaire
- create a new “Questionnaire” on the tab
perhaps we can built the questionnaires tab , when a user creates a new OA they can choose:
- if to import a new one (using old method)
- use the questionnaire tab items (like compliance packages)
if they choose #2 then we can optimize the db a lot as we re-use the template. the template of course CAN NOT be modied if it has been already used by a OA, there must be a new questionnaire (clone functionality) or delete the associated OAs completely (even from trash).