We are trying to design a new screen for data input with a grid similar to a spreadsheet. Let me try to picture our situation. Our products are garments in all kinds of sizes which could be XXS to XXL, 44 to 64, etc. Several size systems are at play here and every kind of garment has its own system as well as size range. Our design team needs an easy input screen with spreadsheet like layout. Per type of garment and per size there are several measurements to be made. Think of something like this for trousers:
44 46 48 50 52 54 56 58 60 62 64
Waist . . . . . . . . . . .
Inseam . . . . . . . . . . .
Length . . . . . . . . . . .
Pocket . . . . . . . . . . .
The left column contains the measurement types. The top row contains the sizes. Every dot is a measurement that needs to be recorded.
A t-shirt however might look something like this:
2XS XS S M L XL 2XL 3XL 4XL
Waist . . . . . . . . .
Neck . . . . . . . . .
Length . . . . . . . . .
Sleeve . . . . . . . . .
This screen will be the first of many we have in mind.
The question is how do we accomplish this? I was thinking of designing a cube first but those are for data analysis and not suitable for data input. I was jotting some different ideas such as a formlist or using a layout procedure but the latter is for forms only of course. I haven’t really thought of anything useful yet.
Our old ERP system is capable of displaying only certain columns in a grid. I’m not sure how it does this but my guess is that it applies similar logic as cubes in the software factory. Am I missing a trick in the books here that gets us where we want to be?