mikesimaska
Member
Here's my app in a nutshell:
3 tables (all external to joomla)
units - marching bands, winterguards, etc...
id PK
name
type 0=outdoor 1=indoor
events - competitions of units
id PK
name
type 0=outdoor 1=indoor
date
entries - participating units (and their scores when the event is complete)
id PK
unitid FK units.id
eventid FK events.id
score
awards
completed boolean
I've been making good progress using the default stuff and not digging into many details. Now I need to do some real "application" type stuff.
I need a form in which I can
Select An Event (a combo box is ok for now -- i want to be able to filter events by date eventually)
If the Event has Entries:
Display the entries with 2 text boxes next to each entry for the scores and awards fields. If data is entered in a text box, the record should be flagged for updating.
Have an "Update" Button which posts the scores and awards back to the entries table and sets the completed flag to True for those entries.
If an Event has no entries,
Let me add multiple units to the show in a single form
Ideally this would be unlimited but i'll settle for X number entries added at time (for now!)
Note there are two types of unit (indoor and outdoor) with a corresponding field in events. Only outdoor units can attend outdoor events (and vice versa).
<aside> If I add fields to a physical table do I need to start over on my Fabrik stuff or can I simply add new elements? </aside>
3 tables (all external to joomla)
units - marching bands, winterguards, etc...
id PK
name
type 0=outdoor 1=indoor
events - competitions of units
id PK
name
type 0=outdoor 1=indoor
date
entries - participating units (and their scores when the event is complete)
id PK
unitid FK units.id
eventid FK events.id
score
awards
completed boolean
I've been making good progress using the default stuff and not digging into many details. Now I need to do some real "application" type stuff.
I need a form in which I can
Select An Event (a combo box is ok for now -- i want to be able to filter events by date eventually)
If the Event has Entries:
Display the entries with 2 text boxes next to each entry for the scores and awards fields. If data is entered in a text box, the record should be flagged for updating.
Have an "Update" Button which posts the scores and awards back to the entries table and sets the completed flag to True for those entries.
If an Event has no entries,
Let me add multiple units to the show in a single form
Ideally this would be unlimited but i'll settle for X number entries added at time (for now!)
Note there are two types of unit (indoor and outdoor) with a corresponding field in events. Only outdoor units can attend outdoor events (and vice versa).
<aside> If I add fields to a physical table do I need to start over on my Fabrik stuff or can I simply add new elements? </aside>