ColourFill ( hexOrDecColour )

Place in a button bar to output a large coloured square, rectangle, or circle ( apply corner radius to make a circle ) in the specified colour.

Be the first to rate this function Log in to vote

Jason Wood - Show more from this author
Define Database
https://www.definedatabase.com

Sample input:

ColourFill ( "#FF0000" )
or
ColourFill ( RGB ( 255 ; 0 ; 0 ) )
or
ColourFill ( 16711680 )

Sample output:

[ The button bar button will be filled red. ]

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

/*
==================================================================
PURPOSE:
	Place in a button bar label to fill the area with the specified colour.
	
PARAMETERS:
	hexOrDecColour | string | hex colour starting with "#" or decimal colour.

RETURNS:
	(text) Very large solid color square

NOTES & DEPENDENCIES:
	None

CONTRIBUTORS
	JW / Jason Wood / Define Database / www.definedatabase.com

CHANGELOG
	2020–02-11 JW Created
==================================================================
*/

Let ([
  ~code = Upper ( hexOrDecColour ) ;
  ~code = If ( Left ( ~code ; 1 ) = "#" ; 
    Substitute( Middle ( ~code ; 2 ; 1 ) ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) * 16^5 +
    Substitute( Middle ( ~code ; 3 ; 1 ) ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) * 16^4 +
    Substitute( Middle ( ~code ; 4 ; 1 ) ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) * 16^3 +
    Substitute( Middle ( ~code ; 5 ; 1 ) ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) * 16^2 +
    Substitute( Middle ( ~code ; 6 ; 1 ) ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) * 16^1 +
    Substitute( Middle ( ~code ; 7 ; 1 ) ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) * 16^0 ; ~code )
];

TextSize ( TextColor ( Char ( 9608 ) ; ~code ) ; 1000 )

)

Fills an area up to about 500px tall or wide. If you need larger, you can change the TextSize value in the function from 1000 to whatever you need.

Rounded corners does not work on Windows (coloured rectangle renders on top). Works on Mac and have not tested with WebDirect & FMGo.

Comments

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

ColourFill ( hexOrDecColour )

Comments

Support this website.

Support this website.