How to correctly implement a data handler from a database in HTML?

Question

Flask

Ku and good day to everyone)
I still have little experience in programming, I'm trying to win it) And then a task appeared at work.
I’ll say right away that I would like to use Python Flask in the implementation of the task.

The essence of the problem:
In the company ah pi telephony (managers receive incoming calls) and there is a MySQL database with a table of missed calls. Actually, you need to make a small application:
1. Insert user registration and authorization into it
2. Pull data from MySQL with missed calls.
3. Make it possible to handle these calls (so far without checking by PBX) That is, some field with a select (call processed / missed call) or a checkbox, and record which user processed which call.

The first two points, in principle, do not cause difficulties for me, but I don’t know how to make this handler correctly. The table from the database is displayed in HTML using the Jinja2 template engine.
How can I catch on which field the user has set the select (for example, processed) and then immediately remove this field from the web muzzle (do I need to change the existing database?)

The server will be launched on the local network, the network is quite large and the number of users of this system will be more than 100, I think that's for sure.

Help, maybe someone did something similar in Python and there are simple and well-working ideas.
The question is also how users will update data from the database, whether it is necessary to use web hooks or users will simply update the page (and the data from the database will be selected with the selector) Again, if someone frantically often presses f5, will it not fall off in general, the database (although there is not so much data being pulled out)))
In general, anyone who can help with ideas or some kind of solutions will be very grateful :)

Answer 1

I don't have much programming experience yet.

No offense, but don't you think that you are now trying to jump above your head with this task?
Do this -
Take this article - https://habr.com/ru/post/346344/
Further - https://pythonru.com/uroki/18-autentifikacija-vo-flask \ https://habr.com/ru /post/222983/
Further - https://flask-russian-docs.readthedocs.io/en/latest/
Well, for some reason, write to the toaster for each question.
Now you are asking future colleagues to write you a complete tutorial on how to solve your problem, and a toaster is not freelance.
UPD: see something like this - Click , to understand how to build an application model in general.

Again, if someone frantically often presses f5, will the database fall off at all (although there is not so much data pulled out)))

Can be implemented using
websockets https://blog.miguelgrinberg.com/post/easy-websocke...