Brian Dunning's FileMaker Custom Functions

Search Results

11 functions found:

1.   buttonbar.getActiveSegmentContent ( buttonBarObjectName ; optional_listButtonBarSegments )
  Average rating: 4.8
Cristos Lianides-Chin, Codence
Returns the text label (i.e., `content`) of the Button Bar Segment that is active. Useful for determining which button a user clicked.
 
2.   buttonbar.getActiveSegmentName ( buttonBarObjectName ; optional_listButtonBarSegments )
  Average rating: 4.5
Cristos Lianides-Chin, Codence
Returns the layout object name of the Button Bar Segment that is active. Useful for determining which button a user clicked.
 
3.   CountWorkingDays ( DateStart; DateEnd )
  Average rating: 4.5
Cristos Lianides-Chin, Codence
Returns the number of working days between two dates.
 
4.   GetNthCdataContents ( xmlToSearch ; n )
  Average rating: 4.6
Cristos Lianides-Chin, Codence
Gets the contents of the nth CDATA instance within an XML blob.
 
5.   GetQueryStringValue ( keyName ; sourceUrl )
  Average rating: 4.4
Cristos Lianides-Chin, Codence
Given a full URL and name of a key, returns the given key's value out of the entire URL.
 
6.   GetReduxList ( text ; isBreakOnWords ; minSearchChars ; maxSearchChars )
  Average rating: 4.4
Cristos Lianides-Chin, Codence
Explodes a piece of text into its constituent strings, for use in a partial-string match portal search feature.
 
7.   json.unformat ( jsonEntity )
  Average rating: 0.0
Cristos Lianides-Chin, Codence
Undoes `JSONFormat()` function by re-interpreting the JSON entity from the root node. Useful for building JSONL (https://jsonlines.org) formatted docs.
 
8.   sql.getField ( fullyQualifiedFieldObject )
  Average rating: 1.0
Cristos Lianides-Chin, Codence
Returns the plain text FIELD NAME in a format suitable for an SQL query
 
9.   sql.getTable ( fullyQualifiedFieldObject )
  Average rating: 1.0
Cristos Lianides-Chin, Codence
Returns the plain text TABLE NAME in a format suitable for an SQL query
 
10.   sql.whereInList.asList ( fqFieldToReturn ; fqFieldToMatch ; listOfValuesToMatch )
  Average rating: 4.0
Cristos Lianides-Chin, Codence
Syntactic sugar for performing a basic SQL query of the structure `SELECT <> FROM <> WHERE <> IN ( listOfvaluesToMatch>> )`.
 
11.   value.toJsonKeyName ( value )
  Average rating: 0.0
Cristos Lianides-Chin, Codence
Given a value, makes it safe for use as a JSON key name by removing invalid characters, and spaces, and replacing them with underscores. Also, if the key name is a reserved word, it will be prefixed with an underscore.
 

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: