start the components for making questions that are very similar to the ones we see now. Have the questions be in a config file for now read in and display a similar UI with yes no responses. Also in the other languages, line height will be key to displaying all languages.

add execl spreadsheet to repo for app read questionnaire from

try to move these 1, 2, 3, questions to the worksheet already and refactor the Question 3 to be just a datepicker and see the other two questions to determine better naming.

Nested components with LogicBranches component Workshop questions lead to lots of nested components so hopefully will reduce complexity of nested components and project structure hierarchy.

Vietnamese, Spanish, and English are the first needed to support. When select a language option video should also change to correct one.

Make dropdown bar the width of the screen

Before someone can take the workshop they must meet the requirements specified in the survey. Pre questions before the questionaire.

Possible different types of emails.

• when user completes the questionnaire recieves an email if they provided it
• admin sending out email to agencies

View list of peoples responses once logged in

Check URL.
Issue is for example bypassing the zipcode, or for birthday it will jump over and will land to phone number, etc...
Please check.

Go through the apps question form fill out all required info and find a way to make sure the user watches the video first and enters in required info to take the question form. Once done with the form need to find out how do we handle the question form responses, does hubspot give us the results or do we need to go into hubspot and download the data?

language options in both the frontend and backend rely on their specific ordering of the columns in the website content spreadsheet and with the sheet ordering in the questionnaire red flags. need to refactor the uploading scripts to not rely on the ordering of the language options and the sheet ordering.

Instead of collection of options make it into an object by language code key lookup.

in routes/admin post to / that creates a new admin user the case a failed create of the Admin object is not handled correctly. Currently, it is doing a HTTP response.status(500).json to inform the caller of the problem but has already responded with a success by the time this code is ever executed. Currently, we are responding with success before the create promise is resolved. Express will complain if this code is executed.

When user is finished with questionaire and click submit, the response is sent to the backend and to the mongodb for admin page to display at.

• When user clicks submit, go through each resopnse and if any are answered yes add 'red' if all are no then 'green'

May be after Mara file uploading, look into front and end pieces.

Do we send out 1 link and based on the date/region person clicks from takes them to the questionair?

Need to go through the application, watch the video fill out the question form and see what needs to be changed for the most optimal user experience.

https://eimmigrate.opensourcesanjose.org/

Welcome to Virtual Citizeship Day 2022

This is visible on the first page. I'm not sure if it's meant to be that way but if not, could someone fix the typo?

A new admin route that will recieve a file blob, excel document, from the frontend client side computer. It will then go through the scripts for backend/uploadQuestionnaireFromExcel.js & uploadTranslatedContentFromExcel.js. One route for the questionnaire document, another for the website translations or could be in one route up to developer best practices.

allow some orgs to upload their own questionnaire, only see responses from those while super admins can view all questionnaires and all responses

Some of the admin endpoints and those used by dashboard should be accessible only by admins who are logged in. Code in backend/middleware/auth.js makes use of jwt token returned upon successful authentication. We should use it consistently for all endpoints that need protection.

Currently, questionnaire answers are posted by users who are not authenticated. We should come up with a mechanism to validate these are legitimate requests from our UI.

Button for uploading a new questionnaire
Display list of questionnaires uploaded
Interface for removing a questionnaire

When user selects a date, save it to local storage. then when in the workshop portion <Questionnaire component checks the local storage for date check if date is wrong then send them back to screening. Also if at submission has the date check or not for Admin to visibly check.

Tests are not passing locally.

https://www.ciit.codeforsanjose.com will take us to overall page and general info then a more full link will take to questionnaire.

Nodemon missing from dev dependencies in the package.json file.

add Prettierjs or another tool for keeping code formatting consistent.

when admin user logs in brought to list of user submitted responses

For example, in the user route, if an error occurs, the request hangs. Instead, should status(500) and return an error message

Allow CET admin user to log into application and see a list of all who have filled out the question form.