AnsweredAssumed Answered

When in List view clicking on any field name deletes all the sort fields other than the field name...

Question asked by JeffreyVento on Oct 26, 2010
Latest reply on Oct 26, 2010 by JeffreyVento

Like • Show 0 Likes0
Comment • 4

Summary

When in List view clicking on any field name deletes all the sort fields other than the field name clicked on. This drives me crazy and I want to turn it off

Product

FileMaker Pro

Version

11.2

Operating system version

mac snow leopard

Description of the issue

When in List view clicking on any field name deletes all the sort fields other than the field name clicked on. This drives me crazy and I want to turn it off

Steps to reproduce the problem

1 open a layout in list view

2 click any field name in the header

3 go to sort the records.

4. All sort fields have Been removed except the field clicked on.

Expected result

I do not want my sort fields removed.

That makes me have to add them in again which annoys me

davidhead Oct 26, 2010 2:39 PM

Correct Answer

You can turn the header sort behaviour off for any layout.

Go to Layout Mode.
Choose Layouts >Layout Setup…
Go to the Views tab.
Click Properties for Table view.
Turn off 'Sort data when selecting column'.

Admittedly it is pretty well hidden but it is there ;)

TS_Oz, FileMaker Inc.

See the reply in context

No one else had this question

Outcomes

philmodjunk Oct 26, 2010 1:42 PM

Are you sure you aren't in table view rather than list view?

Clicking a column header in table view sets up a single level sort. (A sort based on the values in one field).

To get a sort based on more than one field, you must specify that by selecting sort from the Records menu or you would have to set up a script for controlling the sort order.

Actions

JeffreyVento Oct 26, 2010 2:22 PM

Phil - I may be in table view. That's how I view all my reports. It's nice cause I can drag columns to reorder or resize them. Is there a way to turn off single level sort? I always click a header by mistake and it removes my sort fields. It KILLS me - thanks - jeff

Actions

davidhead Oct 26, 2010 2:39 PM

You can turn the header sort behaviour off for any layout.

Go to Layout Mode.
Choose Layouts >Layout Setup…
Go to the Views tab.
Click Properties for Table view.
Turn off 'Sort data when selecting column'.

Admittedly it is pretty well hidden but it is there ;)

TS_Oz, FileMaker Inc.

Actions

JeffreyVento Oct 26, 2010 2:49 PM

TS_Oz

YOU are a genius my friend. Tell your Boss I said he needs to buy you a beer. I will reimburse him via pay pal.

I wish I asked this question a long time ago. Would not have had to kick myself so much!

Peace brother!! - jeff

Actions

4 Replies

philmodjunk Oct 26, 2010 1:42 PM
Mark Correct
Correct Answer
Are you sure you aren't in table view rather than list view?

Clicking a column header in table view sets up a single level sort. (A sort based on the values in one field).

To get a sort based on more than one field, you must specify that by selecting sort from the Records menu or you would have to set up a script for controlling the sort order.
Like • Show 0 Likes0
Actions
JeffreyVento Oct 26, 2010 2:22 PM
Mark Correct
Correct Answer
Phil - I may be in table view. That's how I view all my reports. It's nice cause I can drag columns to reorder or resize them. Is there a way to turn off single level sort? I always click a header by mistake and it removes my sort fields. It KILLS me - thanks - jeff
Like • Show 0 Likes0
Actions
davidhead Oct 26, 2010 2:39 PM
Unmark Correct
Correct Answer
You can turn the header sort behaviour off for any layout.
1. Go to Layout Mode.
2. Choose Layouts >Layout Setup…
3. Go to the Views tab.
4. Click Properties for Table view.
5. Turn off 'Sort data when selecting column'.
Admittedly it is pretty well hidden but it is there ;)

TS_Oz, FileMaker Inc.
Like • Show 0 Likes0
Actions
JeffreyVento Oct 26, 2010 2:49 PM
Mark Correct
Correct Answer
TS_Oz

YOU are a genius my friend. Tell your Boss I said he needs to buy you a beer. I will reimburse him via pay pal.

I wish I asked this question a long time ago. Would not have had to kick myself so much!

Peace brother!! - jeff
Like • Show 0 Likes0
Actions

When in List view clicking on any field name deletes all the sort fields other than the field name...

Summary

Product

Version

Operating system version

Description of the issue

Steps to reproduce the problem

Expected result

Outcomes

Related Content

Recommended Content