Mathieu, And if your not restricting your 'sort order' values to integer values starting with zero and increasing in values then you might also need to decide how to figure out the "step size" to "increase by" too. (and you might need to alter a "non-selected" record to increase/decrease it by that same step size too) The step size might also be another field on the form that the user can set before they push either of the "move" buttons too.
Which can all be done in workflow, and or a few more display only field. However... You may also have to deal with the user altering the sort order in the table field by clicking on the column headers too. My opinion... show the user the 'order field' column too. That way they know what the system is doing. (Add 1, Add 5 etc...) and if that delta does not actually change the order of the records because two records now have 'order field' = "5" then they can move one of the two rows one more time. :) They need not modify the value directly, but that could be done too. And... if your "move" buttons can operate on more than one selected rows in the table field that might be helpful to the users. (Select these 5 rows and add "x" to all of them to move them as a set instead of needing to click each record then a button and repeat 5 x N times.) 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. On 2/23/07, Shellman, David <[EMAIL PROTECTED]> wrote:
Mathieu, I did this on a form of mine. I included a field in the form for sort order. I included this field as a hidden column in the table field. I associated active links to the up/down buttons that threw an arrow image on. The workflow performs a push fields that resets the sort order field of the record being displayed and the other associated record. In other works if the up button/arrow is pushed work flow decreases the sort order value by one and increases the sort order value of the record above it. The active link then refreshes the table field. You need to check for a special condition if the record is the first or last record in the table and the direction of the change but the functions are the same. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre Sent: Friday, February 16, 2007 7:34 AM To: [email protected] Subject: Move table rows with up/down arrow botton Hi all, ARS 6.0 I would like to do move the rows in a table with a up/down bottons. Let me explain you the details : I have a table in which some activities resides. Those activities need to be put in a specific order. However, I do not want to users to specify the order in a field manually. In fact, I would like to populate the new value in the order field(the table is sorted by the order field) of each entry in the table by clicking on a up or down arrow button. In other words, instead of specifying the order of each entry, they would select the entry(row) in the table and then click on the up or down botton to move the selected row , ..., and all the others obviously. Do you know how I should develop this? Mathieu Pitre
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
