layout with only certain records

[MacSig]

Hello guys,

I have a table with a date field (called expiration) and I need to create a new layout (columnar list) that shows only the expired records (expiration < today). I have looked around for a bit but I couldn't find anything about that.

Can someone please point me on the right direction?

Thanks and have a nice day!

[bcooney]

You can simply have a button at the top of the list view that finds all records where expiration is < today. That's a "hard-coded" find button.

Or, just have a find button that takes the user to a find layout and let them specify their criteria (one of which could be expiration < today). Then after the find is performed, it'll show the results in the list view.

[comment]

See also:

http://fmforums.com/forum/showpost.php?post/296774/

[MacSig]

Thaks Barbara for your reply,

is there a way to make it automatic? I mean without clicking the button once the layout is open the script is executed.

Have a nice day!

Sig

[David Jondreau]

How are you getting to the layout?

[MacSig]

Right now I use the layout menu on the left side. But in the future I guess I will create some kind of navigation bar.

So, for now it is fine if I can execute it when I select the layout on the menu.

Thanks

[David Jondreau]

Well, currently, Filemaker does not permit script triggers on layout load, so you'll have to use a button. If not seeing unexpired is important, I'd disable the user's direct access to the layout and require a button or a script to switch layouts, which will also run your find.

[MacSig]

Thanks for your reply buddy