October 7, 200817 yr 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!
October 7, 200817 yr 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.
October 7, 200817 yr Author 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
October 7, 200817 yr Author 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
October 7, 200817 yr 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.
Create an account or sign in to comment