all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||||||||||||||
|
|
|
Blue
|
|
|
Sorry, no photos available for this element of time.
|
|
|
|
Notes:
|
|
We need the ability to set specific data types per custom fields in the flex grid tie-ins. These are things like text, dates, numeric, decimals, boolean (yes/no), etc. That way we could do calculations, search date ranges, do aging, hold real money values, etc. Currently all custom fields are stored in text fields which do not allow certain functions. Just an idea... We could run data through a conversion type function (force apples to apples) and then do some sorting or filtering. We could also create and use temp tables if it got to that point (convert, filter, report, and then destroy the temp table). This could be done over and over or we could figure out a more permanent solution. My goal as the developer would be to make the solution be as light as possible so that every record didn't have to carry a huge extra data burden (potentially tons of unused fields, flags, and indexes). Keep it light and quick... :) |