Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Uk
    Posts
    9

    Unanswered: Sorting in order

    Hi

    At present Im having a nightmare

    I have 9 fields which are laid out as a list

    What Im trying to do is create a script that sort s the info

    A-Z Order

    I haev tried
    Sort
    Set field "A-Z)

    And it dosent work

    Can any body please help me I have sent hours trying to sort out why it not working

    I know its to mind blowing File Maker but im new it all and this is my first one

    thanks
    Attached Thumbnails Attached Thumbnails picture 16.jpg  

  2. #2
    Join Date
    Sep 2003
    Location
    San Francisco
    Posts
    70
    First sort your list in "browse" mode. Then right after that open scriptmaker and create a new script. Add the "Sort" script step. Exit the script. You'll see a dialog asking you if you want to replace the sort order or keep the old one. At this point it doesn't matter. Just click OK.

    Now your script has "saved" the last sort order.


    Moving on...
    Now say you sort the list by a different field. Then you open your old script. Then without changing the script you click "done". You'll see that same dialog asking you if you want to replace the sort order or use the old one. If you choose to use the old one (default) then your script does not change and it continues to sort on the first field. If instead you choose to replace the sort order, your script re-saves the sort order based on the most recent sort (the second field). Now when you run your script it will sort based on the second field.

    Hope that helps.

  3. #3
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Question Re: Sorting in order

    Isn't this the same post and basicly the same answer you got yesterday (a few post down from here)?

    Originally posted by stupot
    Hi

    At present Im having a nightmare

    I have 9 fields which are laid out as a list

    What Im trying to do is create a script that sort s the info

    A-Z Order

    I haev tried
    Sort
    Set field "A-Z)

    And it dosent work

    Can any body please help me I have sent hours trying to sort out why it not working

    I know its to mind blowing File Maker but im new it all and this is my first one

    thanks
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •