Designing a page for entering data into the database, and checking the quantity of occurrences
Dear community,
some time ago, I invited a Google script app. with part of javascript. The app is used for the following activities:
- Reporting the article number and error code to the database (in this case the google sheet)
- Counting how many activities have been made since the beginning of the current shift and visualising the result on the main screen
- Informing the employee in case of an error (in the process of reporting to the database, I initiated a loop, which checks the previously recorded data)
In the face of the further need of modernization the tool, I want to start using Adobe Dreamweaver and create a standalone web application, which will initially perform the same actions, but instead of writing data in the google sheet will write to the database (it has a database Micrsoft SQL server).
I've looked through the information, but I don't know where to start. The html page works, but all functions described above (written in javascript) not. I have no idea how to implement it. I also don't know how to connect the database and initiate a data counting and checking system.
I'll be grateful for any tips on how to approach this task.
AdChoices