chris.paschen
Chris Paschen
I've got a project that I need to do for our local scout troop and it's escaping my mind how this might work (or even IF it is possible within Fabrik).
The basic need is to track the boys participation in events (i.e. an attendance system) that both records attendance and assigns an award (like a grade) to the boys. It needs to allow the data entry person to set a number of filters (select group of boys based on a fields in their profile) and then identify the 'award/s' that would be assigned to the boys record.
It would look something like this:
EVENT INFO
Event Date: [Date selector]
Event Title: [Text field]
Leaders: [look-up in leader table, multiple select]
Group: [look-up in group table, single select]
PARTICIPANTS
The participant area should be populated automatically based on the 'group' selected in the Event Info.
The participant should have a couple check boxes to allow assigning.
Like this:
Participant Present Participated
Joe Smith [ ] [ ]
Jim Doe [ ] [ ]
Sam Johnson [ ] [ ]
...etc.
MY DILEMA
Is how to polulate/show the 'many' (participant) part of this one-to-many form - having it pre-populated based on the selection in the main part (Event info) of the form. How to filter that participant list on the 'group' field selector.
In addition, the end goal will be to generate a list for an individual boy that shows all their attendances and participations.
I'm open to any creative way to solve this problem (including potentially 're-configuring' the way we are approaching it - although we have to be able to only work with the participants from specific groups (because there are close to 100 participants in the organization).
I know I'm probably over-thinking this, but it's one of those pesky problems (for a pro-bono project) and any help would be appreciated (by me and the boys and families).
The basic need is to track the boys participation in events (i.e. an attendance system) that both records attendance and assigns an award (like a grade) to the boys. It needs to allow the data entry person to set a number of filters (select group of boys based on a fields in their profile) and then identify the 'award/s' that would be assigned to the boys record.
It would look something like this:
EVENT INFO
Event Date: [Date selector]
Event Title: [Text field]
Leaders: [look-up in leader table, multiple select]
Group: [look-up in group table, single select]
PARTICIPANTS
The participant area should be populated automatically based on the 'group' selected in the Event Info.
The participant should have a couple check boxes to allow assigning.
Like this:
Participant Present Participated
Joe Smith [ ] [ ]
Jim Doe [ ] [ ]
Sam Johnson [ ] [ ]
...etc.
MY DILEMA
Is how to polulate/show the 'many' (participant) part of this one-to-many form - having it pre-populated based on the selection in the main part (Event info) of the form. How to filter that participant list on the 'group' field selector.
In addition, the end goal will be to generate a list for an individual boy that shows all their attendances and participations.
I'm open to any creative way to solve this problem (including potentially 're-configuring' the way we are approaching it - although we have to be able to only work with the participants from specific groups (because there are close to 100 participants in the organization).
I know I'm probably over-thinking this, but it's one of those pesky problems (for a pro-bono project) and any help would be appreciated (by me and the boys and families).