Help setting up please
I am setting up my own small exercise business and want to track clients. Ideally I would like to:
1) Enter and track client bookings (enter booking, track if they attend, cancel or no-show)
2) For classes attended I would like to be able to enter what exercises were performed and be able to add any notes from the class
3) For group classes, I would like to be able to choose what clients attended each specific class (date) and what exercises were performed during the class for the group without having to do it one by one for each client (for example on 12 December, A B D E G attended and exercises X Y Z were performed)
So far I have created a database and set up two tables, one with clients and one with groups and I have linked them so that I can put clients in groups but I can't figure out how best to go from here.
Does anyone know if there is any tech support or a specific tutorial for this kind of business that might be helpful. Any thoughts appreciated.
2 replies
-
First thing that comes to mind is that you will probably need a third table to track classes and clients. You said you have a client and group(class) table. That makes sense. Now you need a third table, call it Enrollment.
Why do you need a third table? Well if you only have two tables, you can only create a 1:N (one to many) relationship between the two. So 1 client can only be associated with many groups or vice versa. You need a table that allows many clients to associated with many groups.
Enrollment can be a child of Groups. It is in this table where you track the day the group is offered and how much it cost, who the instructor is, and any other data that would specific to this group on this day.
You should also look into dashboards (now called Pages) so you can setup data entry forms and data analysis forms.
If your timeline is tight and you need to hire people then there are many Ninox partners that can help you out.
If you have more time than money then you may want to check out Nioxus' membership. They have an extensive video archive that covers all different aspects of Ninox. I learned a lot from them as I started in Ninox. They also provide tech support so you can ask specific questions.
-
This is so incredibly helpful. Thank you very much Fred.
-
Content aside
- 1 yr agoLast active
- 2Replies
- 40Views
-
2
Following