Hello
I have collections with clients who take their children to school, have a separate collection with children and also a collection with a subject and a teacher. Who can help with the idea of how to do this?
Also there is a personal office of the client and the teacher. In the client’s office I want to show the student’s schedule. A pupil can go to several subjects, to different teachers on different days and at different times. In addition, the client’s office should have a homework and a separate table view that shows what day and time the student was engaged in. What kind of homework was given to him. What would the client see the result of the teacher’s work. That, on the basis of this data, it is possible to see what kind of discipline a student has.
The teacher’s office should have his schedule, and a table for the daily report, on the basis of which the results are then summed up in the client’s office.
There is also an administrator who monitors the teacher’s work on reports and student attendance. And also the administrator can, in his office in case of not switching to the work of one of the teachers, change the schedule for the students who must come to their lessons, thereby replacing the lesson with another subject for the time of the absence of the other teacher. Thus, the client will see a change in the schedule and the teacher who came instead of the other teacher will be able to pass the report for his work done
At the same time, I can not load the teacher’s job of submitting a report, so that he does not type each student separately into the form. It is necessary that he chose his priedmet, the day of the week and with almost one button filling only one line could send the report to the administrator. The data of this report will also be seen by the customers.
Approximately I see it this way:
There should be a collection separately for the client, the student, the teacher, the subject, the day of the week. But how to connect them so that clients and teachers can go to the dynamic page and see the data based on their ID.
Wow! That sounds like a lot! The kind of system you’re talking about is large and complex and is no trivial task to build. Although, if I’m not mistaken, everything you described can be done in WixCode but this is definitely a challenge. I’d recommend one of two options.
The first option is to do it yourself. I’d recommend starting with breaking down you entire design (it sounds like you already did this or at least start) into relatively small and coherent parts parts. Think about what kind of collections you’ll need (Teachers, Clients, Students, Schedules, Homework assignments, etc.). List out all the different functionalities you want to provide, and start implementing them one at a time. Start with something relatively simple like having a collection of Teachers and SubjectSchedules, and create a dynamic page where you can see the schedules of a specific teacher. Slowly build up the functionality piece by piece. Take a look at our video tutorials ( https://www.wix.com/code/home/videos ) to learn how to implement these flows as you build them. You have additional useful articles and examples here ( https://support.wix.com/en/wix-code/wix-code-tutorials-examples-videos )
The second option, if you don’t have the time to develop it yourself, or you’d like professional help, is to go to the Wix Arena and find an expert that can build the application for you, or help you out in a way that fits your needs.
Which ever option you choose, I hope it works out for you!
J.
HI Jonathan Avinor
Thank you very much for your advice. I turned to specialists, but they are still silent. What you managed to do yourself, is to create collections and based on the filtering to show data about the students. But these data do not show the information correctly, or as we would like. Between collections there is a link of key fields, on the basis of this through a dynamic page the table shows the data. But if you add one more student to the client, then the table in the client’s office shows only the one who sorts by the first and the second does not show. Sorting in this case does not work. I’m sure that through the code you can do this, because the page on which the client comes in or the teacher sees who exactly visited the site.
How there is a visitor’s recognition, you can look at this topic.