Brian Dunning's FileMaker Custom Functions

PCSPX ( Variables )

Test the contents of script parameter.

  Average rating: 4.3 (30 votes) Log in to vote

Kevin Kurpe   Kevin Kurpe
Grasp Learning

Share on Facebook Share on Twitter

  Sample input:
Example 1
SP = "Create, Customer, Record"

PCSPX ("Create, Customer, Record")

Example 2
SP = "132 Select, Customer, Record"

Case (
PCSPX ("Select, Customer, Record") ; "Select" ; "Error" )
  Sample output:



  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This custom function allows you to test the script parameter for multiple values. I usually use this custom function to trigger certain portions of a script. For example, when a script is separated by IFs and ELSEIFs I can send a script parameter to the script that triggers the first portion of the script, but not the second or third. I have found it to be extremely helpful when working with scripts!

NOTE: This custom function is DEPENDENT ON MY OTHER CUSTOM FUNCTION: PCSP. To use this custom function, you must also have the other.

Kevin Kurpe



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.