Good afternoon satcowitz,
I hope your day is going well. Would it be possible for you to provide a bit more information (e.g., your goal, perhaps a screenshot) Have a great day!
In list view only the body and header are shown, not the subsummary parts.
I hope that makes it much clearer!
Make sure you've included the sub summary parts on your layout and that the records are sorted by the appropriate field, or the sub summary parts won't display. Hope this helps.
It turned out that the problem was that FileMaker is sorting based on "current layout" rather than "current table" by default. I can manually go to Sort and change it and that fixes the problem, but I really need this to happen automatically. I have a script run on layout using the "Sort Records" command and it looks to be set up properly, but it doesn't do the trick.
Does this make sense? What am I missing?
"It turned out that the problem was that FileMaker is sorting based on current layout rather than current table by default."
"Does this make sense?"
There is no such operation as "sorting based on current layout"
You'll need to provide more details.
Good evening satcowitz,
Without seeing a sample file, it's difficult to diagnose what the precise problem might be. However, based on your discovery - that sorting manually produces the intended results - I would guess there must be an issue with the script you've implemented. If you can post your script or a sample file, I'm sure someone here will be able to steer you in the right direction. Have a great evening!
Here's the window I get when I click on the "Sort" button on the main window:
It shows "Current Layout".
Here's the same window when I change it to "Current Time".
When I click on "Sort" in this window above and go back to my layout all is good.
Here is a screen shot (below) of my script with the "Sort Records" window open. It shows "Current Table" but this is not taking effect. This script runs on layout enter.
Thanks again for any help.
In your screenshot, the left hand side is just showing you fields available that you can sort. The "Current Layout" is just showing you the fields that you have on your layout. The "Current Table" shows a table you've selected, which in this case is "time". That way, you can sort using a field which is not actually displayed on the layout.
What's going on, most likely, is that as soon as you enter the layout, records are sorted as soon as the layout loads. After that you are either finding new records or doing something else, but when that is happening, you are not issuing another sort command. The Sort is displaying what the last sort was because that's the way FileMaker works.
The screen shots are very helpful. But something else is going on, it would be good to see the whole script or your file, to see why you are losing the sort order.
As previously mentioned, there is no such thing as sort by layout or sort by table.
What matters, in the end, is which fields you have selected - the fields on the right side of the sort dialog.
The left side is only a "picker" which lets you see which fields to pick from.
You can choose from the fields on the layout; or the fields in the table the layout is based on; or fields from another, related table. But there is no such thing as sort by layout or sort by table, and changing that view makes no difference.
EDIT: I see that dtcgnet finished his reply before I finished mine! But we're saying essentially the same thing.
Thanks for everyone's help.
I just got it to work by having the script trigger to run OnRecordLoad rather than OnLayoutEnter.
But I'd love to know why this should matter.
You don't mention what you are doing that changes the found set - as mentioned by dtcgnet.
If you are adding, omitting, finding, editing etc that would potentially be a reason why the sort should be re-triggered.