AnsweredAssumed Answered

Replacement for EventScript plugin in FM Go

Question asked by PolyPaparas on Feb 12, 2011
Latest reply on Feb 14, 2011 by philmodjunk

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

Outcomes