MyTaskHelper.ru in practice: creating a free database to check the results of the OGE

From the end of May to the end of June, the OGE (basic state exam) in all possible subjects is held in Russian schools and students are eagerly awaiting their results.

Thinking over the topics of future publications about our project MyTaskHelper, we could not dwell on anything concrete. But the idea came by itself at the moment when our service began to use the Ministry of Education and Science of the Astrakhan Region. Yes, it did not seem to you: MTH is actively used by government agencies. And in the specific case described above, the site administrator astrcmo.ru created and added a login form to the resource, which allows access to the record after filling in the required data (login and password).

Fig. 1 Built-in astrcmo.ru widget

Algorithm for creating such a module : on the website mytaskhelper.ru , a database with personal information of students and their grades is created or imported and access to the recording widget by login and password is configured.

It looks like this (we created a test web form from scratch (you can see how this is done in the subject , but you can just export your ready-made database in CSV or Excel format):

Fig.2 Fields of a web form constructed in MTH, through which you can add information to the database.

In the settings of the field called “Document series”, select the “ Login ” data type, and “Document number” - “ Password ”.

And this is what the full database looks like.

Fig. 3 Filled database with personal data and estimates

In order to configure access to the record by login and password, go to the Widgets menu => Login Form and set up the access mode. After editing the login form, we get the following result, which is embedded in any page of the site. To do this, on the “ Integration ” tab, just copy the link, iFrame or choose another option to share the widget and embed it in the right place of the site.

Fig. 4 Login form on the record widget

Note that the following options can be selected in the widget settings:

• allow to edit the record after login;
• allow the export of records to Excel;
• Allow to export records to PDF.

EVERYTHING! Then a student who wants to find out his points goes to the site page and by entering a login (in our case it is a document series) and a password (document number) (Fig. 4), gets access to the record from the database that stores the desired result ( Fig.5).

Fig. 5 Record from the database that the student sees by entering a username and password

Obviously, this function can be used anywhere. For example, it is in demand from the owners of online stores, where it can be used to configure customer access to records of products, their status, etc. The function will also be useful for teachers who can easily give parents of their students access to their current grades by login (for example, this will be the last name) and password (an individual numeric or alphanumeric code).

In order to test how it looks live, you can go to the widget and enter the username / password from the table above or test / test, make sure that the functionality is working. Note that if there is one record in the database with a certain combination of login and password, we will get one record at the output, if there are several of them (as for test / test), they will be displayed in a tabular version with the ability to search and group by table (Fig. 6).

Use with pleasure, and we will be happy to answer any questions.