April 16, 200916 yr Hello all, I posted on another thread with no luck so I thought I would start a topic to see if I could get the answer I was looking for. I am trying to sort a portal with header buttons that sort ascending when clicked and descending when shift clicked. I have the ascending part working with a global field and a calculation field. I have set up a global that sets to 1 or 0 depending on click or shift click. Now I am stuck. The instructions I am working with are lacking in detail at this point and I can't figure out how to tie it all together. Does anyone have a link to some detailed instructions on this method? I would like to mention up front that I have researched extensively and have decided on a calculation sort rather than the tab method simply because I don't want to create and maintain 12 tabs to sort ascending and descending on 6 fields. All fields are text and the portal will never have more than a couple hundred rows. Also, I have looked at PortalSortExtreme.fp7 from excelisys but it is a bit too complicated for me to deconstruct. Sorry I'm still a bit new. Thanks for any help. UPDATE: It figures, right after I posted this I was able to work it out. Sorry... Edited April 16, 200916 yr by Guest
May 12, 200916 yr I know you found a solution, but here is an easy way to do this, and it has the benefit of not having to shift click. Instead just click the button and it will make it ascending, click it again, and it will change to descending. Lets call your global field Global for this example. What you need to do is create a script as follows: If [Global = 0] Set Field [Global; 1] Else If [Global = 1} Set Field [Global; 0] End If Commit Records/Requests When you select If, Else if, and Set Field, at the bottom of the window you will see buttons for selecting what field and entering you calculated result (just type 0 or 1 when the calculation box comes up)
Create an account or sign in to comment