2 Replies Latest reply on Oct 18, 2013 7:21 AM by dmayembe

    Sorting

    dmayembe

      Title

      Sorting

      Post

           Hi.

           I have to track all the account which have a shipment status "Pending". I created a report however it would show all the account with shipped and pending shipment status. I created a button to select only those status are shipped. it was working fine till this morning. trying to clean up the database i messed it up.

           this is what i am looking for

           1. How to set the button script to select only "Pending" Status

            this was button script

            

           Go to Layout[“Pending Shipment”(Invoices)]

           If[“Invoices::Shipping Status=”Pending”]

           Sort Records[Restore,No dialog]  

           I know there is a mistake in it

           2. I do not want to use the the button to display the pending status. I would like it to be triggered once the report layout is accessed. 

            

        • 1. Re: Sorting
          philmodjunk

               Go to Layout[“Pending Shipment”(Invoices)]
               Enter Find Mode []
               Set Field [Invoices::Shipping Status ; "Pending"]
               Set Error Capture [on]
               Perform Find []

               The script can be performed by button click or by the OnLayoutEnter script trigger. If you only perform the script from this trigger, the first line of this script can be omitted.

               See this thread for other examples of scripted finds: Scripted Find Examples

          • 2. Re: Sorting
            dmayembe

                 Thank you. it is working great