# Sort in FileMaker

**URL:** <https://the.fmsoup.org/t/sort-in-filemaker/789>\
**Category:** Market Surveys\
**Created:** [February 27, 2020, 12:13pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789 "2020-02-27T12:13:00Z")\
**Posts on this page:** 19\
**Page:** 1

<div class="post-metadata">

**Author:** ![MonkeybreadSoftware](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/monkeybreadsoftware/32/361_2.png) [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\
**Post date:** [February 27, 2020, 12:13pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/1 "2020-02-27T12:13:01Z")

</div>

Would you like to sort layouts or fields alphabetically in #FileMaker?

We may have a menu command for you soon...

 ![sort fields](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/1X/acd3d602eb3b42b836a7786bbadd0756a8373653.jpeg)

 ![sort layouts](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/1X/545e333eb530561989451ac09ddf7f3ad8129332.png)

---

<div class="post-metadata">

**Author:** ![Markus](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Markus](https://the.fmsoup.org/u/Markus)\
**Post date:** [February 27, 2020, 5:52pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/2 "2020-02-27T17:52:15Z")

</div>

sooo cool!

Can we have that in the 'set field' box (when in layout, etc.) as well?

---

<div class="post-metadata">

**Author:** ![MonkeybreadSoftware](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/monkeybreadsoftware/32/361_2.png) [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\
**Post date:** [February 27, 2020, 6:06pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/3 "2020-02-27T18:06:52Z")

</div>

Which box exactly?  
It works in many lists as long as the first column has the text and the list can be sorted via drag & drop.

---

<div class="post-metadata">

**Author:** ![Markus](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Markus](https://the.fmsoup.org/u/Markus)\
**Post date:** [February 27, 2020, 6:17pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/4 "2020-02-27T18:17:16Z")

</div>

in layout mode, drag the field-tool into the layout - then, a dialog appears where You can select a field

---

<div class="post-metadata">

**Author:** ![Bobino](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bobino/32/194_2.png) [@Bobino](https://the.fmsoup.org/u/Bobino)\
**Post date:** [February 28, 2020, 5:13am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/5 "2020-02-28T05:13:28Z")

</div>

Layout mode field order should be based on field definition "preference" (alphabetical, creation, custom). It looks like @MonkeybreadSoftware's tool can let you easily set groups of fields within the field definition as a custom order where it would be alphabetical (without having to add a prefix to group fields belonging to the same group).

Or maybe I'm misinterpreting this altogether.

---

<div class="post-metadata">

**Author:** ![Markus](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Markus](https://the.fmsoup.org/u/Markus)\
**Post date:** [February 28, 2020, 6:25am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/6 "2020-02-28T06:25:45Z")

</div>

that's what I would really love to have - set the sort order where You need that, without going to definition and change that there (will be temporary when on fms).  
We often have sort order 'by creation' - but when working on layouts, abc-sort would be handy - also a search box would be so cool

---

<div class="post-metadata">

**Author:** ![MonkeybreadSoftware](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/monkeybreadsoftware/32/361_2.png) [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\
**Post date:** [February 28, 2020, 6:54am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/7 "2020-02-28T06:54:35Z")

</div>

You have MBS Plugin installed in a recent version?

When you open that dialog, click in the list, press Command-F and see a search box.

---

<div class="post-metadata">

**Author:** ![samfmp](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@samfmp](https://the.fmsoup.org/u/samfmp)\
**Post date:** [February 28, 2020, 7:47am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/8 "2020-02-28T07:47:02Z")

</div>

Nice feature. Is that possible for japanese or other languages using non-alphabetics?

---

<div class="post-metadata">

**Author:** ![Markus](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Markus](https://the.fmsoup.org/u/Markus)\
**Post date:** [February 28, 2020, 7:56am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/9 "2020-02-28T07:56:43Z")

</div>

well... 60% of the time, I'm on windows )-:

Loaded the latest mbs plugin on my MacBook - wonderfull!  
(had an older version on that machine)

Thank You so much, Christian!

---

<div class="post-metadata">

**Author:** ![MonkeybreadSoftware](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/monkeybreadsoftware/32/361_2.png) [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\
**Post date:** [February 28, 2020, 8:14am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/10 "2020-02-28T08:14:27Z")

</div>

We do use localized compare, so please try what happens for Japanese users.

---

<div class="post-metadata">

**Author:** ![samfmp](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@samfmp](https://the.fmsoup.org/u/samfmp)\
**Post date:** [February 28, 2020, 8:15am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/11 "2020-02-28T08:15:21Z")

</div>

Ok. I will try it when it is released.

---

<div class="post-metadata">

**Author:** ![Bobino](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bobino/32/194_2.png) [@Bobino](https://the.fmsoup.org/u/Bobino)\
**Post date:** [February 28, 2020, 2:01pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/12 "2020-02-28T14:01:06Z")

</div>

@Markus, MBS is one of the factors that lead me to prefer Mac (see [Why Mac?](https://the.fmsoup.org/t/why-mac/200)). There are a ton of useful features for devs available for free, but exclusive to this OS (here are some):

- searching the graph for specific TOs
- syntax highlight customization
- 'undeclared' variables are pointed out to me
- search available in many list dialogs
- search & replace available in calculations
- probably something else I forget about...

Do you plan spending more time on a mac or is that out of your control?

---

<div class="post-metadata">

**Author:** ![Markus](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Markus](https://the.fmsoup.org/u/Markus)\
**Post date:** [February 28, 2020, 2:08pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/13 "2020-02-28T14:08:02Z")

</div>

well... here, customers define the platform

We are developing on mac's since the early nineties - but we got customers who are running very high settings for data-protection. Means, we can not use our mac's...

---

<div class="post-metadata">

**Author:** ![Cecile](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/cecile/32/98_2.png) [@Cecile](https://the.fmsoup.org/u/Cecile)\
**Post date:** [February 29, 2020, 4:20am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/14 "2020-02-29T04:20:18Z")

</div>

What I would like is to be able to save a custom sort order so that I could used the native sorts(alpha creation custom) and then revert to my cs of choice by selecting it.

---

<div class="post-metadata">

**Author:** ![FileKraft](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/filekraft/32/1183_2.png) [@FileKraft](https://the.fmsoup.org/u/FileKraft)\
**Post date:** [February 29, 2020, 8:07pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/15 "2020-02-29T20:07:19Z")

</div>

layouts by theme ..

---

<div class="post-metadata">

**Author:** ![samfmp](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@samfmp](https://the.fmsoup.org/u/samfmp)\
**Post date:** [March 12, 2020, 2:53am UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/16 "2020-03-12T02:53:08Z")

</div>

It works fine in Japanese. Thank you very much.

---

<div class="post-metadata">

**Author:** ![MonkeybreadSoftware](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/monkeybreadsoftware/32/361_2.png) [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\
**Post date:** [March 13, 2020, 3:36pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/17 "2020-03-13T15:36:51Z")

</div>

Thanks. Today I fixed it to allow sort of layouts without folders.

---

<div class="post-metadata">

**Author:** ![MonkeybreadSoftware](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/monkeybreadsoftware/32/361_2.png) [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\
**Post date:** [March 13, 2020, 3:42pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/18 "2020-03-13T15:42:03Z")

</div>

> [@Cecile](#):
>
> What I would like is to be able to save a custom sort order.

I could even allow you to put in a FileMaker expression to sort, but that is a lot of extra work.

---

<div class="post-metadata">

**Author:** ![Cecile](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/cecile/32/98_2.png) [@Cecile](https://the.fmsoup.org/u/Cecile)\
**Post date:** [March 13, 2020, 5:34pm UTC](https://the.fmsoup.org/t/sort-in-filemaker/789/19 "2020-03-13T17:34:52Z")

</div>

I realize my comment was confusing and a bit off topic; I was referring to the sort order of fields, in the db manager, not the folders
