2 Replies Latest reply on Apr 17, 2015 1:29 PM by HeatherFagans

    Conditional Layout?

    HeatherFagans

      Title

      Conditional Layout?

      Post

      I'm trying to create a database with three layouts - layout 1. data entry, layout 2. form which uses 95% of all the fields in the data entry, and layout 3. that will only show fields that have a certain value.

      For instance, I'm inspecting a building and entering data in the building record data entry layout, and those fields appear in layout 2, a format that is mandated by the state; if the ceilings and floors need to be repaired (check box field), but the roof does not, the third layout would be generated with only the ceiling and floor fields (quantity, cost), not the roof fields, or any of the other myriad building systems fields.

      Picture attached - layout3 is an excel spreadsheet that I would like to recreate in FMP, utilizing the appropriate fields from the data entry layout.

      layout3.JPG

        • 1. Re: Conditional Layout?
          philmodjunk

          if the ceilings and floors need to be repaired (check box field), but the roof does not, the third layout would be generated with only the ceiling and floor fields (quantity, cost), not the roof fields, or any of the other myriad building systems fields.

          Where you have fields in the above quoted statement, think records in a related table. This does not require you to use a different format on your report and data entry layouts, but does require a significant redesign of your underlying data model. By having a related record for each "check box", records where you have recorded such a check box will exist and records where you have not made such a selection simply won't exist and you can set up a report on the resulting found set of "problem area" records.

          • 2. Re: Conditional Layout?
            HeatherFagans

            I was trying to get around having 200+ records associated with each building and have the basic file structure be database per school district (or client), record per building, associated fields per question/category on the state form (state form is one per building).  the thinking is that this makes data entry easier in the field, rather than have to create new records for each question/category of building system. Picture shows a page of the state form.  Either the building is the data base and each question is a record with fields, or the client is the data base and the building is a record with fields?