ToggleFlag_cf ( myfield ; myVL ; pos ; neg )

Toggles between All and Clear for setting checkbox sets

Average rating: 4.6 (34 votes) Log in to vote

Steve Gerow - Show more from this author
Abrazos Data Consulting
http://www.abrazosdata.com

Sample input:

ToggleFlag_cf ( Colors ; "RedGreenBlue" ; "All" ; "Clear" )

Sample output:

Red & Green = "All"
Red, Green & Blue = "Clear"

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

//ToggleFlag_cf ( myfield ; myVL ; pos ; neg ) = 

Let ( myfieldcontents = GetField ( GetFieldName ( myfield )) ;
Let ( myitems = ValueListItems ( Get (FileName ) ; myvl ) ;
Let ( myVLcount = ValueCount ( myitems ) ;
Let ( myfieldValCount = ValueCount ( myfield  ) ;
Case ( myfieldValcount = myVLcount ; neg ; pos )
))))

Supplies button text: "All" if none or some checkboxes checked and user wants to check them all; "Clear" if all are checked and user wishes to clear them.

Compares valuecount of value list itself to number of checked values in the field itself.

Comments

		Oreste Schiavone, New York Jul 1, 2009
Hi, I am not sure how this used.

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

ToggleFlag_cf ( myfield ; myVL ; pos ; neg )

Comments

Support this website.

Support this website.