Skip to content

Created a user interface with two buttons ("Form A" and "Form B") leading to dynamic forms. Both forms include validation for name, country code, and phone number. Implemented an SQL database to store form data and used SheetDB to sync new data with an online Excel sheet via a "Refresh" button.

Notifications You must be signed in to change notification settings

ThatGuyChandan/MedWare

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 

Repository files navigation

MedWare

  1. Server side-

    1. add node_modules(use npm init)
    2. install all the required dependencies -
    1. connection to database (change the database, user and password accordingly to connect it to mySQL )
    1. I used sheetDB for storing sql data to online excel ->Go to SheetDB. ->Sign up and create a new API by linking your Google Sheet. ->You'll get a unique API endpoint for your Google Sheet.(copy that) ->past the copied api endpoint inside axios.post() ->manually initialize your Google Sheet with the required column headers.
    2. Now run the program using npm start (using nodemon ) or node index.js
  2. CLient side-

    1. add node_modules(use npm init)
    2. install all the required dependencies
    3. Now run the program using npm start

About

Created a user interface with two buttons ("Form A" and "Form B") leading to dynamic forms. Both forms include validation for name, country code, and phone number. Implemented an SQL database to store form data and used SheetDB to sync new data with an online Excel sheet via a "Refresh" button.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published