Hey, Carey: I was just looking at that very field a few days ago as well.
We just had one of our users ask a related question. He is irritated that he has to constantly resize a particular column on a non-ResultsList table every time he logs in. Since we know we can set Preferences on the ResultsList for any form to remove and add columns. Wouldn't it seem that we should be able to do that for any column on any non-Results List table as well? And also control the sizing for columns on any non-ResultsList table, too? The next step is to make it dynamic enough that any user could set the sizing of any column on any table of any form at any time and save it. I know this can be done. Instead of reinventing the wheel, I wish I could just duplicate the Preferences button on the Results List and apply it to any table. My gut tells me that this can be done as well. In looking at the syntax. The first part makes sense, server, form, view. But the next set of numbers DOES NOT reference any particular field ID on the form. I have picked up the pattern for this. The number is just a place holder for a results list column. It starts in the same order no matter what form is opened. Example: In the table included below 2147483647 refers to the first ResultsList column;2147483648 refers to the second ResultsList column. The same will be true for any form. I've included the contents of the Table Field Column Width field after expanding a column on both HPD:Helpdesk and CHG:Change. Notice the column numbers. They are identical. Note: there will be exactly one row for each column in the ResultsList per form. arserver|HPD:HelpDesk|300919982|2147483647=11811 (Column 1) arserver|HPD:HelpDesk|300919982|2147483648=11811 (Column 2) arserver|HPD:HelpDesk|300919982|2147483649=9449 arserver|HPD:HelpDesk|300919982|2147483650=3937 arserver|HPD:HelpDesk|300919982|2147483651=3937 arserver|HPD:HelpDesk|300919982|2147483652=3937 arserver|HPD:HelpDesk|300919982|2147483653=45219 arserver|HPD:HelpDesk|300919982|2147483654=11811 arserver|HPD:HelpDesk|300919982|2147483655=11811 arserver|HPD:HelpDesk|300919982|2147483656=7874 arserver|HPD:HelpDesk|300919982|2147483657=7874 arserver|HPD:HelpDesk|300919982|2147483658=11811 arserver|HPD:HelpDesk|300919982|2147483659=11811 arserver|HPD:HelpDesk|300919982|2147483660=15186 arserver|CHG:Change|300906900|2147483647=11811 (Column 1) arserver|CHG:Change|300906900|2147483648=7874 (Column 2) arserver|CHG:Change|300906900|2147483649=11811 arserver|CHG:Change|300906900|2147483650=13386 arserver|CHG:Change|300906900|2147483651=14173 arserver|CHG:Change|300906900|2147483652=12036 arserver|CHG:Change|300906900|2147483653=11811 arserver|CHG:Change|300906900|2147483654=31496 The bigger question that I've never thought of until now. Where are the references to the Results List stored. It has to be stored somewhere. Since you can only set up one Results list per form, it shouldn't be a view reference. Thanks for letting me think out loud Michelle Mid-Tier 7.0.01 P1 ARS 6.3 P21 Flashboards 6.3 P20 Email 6.3 P21 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, March 22, 2007 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: Add a Column to Table Prefs All, Opps... ( I was told that my post was not 100% in an off list post. Thanks for the nudge.) Minor correction... " It looks like the data structure is: <ARSServer>|<ARS form>|<ARS_View_ID>|<Column_FieldID>=width_value " I was to fast and loose with my looking at the values I was seeing. But it does make sense that on one view the user might want to hide colA, but still see it in a different view. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 3/22/07, Carey Matthew Black <[EMAIL PROTECTED]> wrote: > Kevin, > > The data is stored in the User Preference form (if the user is using a > preference server) and likely in the local ar.ini if they are not) in > the field 'Table Field Column Width'. > > It looks like the data structure is: > > <ARSServer>|<ARS form>|<TableField_FieldID>|<Column_FieldID>=width_value > > > If you set the width_value to zero then the column disappears in the > table field. > > You likely will need to have the column visible to start with. > Your users will have to login AFTER you muck with there record in the Pref form. > > HTH. > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"