Hi
I wonder if the following is possible.
I have a form that contains about 30 lines of fields that can be filled in. Each line
contains about 7 fields. The first field is a dialoglist field of different products, only 1
can be selected. The next 5 of them are for each day of the week. In those fields numbers
can be entered. The last field of the line is a total field that totals all the numbers
of the day.
So it could be, ofcourse, that 1 product is selected on multiple documents with numbers for
the weekdays and totals.
I want to show documents that are created with this form in 1 view in a particular way.
Namely, first column the product, second column the year and month for which the numbers
were entered, and the third column the totals of numbers of that product
But each product must be present only 1 time in the first column in the view,the second the
month and year for which the numbers were placed, and the third
all totals of numbers for that month and year for that product.
Is this possible in 1 view??
Any help will be appreciated.
Subject: Building a complex view
I don’t know of any way to do what you’re asking. The closest you can get is to use a view with two categorized columns. The first column is the product, the second is the year and month. The third column would be the sales, which you could add up in a field on the form and display the computed field in the view. You could also have the view calculate category-level totals.
If the bean counters are really that anal about formatting, give them a view with the raw data and let them export it to Excel and do a pivot table on it.
HTH,
Charles
Subject: RE: Building a complex view
So you have like 210 fields on this form just for this table. That’s not so good for performance. See this download for table editing tools that let you manage this with just one multivalue field for each column. There’s also an upcoming article in The View by Betsy Thiede but you might not be able to wait for it.
I mean, you could do it the way you’re doing it, but managing your input translations and validations is going to be fun. Ultimately, for use in a view, you’ll need to store in the document two multivalue fields – one for the list of products, one for the list of totals. Otherwise, your view column formulas become unmanageable.
Once you have the values in a multivalue field – let’s say the product list is in the field Products, and the total for each product is in the field Totals – then I think you can do it this way. Categorize your documents by the field Products, and then put your date column, and then add a column that has Totals in it, and enable the view column option to display multiple values in separate rows.