Add "Percent Fulltime" field to CallerRec. Default = 100%.
(used for Auto Fill, and also in reports, etc.)
Caller table: exclude a caller from calling in a Hall (e.g., C3B)
Upon attempting to enter my first Workshop Headers, I was prompted to enter data for all halls
(C4 as well). I entered Workshop titles for all but C4 (leaving that blank). I then got this error:
Error 3315 - Field 'ColumnHeaderTable.Title' cannot be a zero-length string.
at dao.Recordset.Update(Int32 UpdateType, Boolean Force)
at CallerScheduler.frmWorkshopTitlesEdit.SaveDataToDatabase()
After I hit OK, it resumed my place in the Times table as though nothing had happened. It appears
to have taken the workshop titles I gave it, but I canât be certain of that yet.
VDC -- modify database should allow EMPTY text strings for this field.
Auto upload HTML output to web.
Clear -- allow options as with Fill, to clear only a specified column, session, etc.
Be able to mark a caller as NOT appearing in a certain hall.
Heuristics:
1. Do not have callers following the same callers all weekend.
Count how many times each caller follows another.
Report major discrepencies.
2. Evenly distribute a caller's assignments for a balanced number
of morning, afternoon, and evening slots.
Add "Name of Dance" somewhere.
Prompt user whether to use colors in HTML page.
Option to 'RANDOMIZE' cell selection on fill.
Display small dynamic window always on top,
'calling amounts' grid, with Hours per Hall per Caller.
Times list: Have 12 | 24 toolbar buttons as in Master Grid.
On Time Row, have a list of caller ID not to schedule during that time!
Master grid: save list of changes and allow multiple undos for
1) swapping 2 callers;
2) inserting a caller in a cell.
Allow cell merge on specific rows (hard?)
Display Counts/Percents, or whatever was done with the flexgrid hover.
Upload individual caller/session/day schedules to web, for mobile devices.
See what changes DLA made to HTML web output, and make the program do it instead.
Once master grid is created, no changes to times can be made. Halls too? This is bad. Must be able to change.
Would like to be able to auto populate a single hall, session, etc.
Would like to be able to auto populate with select callers only.
Once a cell is edited or a caller changed, the cell's title is lost!
Auto populate should prompt for:
1) Single hall
2) Single session
or
3) All
... and then for a list of callers to use (with checkboxes)
Master grid: filter by section, then remove a couple of callers...
populate empty will not work when filtered on section!
Heuristic to check hours per day (against time per day OR against other callers)
Be able to clear a specified section. (e.g., Saturday Night)
Remove C4 from heuristics.
Name extension with .MasterGrid
Heuristics:
1) Each hall each day (except C4)
2) Don't close then open same hall
3) Messge is nothing in a session (e.g., Sandie on Sat Night)
1) Mastergrid:
a) toolbar: add font
b) clear - should allow you to select what to clear (as in populate)
2) add popup menus for all grids
3) Time in grid should say NN:NN to NN:NN. Add 12/24 toggle.
4) Icon for the Halls/times/callers windows.
R-click to popup menu with edit color.
Halls: Title-->Hall Name; Subtitle --> Subheader
Edit rows: allow non-24hr time with AM/PM. On next, default to last time + duration.
