FormatLike ( text ; template )

Applies the formatting of 'template' to 'text'

Average rating: 3.7 (47 votes) Log in to vote

Peter Vinogradov - Show more from this author

Sample input:

FormatLike ( "Title"; Templates::Heading1)

Sample output:

Title (using the same formatting as the text in the field Templates::Heading1)

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

// FormatLike ( text ; template )
// Applies the formatting of template to text
// NOTE - only uses the first character of template to decide on formatting.

Let ( [

sample = Left (template; 1 );
UFText = Evaluate ( Quote (text) ) // unformat the text - thanks Tim Cimbura

]

;

Replace ( sample ; 1 ; 1 ; UFtext )

)

For applying a single format (color, style, etc.) to a field (either with a calc or an auto-enter replacement calc), regardless of how the user formats the text.

Idea is to define the overriding style in another field using FileMaker controls, rather than hard-coding the style into your calc.

Comments

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

FormatLike ( text ; template )

Comments

Support this website.

Support this website.