Existing Node/Express/MySQL project needs further development

Job ID: 31738616

Budget: $30 – $250 USD

Existing web app MVP needs further development.

Looking for someone skilled with Node/Express/MySQL/EJS/(Bootstrap).

Currently, the input form works as it should. We also have a form that views all existing db records and another that shows a detail view (built on the same template as the input form).

The input form is separated into 4 sections. The use case is that each section is completed by the user at different times in the business process - literally different days, as a rule. The logic for the input form is that each subsequent section is only visible in the browser once each required field in the preceding section is complete.

The form currently only shows section 1 when the page renders. Then, when the user completes every required field in section 1, section 2 renders allowing the user to continue (and so on for sections 3 and 4). The problem is that the current code is only client side manipulation when we need each section to actually post to the database - create that new record when section 1 is complete, allowing the user to return to that record in the 'view all' view and open the record, see (previously completed) section 1 and section 2 in order to continue with completing that next section.

The end user needs to be able to complete the form in sections and be able to return to a record that is 'in-progress' to continue through that 4 step business logic. Not sure if this needs to be 4 separate POST routes to make it work or if you have better suggestions.

In theory, we believe this should just be a read and update functionality once section 1 is complete and a new record is created. But we are concerned about challenges of posting incomplete/null values to the database from an effectively incomplete form (sections 2 through 4). Should this essentially be 4 forms (and thus 4 different routes), or can this be done otherwise?

Seeking estimates on both labor hours (or days) and cost.

I am happy to send screenshots and share some of the code upon request.
Related categories: JavaScript MySQL Node.js Express JS