png1x1 ( hex_string )

Used to set a container field to a 1x1 .png
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:
Case (
Status = "Rec. Partial" ; png1x1 ( "fc9" ) ;
Status = "Rec. All" ; png1x1 ( "ccf" ) ;
Status = "Ordered" ; png1x1 ( "fcc" ) ;
Status = "On Hold" ; png1x1 ( "ff9" ) ;
Status = "Planned" ; png1x1 ( "cff" ) ;
""
)
Sample output:
a 1x1 .png
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
// http://www.twdesigns.com/resources/documentation/f/filemaker-7-to-11-default-color-palette/
// png1x1 ( hex_string ) 
// 2021-02-28_v2
// use case: set a container field based on the value of another field, for example Status & Status_Color_R, Priority & Priority_Color_R, etc.
// might be used instead of a Conditional Formating Fill to provide a DRYer implementation that is more flexible
// Inspired by CF "colors_for_containers ( color_name ; opacity )" ; https://www.briandunning.com/cf/1828

Let (
[ 
~png1x1_base64enconded = 
Case ( 
hex_string = "" ; "" ; 
hex_string = "FFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAC0lEQVQYV2P4DwQACfsD/SvVCEUAAAAASUVORK5CYII=" ; 
hex_string = "888" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2Po6Oj4DwAFzAKYHYYI3AAAAABJRU5ErkJggg==" ; 
hex_string = "999" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYOXPmfwAGZQLLkORThAAAAABJRU5ErkJggg==" ; 
hex_string = "AAA" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NYtWrVfwAG/gL+NbCogwAAAABJRU5ErkJggg==" ; 
hex_string = "BBB" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2PYvXv3fwAHlwMxbSRjMAAAAABJRU5ErkJggg==" ; 
hex_string = "CCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4c+bMfwAIMANkq3cY2wAAAABJRU5ErkJggg==" ; 
hex_string = "DDD" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2O4e/fufwAIyQOXgDhBOwAAAABJRU5ErkJggg==" ; 
hex_string = "EEE" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2N49+7dfwAJYgPK+tLRowAAAABJRU5ErkJggg==" ; 
hex_string = "000" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYGD4DwABBAEAcCBlCwAAAABJRU5ErkJggg==" ; 
hex_string = "111" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MQFBT8DwABnQEzumErWgAAAABJRU5ErkJggg==" ; 
hex_string = "222" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NQUlL6DwACNgFm2egQMwAAAABJRU5ErkJggg==" ; 
hex_string = "333" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwNjb+DwACzwGZPnnpawAAAABJRU5ErkJggg==" ; 
hex_string = "444" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NwcXH5DwADaAHMg0X8hAAAAABJRU5ErkJggg==" ; 
hex_string = "555" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MIDQ39DwAEAQH/Gv0A5QAAAABJRU5ErkJggg==" ; 
hex_string = "666" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIS0v7DwAEmgIymlM5RwAAAABJRU5ErkJggg==" ; 
hex_string = "777" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MoLy//DwAFMwJlcc+iEAAAAABJRU5ErkJggg==" ; 
hex_string = "400" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NwYWD4DwACFAFEP9d5twAAAABJRU5ErkJggg==" ; 
hex_string = "700" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MoZ2D4DwAC4AF36xN8mwAAAABJRU5ErkJggg==" ; 
hex_string = "A00" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NYxcDwHwADrAGqdCJFsQAAAABJRU5ErkJggg==" ; 
hex_string = "D00" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2O4y8DwHwAEeAHdUjTSmAAAAABJRU5ErkJggg==" ; 
hex_string = "F33" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4b2z8HwAF/wJl/dWccgAAAABJRU5ErkJggg==" ; 
hex_string = "F66" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n5b2HwAG/gLLg+FDEgAAAABJRU5ErkJggg==" ; 
hex_string = "F99" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4P3PmfwAH/QMxPdaKEAAAAABJRU5ErkJggg==" ; 
hex_string = "FCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f+bMfwAI/AOXif0p7AAAAABJRU5ErkJggg==" ; 
hex_string = "630" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIM2b4DwADNQGZp2k+1wAAAABJRU5ErkJggg==" ; 
hex_string = "930" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYaczwHwAEAQHMsQQdQAAAAABJRU5ErkJggg==" ; 
hex_string = "C30" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4Y8zwHwAEzQH/qheTPQAAAABJRU5ErkJggg==" ; 
hex_string = "F30" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4b8zwHwAFmQIyKW1iTwAAAABJRU5ErkJggg==" ; 
hex_string = "F60" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n8bwHwAGMgJlHMxkJQAAAABJRU5ErkJggg==" ; 
hex_string = "F63" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n2b8HwAGmAKYZsK/ygAAAABJRU5ErkJggg==" ; 
hex_string = "F96" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4PzPtPwAHlwL+TpS2/QAAAABJRU5ErkJggg==" ; 
hex_string = "FC9" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f2bmfwAIlgNk0P8ntAAAAABJRU5ErkJggg==" ; 
hex_string = "960" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYmcbwHwAEmgH/+KT0FQAAAABJRU5ErkJggg==" ; 
hex_string = "C90" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4M5PhPwAF/wJlNuLebwAAAABJRU5ErkJggg==" ; 
hex_string = "FC0" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f4bhPwAHZALLKIEO5wAAAABJRU5ErkJggg==" ; 
hex_string = "FF0" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/5/hPwAH/QL+iVFj9AAAAABJRU5ErkJggg==" ; 
hex_string = "FF3" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/9/4PwAIYwMx76QTyAAAAABJRU5ErkJggg==" ; 
hex_string = "FF6" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/z/tPwAIyQNklnz4DQAAAABJRU5ErkJggg==" ; 
hex_string = "FF9" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/3/mfwAJLwOXg9kMpwAAAABJRU5ErkJggg==" ; 
hex_string = "FFC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4///MfwAJlQPKZjy5IAAAAABJRU5ErkJggg==" ; 
hex_string = "020" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgUGL4DwABagEiix0FagAAAABJRU5ErkJggg==" ; 
hex_string = "040" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgcGH4DwAB0AFE63s/gQAAAABJRU5ErkJggg==" ; 
hex_string = "060" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgSGP4DwACNgFmVg0YLgAAAABJRU5ErkJggg==" ; 
hex_string = "080" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2Ng6GD4DwACnAGIr3uK6AAAAABJRU5ErkJggg==" ; 
hex_string = "0E0" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgeMfwHwADzgHuhgozaQAAAABJRU5ErkJggg==" ; 
hex_string = "6F6" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NI+5/2HwAGZQLL4pFUuQAAAABJRU5ErkJggg==" ; 
hex_string = "9F9" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OY+X/mfwAHlwMxNQOvGwAAAABJRU5ErkJggg==" ; 
hex_string = "CFC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M48//MfwAIyQOXMHfZbQAAAABJRU5ErkJggg==" ; 
hex_string = "033" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgMDb+DwACAwFmQcCWAAAAAABJRU5ErkJggg==" ; 
hex_string = "366" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwTkv7DwADzgH/DcDqfwAAAABJRU5ErkJggg==" ; 
hex_string = "066" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgSEv7DwADAgHM4KsbjwAAAABJRU5ErkJggg==" ; 
hex_string = "099" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgmDnzPwAEAQIyw/WPqQAAAABJRU5ErkJggg==" ; 
hex_string = "0CC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgOHPmPwAFAAKYJZcnrQAAAABJRU5ErkJggg==" ; 
hex_string = "6CC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIO3PmPwAGmAL+BfTahwAAAABJRU5ErkJggg==" ; 
hex_string = "6FC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NI+3/mPwAHMQMxlkkjagAAAABJRU5ErkJggg==" ; 
hex_string = "9FC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OY+f/MfwAH/QNkU7SnngAAAABJRU5ErkJggg==" ; 
hex_string = "039" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgMJ75HwACzwHMUK9z/gAAAABJRU5ErkJggg==" ; 
hex_string = "03F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgMP7/HwADmwIyQbWLrgAAAABJRU5ErkJggg==" ; 
hex_string = "06F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgSPv/HwAENAJl+NICtAAAAABJRU5ErkJggg==" ; 
hex_string = "09F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgmPn/PwAEzQKY0EWHOAAAAABJRU5ErkJggg==" ; 
hex_string = "0CF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgOPP/PwAFZgLLOtLMtgAAAABJRU5ErkJggg==" ; 
hex_string = "6FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NI+///PwAHlwNk8cD7BAAAAABJRU5ErkJggg==" ; 
hex_string = "9FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OY+f//fwAIYwOXQWU+WwAAAABJRU5ErkJggg==" ; 
hex_string = "CFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M48///fwAJLwPKqfWAnAAAAABJRU5ErkJggg==" ; 
hex_string = "005" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYAj9DwABrgFV7viMbwAAAABJRU5ErkJggg==" ; 
hex_string = "007" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYCj/DwAB8gF3MNdpIAAAAABJRU5ErkJggg==" ; 
hex_string = "00A" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYFj1HwACWAGqBRl8VAAAAABJRU5ErkJggg==" ; 
hex_string = "00D" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYLj7HwACvgHdtfhq5QAAAABJRU5ErkJggg==" ; 
hex_string = "36F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwTvv/HwAFAAKYag5Z/gAAAABJRU5ErkJggg==" ; 
hex_string = "39F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2Mwnvn/PwAFmQLLOyCZvQAAAABJRU5ErkJggg==" ; 
hex_string = "6CF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIO/P/PwAG/gMx+hPfsgAAAABJRU5ErkJggg==" ; 
hex_string = "9CF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYeeb/fwAHygNk7rrBCwAAAABJRU5ErkJggg==" ; 
hex_string = "306" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwZkj7DwACnAGZyTOU8QAAAABJRU5ErkJggg==" ; 
hex_string = "609" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIY5j5HwADzgH/hzsoqgAAAABJRU5ErkJggg==" ; 
hex_string = "639" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIM575HwAEZwIytoDTwwAAAABJRU5ErkJggg==" ; 
hex_string = "90C" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYyXDmPwAFAAJl6gK1WwAAAABJRU5ErkJggg==" ; 
hex_string = "93F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYafz/PwAF/wLLd4LEPQAAAABJRU5ErkJggg==" ; 
hex_string = "96F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYmfb/PwAGmAL+eSqtBwAAAABJRU5ErkJggg==" ; 
hex_string = "99F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYOfP/fwAHMQMxpuPECQAAAABJRU5ErkJggg==" ; 
hex_string = "CCF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4c+b/fwAIlgOXy70lYAAAAABJRU5ErkJggg==" ; 
hex_string = "606" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIY0j7DwADaAHMd0oNwAAAAABJRU5ErkJggg==" ; 
hex_string = "906" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYyZD2HwAENAH/qYkKcgAAAABJRU5ErkJggg==" ; 
hex_string = "C09" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4wzDzPwAFZgJlhlXzAgAAAABJRU5ErkJggg==" ; 
hex_string = "F09" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4zzDzPwAGMgKYotKplAAAAABJRU5ErkJggg==" ; 
hex_string = "F3C" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4b3zmPwAHMQL+E4lS4gAAAABJRU5ErkJggg==" ; 
hex_string = "F6F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n/b/PwAIMANk5aLgDQAAAABJRU5ErkJggg==" ; 
hex_string = "F9F" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4P/P/fwAIyQOX2B+NEAAAAABJRU5ErkJggg==" ; 
hex_string = "FCF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f+b/fwAJYgPKSp1J9QAAAABJRU5ErkJggg==" ; 

hex_string = "FFFFFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAC0lEQVQYV2P4DwQACfsD/SvVCEUAAAAASUVORK5CYII=" ; 
hex_string = "888888" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2Po6Oj4DwAFzAKYHYYI3AAAAABJRU5ErkJggg==" ; 
hex_string = "999999" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYOXPmfwAGZQLLkORThAAAAABJRU5ErkJggg==" ; 
hex_string = "AAAAAA" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NYtWrVfwAG/gL+NbCogwAAAABJRU5ErkJggg==" ; 
hex_string = "BBBBBB" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2PYvXv3fwAHlwMxbSRjMAAAAABJRU5ErkJggg==" ; 
hex_string = "CCCCCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4c+bMfwAIMANkq3cY2wAAAABJRU5ErkJggg==" ; 
hex_string = "DDDDDD" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2O4e/fufwAIyQOXgDhBOwAAAABJRU5ErkJggg==" ; 
hex_string = "EEEEEE" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2N49+7dfwAJYgPK+tLRowAAAABJRU5ErkJggg==" ; 
hex_string = "000000" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYGD4DwABBAEAcCBlCwAAAABJRU5ErkJggg==" ; 
hex_string = "111111" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MQFBT8DwABnQEzumErWgAAAABJRU5ErkJggg==" ; 
hex_string = "222222" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NQUlL6DwACNgFm2egQMwAAAABJRU5ErkJggg==" ; 
hex_string = "333333" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwNjb+DwACzwGZPnnpawAAAABJRU5ErkJggg==" ; 
hex_string = "444444" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NwcXH5DwADaAHMg0X8hAAAAABJRU5ErkJggg==" ; 
hex_string = "555555" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MIDQ39DwAEAQH/Gv0A5QAAAABJRU5ErkJggg==" ; 
hex_string = "666666" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIS0v7DwAEmgIymlM5RwAAAABJRU5ErkJggg==" ; 
hex_string = "777777" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MoLy//DwAFMwJlcc+iEAAAAABJRU5ErkJggg==" ; 
hex_string = "440000" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NwYWD4DwACFAFEP9d5twAAAABJRU5ErkJggg==" ; 
hex_string = "770000" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MoZ2D4DwAC4AF36xN8mwAAAABJRU5ErkJggg==" ; 
hex_string = "AA0000" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NYxcDwHwADrAGqdCJFsQAAAABJRU5ErkJggg==" ; 
hex_string = "DD0000" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2O4y8DwHwAEeAHdUjTSmAAAAABJRU5ErkJggg==" ; 
hex_string = "FF3333" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4b2z8HwAF/wJl/dWccgAAAABJRU5ErkJggg==" ; 
hex_string = "FF6666" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n5b2HwAG/gLLg+FDEgAAAABJRU5ErkJggg==" ; 
hex_string = "FF9999" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4P3PmfwAH/QMxPdaKEAAAAABJRU5ErkJggg==" ; 
hex_string = "FFCCCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f+bMfwAI/AOXif0p7AAAAABJRU5ErkJggg==" ; 
hex_string = "663300" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIM2b4DwADNQGZp2k+1wAAAABJRU5ErkJggg==" ; 
hex_string = "993300" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYaczwHwAEAQHMsQQdQAAAAABJRU5ErkJggg==" ; 
hex_string = "CC3300" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4Y8zwHwAEzQH/qheTPQAAAABJRU5ErkJggg==" ; 
hex_string = "FF3300" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4b8zwHwAFmQIyKW1iTwAAAABJRU5ErkJggg==" ; 
hex_string = "FF6600" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n8bwHwAGMgJlHMxkJQAAAABJRU5ErkJggg==" ; 
hex_string = "FF6633" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n2b8HwAGmAKYZsK/ygAAAABJRU5ErkJggg==" ; 
hex_string = "FF9966" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4PzPtPwAHlwL+TpS2/QAAAABJRU5ErkJggg==" ; 
hex_string = "FFCC99" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f2bmfwAIlgNk0P8ntAAAAABJRU5ErkJggg==" ; 
hex_string = "996600" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYmcbwHwAEmgH/+KT0FQAAAABJRU5ErkJggg==" ; 
hex_string = "CC9900" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4M5PhPwAF/wJlNuLebwAAAABJRU5ErkJggg==" ; 
hex_string = "FFCC00" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f4bhPwAHZALLKIEO5wAAAABJRU5ErkJggg==" ; 
hex_string = "FFFF00" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/5/hPwAH/QL+iVFj9AAAAABJRU5ErkJggg==" ; 
hex_string = "FFFF33" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/9/4PwAIYwMx76QTyAAAAABJRU5ErkJggg==" ; 
hex_string = "FFFF66" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/z/tPwAIyQNklnz4DQAAAABJRU5ErkJggg==" ; 
hex_string = "FFFF99" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4/3/mfwAJLwOXg9kMpwAAAABJRU5ErkJggg==" ; 
hex_string = "FFFFCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4///MfwAJlQPKZjy5IAAAAABJRU5ErkJggg==" ; 
hex_string = "002200" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgUGL4DwABagEiix0FagAAAABJRU5ErkJggg==" ; 
hex_string = "004400" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgcGH4DwAB0AFE63s/gQAAAABJRU5ErkJggg==" ; 
hex_string = "006600" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgSGP4DwACNgFmVg0YLgAAAABJRU5ErkJggg==" ; 
hex_string = "008800" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2Ng6GD4DwACnAGIr3uK6AAAAABJRU5ErkJggg==" ; 
hex_string = "00EE00" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgeMfwHwADzgHuhgozaQAAAABJRU5ErkJggg==" ; 
hex_string = "66FF66" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NI+5/2HwAGZQLL4pFUuQAAAABJRU5ErkJggg==" ; 
hex_string = "99FF99" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OY+X/mfwAHlwMxNQOvGwAAAABJRU5ErkJggg==" ; 
hex_string = "CCFFCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M48//MfwAIyQOXMHfZbQAAAABJRU5ErkJggg==" ; 
hex_string = "003333" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgMDb+DwACAwFmQcCWAAAAAABJRU5ErkJggg==" ; 
hex_string = "336666" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwTkv7DwADzgH/DcDqfwAAAABJRU5ErkJggg==" ; 
hex_string = "006666" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgSEv7DwADAgHM4KsbjwAAAABJRU5ErkJggg==" ; 
hex_string = "009999" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgmDnzPwAEAQIyw/WPqQAAAABJRU5ErkJggg==" ; 
hex_string = "00CCCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgOHPmPwAFAAKYJZcnrQAAAABJRU5ErkJggg==" ; 
hex_string = "66CCCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIO3PmPwAGmAL+BfTahwAAAABJRU5ErkJggg==" ; 
hex_string = "66FFCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NI+3/mPwAHMQMxlkkjagAAAABJRU5ErkJggg==" ; 
hex_string = "99FFCC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OY+f/MfwAH/QNkU7SnngAAAABJRU5ErkJggg==" ; 
hex_string = "003399" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgMJ75HwACzwHMUK9z/gAAAABJRU5ErkJggg==" ; 
hex_string = "0033FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgMP7/HwADmwIyQbWLrgAAAABJRU5ErkJggg==" ; 
hex_string = "0066FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgSPv/HwAENAJl+NICtAAAAABJRU5ErkJggg==" ; 
hex_string = "0099FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgmPn/PwAEzQKY0EWHOAAAAABJRU5ErkJggg==" ; 
hex_string = "00CCFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgOPP/PwAFZgLLOtLMtgAAAABJRU5ErkJggg==" ; 
hex_string = "66FFFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NI+///PwAHlwNk8cD7BAAAAABJRU5ErkJggg==" ; 
hex_string = "99FFFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OY+f//fwAIYwOXQWU+WwAAAABJRU5ErkJggg==" ; 
hex_string = "CCFFFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M48///fwAJLwPKqfWAnAAAAABJRU5ErkJggg==" ; 
hex_string = "000055" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYAj9DwABrgFV7viMbwAAAABJRU5ErkJggg==" ; 
hex_string = "000077" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYCj/DwAB8gF3MNdpIAAAAABJRU5ErkJggg==" ; 
hex_string = "0000AA" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYFj1HwACWAGqBRl8VAAAAABJRU5ErkJggg==" ; 
hex_string = "0000DD" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NgYLj7HwACvgHdtfhq5QAAAABJRU5ErkJggg==" ; 
hex_string = "3366FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwTvv/HwAFAAKYag5Z/gAAAABJRU5ErkJggg==" ; 
hex_string = "3399FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2Mwnvn/PwAFmQLLOyCZvQAAAABJRU5ErkJggg==" ; 
hex_string = "66CCFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIO/P/PwAG/gMx+hPfsgAAAABJRU5ErkJggg==" ; 
hex_string = "99CCFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYeeb/fwAHygNk7rrBCwAAAABJRU5ErkJggg==" ; 
hex_string = "330066" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2MwZkj7DwACnAGZyTOU8QAAAABJRU5ErkJggg==" ; 
hex_string = "660099" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIY5j5HwADzgH/hzsoqgAAAABJRU5ErkJggg==" ; 
hex_string = "663399" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIM575HwAEZwIytoDTwwAAAABJRU5ErkJggg==" ; 
hex_string = "9900CC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYyXDmPwAFAAJl6gK1WwAAAABJRU5ErkJggg==" ; 
hex_string = "9933FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYafz/PwAF/wLLd4LEPQAAAABJRU5ErkJggg==" ; 
hex_string = "9966FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYmfb/PwAGmAL+eSqtBwAAAABJRU5ErkJggg==" ; 
hex_string = "9999FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYOfP/fwAHMQMxpuPECQAAAABJRU5ErkJggg==" ; 
hex_string = "CCCCFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4c+b/fwAIlgOXy70lYAAAAABJRU5ErkJggg==" ; 
hex_string = "660066" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2NIY0j7DwADaAHMd0oNwAAAAABJRU5ErkJggg==" ; 
hex_string = "990066" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2OYyZD2HwAENAH/qYkKcgAAAABJRU5ErkJggg==" ; 
hex_string = "CC0099" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2M4wzDzPwAFZgJlhlXzAgAAAABJRU5ErkJggg==" ; 
hex_string = "FF0099" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4zzDzPwAGMgKYotKplAAAAABJRU5ErkJggg==" ; 
hex_string = "FF33CC" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4b3zmPwAHMQL+E4lS4gAAAABJRU5ErkJggg==" ; 
hex_string = "FF66FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4n/b/PwAIMANk5aLgDQAAAABJRU5ErkJggg==" ; 
hex_string = "FF99FF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4P/P/fwAIyQOX2B+NEAAAAABJRU5ErkJggg==" ; 
hex_string = "FFCCFF" ; "iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAADUlEQVQYV2P4f+b/fwAJYgPKSp1J9QAAAABJRU5ErkJggg==" ; 

""
) ; 

~result = Base64Decode ( ~png1x1_base64enconded ; hex_string & ".png" )
] ; 

~result

)
Used to set a container field to a 1x1 .png

Here are some colors that we like. Also easy to work with!
http://www.twdesigns.com/resources/documentation/f/filemaker-7-to-11-default-color-palette/

use case: set a container field based on the value of another field, for example...
Status & Status_Color_R, Priority & Priority_Color_R, etc.

Might be used instead of a Conditional Format Fill to provide a DRYer implementation that is more flexible.

Inspired by CF "colors_for_containers ( color_name ; opacity )" ; https://www.briandunning.com/cf/1828
Comments

		Tim Anderson, Tim Anderson Group Feb 24, 2021
Thanks Tony, useful. If I can I would like to suggest that if an empty string is passed as the parameter then the content is cleared. Quick and dirty.. ~result = Case(IsEmpty(hex_string );""; Base64Decode ( ~png1x1_base64enconded ; hex_string & ".png" ))
		Tony White, Tony White Designs, Inc. Feb 28, 2021
Hi Tim, Interesting idea. Added it as v2. In the v1 a blank value seems to fall to the default and clear. That said, an intentional empty value could be handled explicitly at the top of the Case Function, while a missing value could be handled as a default Case/color/PNG TBD. Thanks for the feedback.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.
png1x1 ( hex_string )

Comments

Support this website.

Support this website.
