Hi
I need some advice. I have a form with 3 fields, model, category and quantity. These fields are dialog lists with values. The same fields are repeated ten times on the form. I am now trying to categorise the view based on the model and in my column in the view have added the list of fields…ie…model1…:model10.
The big problem which is logical is that it is displaying the data wrong…it is only displaying the model field once for the first field and then displaying the remaining fields as uncategorised…as I have requested the view to show multiple values seperately.
Does anyone have any ideas about this? I am really stuck.
Many thanks in advance.
C
Subject: Categorised View?? Need some advice.
I’m not 100% sure of what you are trying to do, but:
maybe you can use :
@Trim(model1:model2: … :model10)
as your column formula. It will remove the empty fields from the list.
Subject: RE: Categorised View?? Need some advice.
Hi…the @trim did help but it is still giving me problems…
on the form capturing the data there are 3 fields repeated ten times with different categories in each.
the user composes a prospect report on this and chooses different or the same values in each field.
the view looks correct until you see that it is repeating the first category for all the documents…not sure why it is doing this?
Here is an example of the column formula.
Thanks for your help
See formula
(@Trim(PrsCategory_1: PrsCategory_2 : PrsCategory_3 : PrsCategory_4 : PrsCategory_5 : PrsCategory_6 : PrsCategory_7 : PrsCategory_8 : PrsCategory_9 : PrsCategory_10)
Subject: RE: Categorised View?? Need some advice.
There’s no easy solution for this. You can work around this in rather tricky way, as explained in this thread : .
The idea is to combine all your fields in one computed text field, and then to show parts of this text field in the different columns. It works, but it gets slow when using more then 2 columns, and you’ll get stuck when you want to categorize in more then one column.
My advice:
Put the repeating fields in different documents. This will keep your views simple and speedy. Here is one way to achieve this :
make a form (e.g. “Row”) with one model field, one category field, and one quantity field, and a hidden ‘orderid’ field.
make a categorized view of these documents, categorized on the ‘orderid’ field
make a form (e.g. “Order”) with an “orderid” field and embed the view. Make the embedded view a single category view, showing only the category kept in the ‘orderid’ field.
add a button to add a new line. Clicking this button wil compose a new “Row” document. The “orderid” field must be copied form the order-document to the newly created row-document
if you want to compute totals in the order form : this can easily be done with computed fields and the @DBLookup-function.
Otherwise, you probably will get in trouble when changing/extending you application later.
Subject: RE: Categorised View?? Need some advice.
Thanks…I am going to have to redesign the form, will use your suggestions.