color_convert_decimal ( color_decimal ; output_format )

convert FileMaker decimal color format to r, g, b, rgb or hex

Average rating: 2.7 (3 votes) Log in to vote

Thomas Siebert - Show more from this author
http://www.t-seabird.de

Sample input:

color_convert_decimal ( 16762968 ; "r" )

color_convert_decimal ( 16762968 ; "g" )

color_convert_decimal ( 16762968 ; "b" )

color_convert_decimal ( 16762968 ; "hex" )

color_convert_decimal ( 16762968 ; "rgb" )

Sample output:

255

200

88

FFC858

255¶200¶88

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

/*
color_convert_decimal ( color_decimal ; output_format )

version 4
---------------------------------------------
Thomas Siebert, 28.04.2017
info@t-seabird.de
www.t-seabird.de
---------------------------------------------

convert decimal FileMaker Color format to:

output_format = r, g, b, rgb or hex

*/

Let ([
red = Div ( color_decimal ; 65536 ) ;
green = Div ( color_decimal ; 256 ) - ( red * 256 ) ;
blue = Div ( color_decimal ; 1 ) - ( green * 256 ) - ( red * 65536 ) ;

hex_items = "0¶1¶2¶3¶4¶5¶6¶7¶8¶9¶A¶B¶C¶D¶E¶F" ;

rDiv = GetValue ( hex_items ; Div ( red ; 16 ) + 1 ) ;
gDiv = GetValue ( hex_items ; Div ( green ; 16 ) + 1 ) ;
bDiv = GetValue ( hex_items ; Div ( blue ; 16 ) + 1 ) ;

rMod = GetValue ( hex_items ; Mod ( red ; 16 ) + 1 ) ;
gMod = GetValue ( hex_items ; Mod ( green ; 16 ) + 1 ) ;
bMod = GetValue ( hex_items ; Mod ( blue ; 16 ) + 1 ) ;

hex = Rdiv & Rmod & Gdiv & Gmod & Bdiv & Bmod

];

Case ( output_format = "r" ; red ; output_format = "g" ; green ; output_format = "b" ; blue ; output_format = "rgb" ; red & ¶ & green & ¶ & blue ; output_format = "hex" ; hex ; "" ) 

)

convert decimal FileMaker Color format to:

output_format = r, g, b, rgb or hex

Comments

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

color_convert_decimal ( color_decimal ; output_format )

Comments

Support this website.

Support this website.