We have a support database that contains repetitive fields ie PM, Reported By, application, severity, status, date opened etc…
Is there a way to have this column list be dynamic and saved as a user preference where each user can define their own views?
Subject: Dynamic Column Ordering
Just make all of the columns sortable and select the “Allow customizations” option on the “i” tab of the view properties box. The user can then re-order the columns as desired using the View->Customize this view dialog.
Subject: Dynamic Column Ordering
I have done many “built” views as I call them. I take the HTML of the view and compose my own HTML /CSS to display the values in it the way I want. It is more work, but very satisfying.
Use a WebQueryOpen agent to tag the HTML from the view rows/columns with either IDs or Class values. Then after it loads, you can have JavaScript apply CSS to any Class and the same to any IDs.
Do this by have a form that looks like your views (color, headers, etc.) Then have the WebQueryOpen (WQO) spit out the HTML to a richText field set as Pass through HTML. You can also have the WebQueryOpen agent look up preferences for specific users.
In the WQO agent you can get the view and each entry. If the columns exist in the view, then you don’t have to touch each document, you can just get entry.ColumnValues(0), ColumnValues(1), tag the values, then spit it out to the RichText field.
The other option is to set the view to be HTML and put your Class and/or ID tags in the value for each column. Then have JavaScript rework it after loading. Use @DocNumber for ids.
Good Luck.
Tim Williams