Looking for suggestions here.
I have a requirement to send a message at several levels of the app.
The app is laid out like this…
There are several Facilities, a Facility has several Classes, each Class has several Students.
There is also a list of SMS Messages.
Facilities Table - name, address, phone etc Classes Table - facility, name, startTime Students Table - name, address, phone, etc StudentsToClass - student, class
Messages - title, message, lastSent
Currently, You can send messages to ALL students using “Send to All” action on the messages table.
I also have actions that will eventually…
Send to Facility Send to Class Send to Student
each on their respective tables.
However, I can’t seem to figure out how to link the Actions with the messages table. I would like to be able to click the action, pick a message and then have the app send it to that level of the students.
If you click the Facility action, you’d send the message to each student in each
classes at that facility
If you click the Class action, you’d send the message to each student in that class.