3 Replies Latest reply on Jul 15, 2011 8:00 AM by danshockley

    Multiple field sorting

    JamieMilne

      Title

      Multiple field sorting

      Post

      Hi,

      I'm using FileMaker Go for ipad.

      Is it possible to sort a layout twice, then save those results as it's own layout?

      Ie I have fields a b & c.  I'd like to sort by column C, then by column A.  THen save that as a layout for easy access.

      Right now I can go to a layout and sort once, but not twice.

      Thanks,

      Jamie

        • 1. Re: Multiple field sorting

          Jamie Milne:

          Thanks for posting.

          FileMaker Go has the ability to sort by multiple fields. To do this, tap on the small magnifying glass in the lower right hand corner when viewing your database and choose Sort Records. In the list of fields that comes up, tap on column C and then column A. From here, click Apply and verify that everything sorted as expected.

          TSBear

          FileMaker, Inc.

          • 2. Re: Multiple field sorting
            philmodjunk

            When setting up your database using FileMaker, you can create two table occurrences (boxes in manage | database | relationships), to the same table. If you create two layouts, one to each table occurrence box (selected in Show Records From), you can have one set of records on one layout and a different set of records on the other. This might be a way to get what you want when you described "saving a sort order as a layout".

            • 3. Re: Multiple field sorting
              danshockley

              It sounds to me like you'd like the layout to automatically apply your sort whenever someone views it. If that is true, create a script that runs your Sort (without showing the sort dialog), then attach that script as a Layout Script Trigger for the On Layout Enter event.