Pre-populate capture records for one day.

[Brady Kelly]

I have capture screen where a user will capture daily production figures for several performance categories, i.e. they will enter a single figure per category on any particular day. Now I don't want the user to insert a new record for each category-figure record, so I plan to check if the day has records for all categories. If not, before opening the capture screen, I will add a record for each category to that day. One problem is that over time, categories can be added, so if I have 30 categories, and check if Oct 12 has 30 categories, it could be that on Oct 12 there were only 27 categories. I will then need a CreatedDate on the categories, and when I check categories for a particular day, I will only count categories created on or before that particular date. Any other means of capturing daily figures besides my capture screen will be prohibited, so I am fairly confident that if only a sub-set of categories exists for any given day, they were not properly created, and I can delete them and recreate all categories for that day. EDIT: I can no longer do the above, as the user may capture data for one day, and in the same day decide to add a category. Using only categories with a create date earlier than the current date will prevent the new category being visible today. Not using the 'earlier date' method will result in today's data being cleared. Is this design sound? Can I do anything to improve it?

[Mycroft Holmes]

This is obviously too hard to answer - probably belongs in the design forum anyway.... This seems reasonable and as for the edit, what not have a >= today? How do you intend to support a category that needs to be retired? I love asking these questions, years of trying to answer them I guess. Have a from to date where the default to date = datetime.maxvalue (31/12/9999) and use where today between from and to Caveat - datetimepicker does not support datetime.maxvalue.