I am brand new to the forums and brand new to filemaker, although I am somewhat familiar with database systems and logic and have been watching instructional series to learn the program. I am trying to implement an internal application for my church and am having some trouble conceptualizing the data flow in terms of what I am trying to accomplish. A little background...
I am attempting to create a simple checklist that can be utilized for ensuring that items are completed each week that are necessary for either our Wednesday night or Sunday morning services. The checklists will be mostly the same for both service types, but they may have a few slight variations that would require them to be separate data sets. The thought behind creating a system like this is that each member of the staff would complete their specific portion before the service, and then a report could be ran from the office at a certain time to see what items have been completed and what items remain.
So the way that I am envisioning that data flowing is as such:
Staff member opens the app on their phone
Staff member selects their name from a dropdown menu, and in doing so informs the application of what departmental check list they need to be presented
Staff member completes their checklist which would simply be a list of tasks in the following format:
-CHECKLIST ITEM | X YES X NO | Comments: XXXXXXXX
Once the staff member submits their checklist as complete, it would be nice to have an address notified but that is not critical as long as a report can be pulled prior to the service which would summarize the tasks for each department, who completed the task and a timestamp for when that was done.
Pretty simple (at least I think) but I am having trouble thinking through how to structure would be for the tables and the primary key etc.
Right now, I have set up separate tables for the tasks that apply to each department, there is a table for staff and their information, and then I assume there needs to be a "go-between" table that will serve the appropriate tasks list to the appropriate staff member based upon their department.
Apologies if I am not explaining things well, I am just getting started so trying to digest how to create a somewhat non-standard database out of the gate.
Looking forward to learning more on the site and becoming an active member of the community. Thank you in advance for the help!