Brian Dunning's FileMaker Custom Functions

goal ( )

how to use custom functions in auto enter calculation

  Be the first to rate this function Log in to vote

Charles Huff   Charles Huff - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
Text field contains Text and [goal: Now is the time for all good men...] and more text.
  Sample output:
Text and text between square brackets highlighted by custom functions...

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

I needed a way to remove all formatting from a text field then add back colored text between square brackets.

I combined Ray Cologon's and Doug Elam's custom functions into the above with the use of the Let function.

The auto enter calc does nothing if more than one [goal] tag is inserted in the text field (by design). When [goal] is input the text "goal" is hi lighted and also when [goal: any random text] is input whatever is between the square brackets is highlighted. note: any text without the 'goal' inserted between square brackets is ignored.

My apologies if this must be rejected because it is NOT in itself a custom function, but only an example of combining two excellent custom functions into an auto enter calculation using the Let statement.



Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 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: