2 Replies Latest reply on Jul 20, 2017 8:02 AM by danphillips

    Help with a script for inspection program

    danphillips

      I am helping a friend on an inspection program and would like to ask for some advice on best practice (I have limited experience with FM). Inspections will be done yearly on each location.  I have a list of about 2,000 inspections and would like to organize them into inspection groups.  The user when configuring a location for inspections would select one or more groups, or individual inspections to add to the location specific inspections.  An inspection may appear in more than one group, and should only be added once.

       

      I would like to know if the pseudo code below is this the best way to accomplish this process or is there a more efficient / easier way?

       

      I am not asking anyone to write the code but if you have some suggestions it would be very helpful.  I considered using an sql append but thought it would better to stay with a FM script.

       

      User:

      selects location

      selects add inspections by group

      group list displayed

      select group and click “Add Inspections” button

       

      pseudo code:

      set filter on InspectionGroup = selected group

       

      Loop for not eof (InspectionGroup)

        Goto layout LocationInspections

        If inspection is already in list

          loop

        endif

        Add new record

        Replace LocationInspections:_fkInspectionKey with InspectionGroup::_fkInspectionKey

        Goto layout InspectionGroup

      Loop

       

      Proposed Data Structure

       

      InspectionList

      __pkInspectionKeyID       number

      Inspection number           text

      Inspection description    text

      Inspection details             text

       

      InspectionGroup

      __pkInspGroupID              number

      GroupName                       text

      _fkInspectionKey              number

       

       

      Location

      __pkLocationKey              number

      Address                               text

      Contact                               text

       

      LocationInspections

      __pkLocInspectionID       number

      _fkInspectionKey              number

      Pass_fail                             text

      Review Notes                    text

      …..