Skip to main content
Hello,

 

I had an Image formula field whose result  was based on 3 checkboxes values.

 

For each possible combination of the checkboxes the formula displayed a different image.

 

It worked perfectly.

 

I've just added a fourth checkbox and tried to include in the existing formula BUT the maximum characters number is reached and I cannot complete the formula.

 

Any alternative option?
12 risposte
  1. 11 feb 2021, 17:20

    You don't put the Resource ID in the Formula, you put the literal Resource File Name, like this 

    IMAGE(

    CASE( Do_you_owe_SteveMo_a_beer2__c ,

    'Yes', "/resource/Glass_Ball_Green",

    'Of course',"/resource/Glass_Ball_Blue",

    'Obviously', "/resource/Glass_Ball_Yellow",

    'Hell Yeah!', "/resource/Glass_Ball_Red",

    'Most certainly', "/resource/Glass_Ball_Gray",

    'Damn right you do!',"/resource/Glass_Ball_Green",

    "/resource/Glass_Ball_Gray"), "You owe me a beer!", 32, 32 )

     

    You don't put the Resource ID in the Formula, you put the literal Resource File Name, like this IMAGE(CASE( Do_you_owe_SteveMo_a_beer2__c ,'Yes',
0/9000