For more general use outside of eRum, it would help to make app.R more general with fewer hard-coded specifics. Additionally, documentation of the specifics will help. Here are the things that come to mind if you want to make it more generalizable:
- What are the Google Form links? Are these links to the page for the responses? Does "link sharing" need to be turned on?
- It is currently set for two forms, could this be generalized to n >= 1? Or, state that some copy-pasting will just be required for other numbers of forms. Also for
submissionType sidebar input, would be better to use the submission types as a variable.
- Any formatting requirements for the
.xlsx files?
- It looks like columns
Reviewer1, Reviewer2, Reviewer3 are required. How about using a search for ^Reviewer.+ to allow any number of reviewers?
- Perhaps instead of
preselected_cols, use an optional ignore_cols variable so this doesn't necessarily have to change for each different form
- Could the output be determined from the columns of the
xlsx file, rather than hard-coded?
For more general use outside of eRum, it would help to make app.R more general with fewer hard-coded specifics. Additionally, documentation of the specifics will help. Here are the things that come to mind if you want to make it more generalizable:
submissionTypesidebar input, would be better to use the submission types as a variable..xlsxfiles?Reviewer1,Reviewer2,Reviewer3are required. How about using a search for^Reviewer.+to allow any number of reviewers?preselected_cols, use an optionalignore_colsvariable so this doesn't necessarily have to change for each different formxlsxfile, rather than hard-coded?