hex_to_RGB.result ( hex_code )

"Hex Color Code" can be used for Button text. "RGB.result" can be used to set Field text using TextColor function.

Be the first to rate this function Log in to vote

Tony White - Show more from this author
Tony White Designs, Inc.
http://www.twdesigns.com/

Sample input:

hex_to_RGB.result ( "FFCCCC" )

Sample output:

16764108

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

// hex_to_RGB.result ( hex_code )
// twdesigns.com
// 2021-04-01_v1
// Middle ( text ; start ; numberOfCharacters )
// Position ( text ; searchString ; start ; occurrence )

// See DIGFM: Fundamental Features for Fantastic FileMaker Files (4/14/2022)
// https://www.youtube.com/watch?v=57_NVxcoxl8&t=1006s (16:46)


Let (
[ 
~the_chars = "0123456789ABCDEF" ; 
~hex_code = Filter ( Upper ( hex_code ) ; ~the_chars ) ;

~hex_code = Case ( 
Length ( ~hex_code ) = 3 ; 
Middle ( ~hex_code ; 1 ; 1 ) & Middle ( ~hex_code ; 1 ; 1 ) & 
Middle ( ~hex_code ; 2 ; 1 ) & Middle ( ~hex_code ; 2 ; 1 ) & 
Middle ( ~hex_code ; 3 ; 1 ) & Middle ( ~hex_code ; 3 ; 1 ) ; 
~hex_code
) ;

~a_char.1 = Middle ( ~hex_code ; 1 ; 1 ) ; 
~a_char.2 = Middle ( ~hex_code ; 2 ; 1 ) ; 
~a_char.3 = Middle ( ~hex_code ; 3 ; 1 ) ; 
~a_char.4 = Middle ( ~hex_code ; 4 ; 1 ) ; 
~a_char.5 = Middle ( ~hex_code ; 5 ; 1 ) ; 
~a_char.6 = Middle ( ~hex_code ; 6 ; 1 ) ; 

~Position.1 = Position ( ~the_chars ; ~a_char.1 ; 1 ; 1 ) ; 
~Position.2 = Position ( ~the_chars ; ~a_char.2 ; 1 ; 1 ) ; 
~Position.3 = Position ( ~the_chars ; ~a_char.3 ; 1 ; 1 ) ; 
~Position.4 = Position ( ~the_chars ; ~a_char.4 ; 1 ; 1 ) ; 
~Position.5 = Position ( ~the_chars ; ~a_char.5 ; 1 ; 1 ) ; 
~Position.6 = Position ( ~the_chars ; ~a_char.6 ; 1 ; 1 ) ; 

~decimal.1 = ~Position.1 - 1 ; 
~decimal.2 = ~Position.2 - 1 ; 
~decimal.3 = ~Position.3 - 1 ; 
~decimal.4 = ~Position.4 - 1 ; 
~decimal.5 = ~Position.5 - 1 ; 
~decimal.6 = ~Position.6 - 1 ; 

~R = ~decimal.1 * 16 + ~decimal.2 ; 
~G = ~decimal.3 * 16 + ~decimal.4 ; 
~B = ~decimal.5 * 16 + ~decimal.6 ; 

// ~RGB = ~R & " " & ~G & " " & ~B ; 
~RGB.result = ( 256 * 256 * ~R ) + ( 256 * ~G ) + ~B ; 

~result = Case ( 
Length ( ~hex_code ) = 6 ; ~RGB.result ; 
"ERROR" )

] ; 

~result

)

This Custom Function let you use a "Hex Color Code" for both the Button Text and the Text that you are formatting/colorizing in a Field.

See DIGFM: Fundamental Features for Fantastic FileMaker Files (4/14/2022)...
https://www.youtube.com/watch?v=57_NVxcoxl8&t=1006s (16:46)
...for details on this and more!

Comments

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

hex_to_RGB.result ( hex_code )

Comments

Support this website.

Support this website.