Brian Dunning's FileMaker Custom Functions

ButtonValue ( Number )

Useful to make it easier for passing multiple parameters to a script from a button.

  Average rating: 2.5 (207 votes) Log in to vote

Matt Petrowsky   Matt Petrowsky
ISO Productions, Inc.
http://www.filemakermagazine.com

Share on Facebook Share on Twitter

  Sample input:
ButtonValue ( 1 )
  Sample output:
New Record

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

This script is very powerful when using multiple parameters on a button.

My preferred method for passing multiple parameters to a script is to use the Let () function within a button parameter. Use a function like the following in your button's optional parameter.

Let(
[
return = "¶"
action = "AddRecord";
value = some_field_value;
value2 = another_value
];

action & return & value & return & value2

)

In your script that receives the button call, use conditional statements such as

If [ButtonValue( 1 ) = "AddRecord"] then
do script steps here
Else If [ButtonValue ( 1 ) = "UpdateRecord"] then
do step here like Set Field [SomeField; ButtonValue ( 2 )]
End If

In layouts with minimal actions you can use one script for all actions within that screen.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.