Hello

 

I am wondering if there is any way in Filemaker 11 to run a script according to a calculationi (more specifically, according to a selection that the user makes).

 

Here is an outline of what I wish to achieve.

 

I have a global field, with a checkbox value list of the many reporting options available to the user.

Depending on what he or she checks then the appropriate script should be run.

 

For example --

 

If user has checked the "Cheque Requisition Report" then the "Cheque Requisition Report Script" should be run.

If user has checked the "Cheque Requisition Report" and "Current Inventory Report" then each of the two scripts will be run.

 

And so on.

 

Is this possible?

 

Set Variable [$ctr; ValueCount(yourCheckboxField)]

Loop

If[GetValue(yourCheckboxField; $ctr) = "Cheque Requisition Report"]

Perform Script["Cheque Requisition Report Script"]

Else if [[GetValue(yourCheckboxField; $ctr) = "Current Inventory Report"]

Perform Script["Current Inventory Report Script"]

#  etc

End If

Set Variable [$ctr; $ctr - 1]

Exit Loop If[$ctr = 0]

End Loop