3 Replies Latest reply on Feb 14, 2011 4:56 PM by philmodjunk

    Replacement for EventScript plugin in FM Go

    PolyPaparas

      Title

      Replacement for EventScript plugin in FM Go

      Post

      I built a database for my patients a while ago on FM Pro 7.

      One of the fields on the main table was "Referred by" which recorded whether the patient was referred by a doctor, another patient or someone else (i.e. the milkman...).

      In order to achieve this the best way I found at the time was to use a free plugin called eventscript and fill the "referred by" field using a calculation

      If(Referred by type="Doctor";
           S4HU_EventScript(Get(FileName); "Referred by doctor";"");
           If(Referred by type="Other patient";
                S4HU_EventScript(Get(FileName);"Referred by patient";"");
                If(Referred by type="Other";
                S4HU_EventScript(Get(FileName);"Referred by other";"");
                "")))



      The three scripts used where:

      Referred by doctor:

      Freeze Window
      Go to Layout ["Record 1 - Personal Data (Doctors) (Patients)]
      Go to Field [Patients::Referred by]

      Referred by patient:

      Freeze Window
      Go to Layout ["Record 1 - Personal Data (Patients)" (Patients)]
      Go to Field [Patients::Referred by]

      Referred by other:

      Freeze Window
      Go to Layout ["Record 1 - Personal Data (Other)" (Patients)]
      Go to Field [Patients::Referred by]

      So, basically, I created another field called "referred by type" and triggered a change in layouts depending on the values of this field, so as to be able to draw data from three different tables to the "referred by" field. If the selection on the first field was "doctor" then the relevant layout was used, where values from the "doctors" table where used and so on.

      I am now trying to port my database to the ipad using FM Pro 11. FM Go does not support plugins, so how can I get the same functionality using the script triggers on FM Pro 11?

      Many thanks for any help offered