I want to do something of which I don´t know if it is possible at all.
I have a view with a few columns. 1 of the columns I use the option “Use value as color”. The value of this column is coming from a field that has a value like this 0:0:255:0:0:255.
I want this field to be multi value like this:
0:0:255:0:0:255
10:200:255:10:200:255
200:31:255:200:31:255
97:150:255:97:150:255
So that i can enable the option “Show multiple values as seperate entries” on the color column.
My question is the following:
Is it possible to use the option “Show multiple values as seperate entries” to show different colors?
If so, how can I seperate the color numbers in the multivalue field in order to show it correctly in the view?
Sorry - it does not work that way. When you have multiple columns showing multiple values as separate values, notes shows every combination. It will not match them up in any sort of order.
I understand what you say. I just makde both columns sorted and indeed it showed all possible matches. I had only the forst multivalue column sorted thats why it showed properly.
But is it possible to do what I want? Having a multi valued color column?
Maybe we should be asking you ‘what do you want to do’? Forget about colors, multi-value fields, rows, columns, etc, what problem are you trying to solve?
I was working on a project tool in which yoo can plan, for instance projects. The projects can be planned by the hour. The requirement was to show the time blocks in the view by colors so people can easily see the differentiation between the different projects or other activities.
But to show such a view in the client properly I was trying to show the days by clicking on a week category. This catagory shows 7 lines for each day of the week. The columns then are divided by hour. So beside the columns for the categpries I have 24 columns for each hour. These columns are color columns.
Thats why i was trying to create a multi value color column to easily show the different colors per day.
Graham, you’re not quite right. If you have multiple columns that are set to display multiple values in separate rows, the view will show all the combinations of the sorted columns. If only one of the columns is sorted, the view will show values at the matching positions in the other columns. E.g. if column 1 has “A”:“B” and column 2 has “1”:“2”, and only column 1 is sorted, you would see A - 1 in one row, and B - 2 in another row, and not A - 2, for instance.
However, this doesn’t help Harry, because a color value actually contains multiple list items. So you would need a value in one column to correspond to the first six values in another column, and the second value to the next six, and so on – the view doesn’t have a way to do that type of matching. It only knows how to match one element to one element.
If it were an HTML view in a web application, it would be a different story, since you could arrange to generate passthru HTML as a list with one element per row to set the color.
I am not restricted to use only 1 document( the user does not have to know that in the background multiple docs are used specially for the color columns).
I am trying to understand what you suggested. can you explain me more or give me an example how I can use multiple values into seperate documents and show them as different colors in the view?
Subject: Use a work-around…Response docs and queryopendoc
Harry,
Use the values in the main document to publish the combinations you require into a response document.
Create a view which only shows the response documents. The response documents basically become “place holders” that simply exist to make the view appear the way you want it too.
Use the queryopendocument event in that view to:
get hold of the parent,
Continue=False,
Open the parent document instead of the response.
Using this method allows you to manage the view by only modifying one form (the main document), but then display multiple iterations of that one document in a view by NOT showing the main document in that view, you only show the response documents that you create programmatically based on the options in the Main document.
An example of this is in our “Monthly Wall Planner” database … LINK
In the above example, if a user creates an entry that is within a particular month, you only need one combination of colours, however, if the entry spans months you need to use different combinations in different columns.
Clicking on one of the entries in the view opens the main document, changing the main document creates/modifies/deletes the responses depending on the settings in the main document.
These is also a requirement when using this method to handle the delete event in a view differently, since you have to use additional logic (similar to the way repeating entries are handled in the Notes calendar) to determine whether the user wants to delete the entire combination (the Main document AND ALL responses) or just a certain combination (Change the main document and remove the responses that are no longer needed).
Well yes - if you don’t sort a column that has the multi-values option checked, it only shows the first value of that field anyway, so it’s not really a muilt-value column.
