2 Replies Latest reply on Nov 22, 2011 4:12 AM by dsunter

    Layout based on Selection Formula?

    dsunter

      Title

      Layout based on Selection Formula?

      Post

      Hi All

       

      Is there a way to crease a Layout and then have the data which is shown based on a Formula?

       

      For example if you have a database with employee details in and you want to create a view which only shows you current employees. Can you create the layout to use all data which doesn't have a termination date?

       

      Hope that makes sense.

       

      Thanks

       

      Dave :)

        • 1. Re: Layout based on Selection Formula?
          philmodjunk

          With the OnLayoutEnter script trigger, you can perform a find that either finds all current employee records or omits all terminated employees from the current found set. There are ways to further fine tune this layout's interface with custom menus if you have FileMaker Advanced.

          You can also use a portal with a portal filter to display all records from this table that do not have a termination date.

          It's also possible to use a record level access expression in Manage | Security to limit access on this layout to just current employees.

          • 2. Re: Layout based on Selection Formula?
            dsunter

            Hi

             

            Thanks for your reply that worked a treat :)

             

            Dave