Skip to main content
Topics#FormulasQuestion de David Hart
David Hart (Future State Solutions) a posé une question dans #Formulas
18 juil. 2018, 09:16

How can I use values from two or more other fields to auto-populate a field?

I would like a field to auto-populate based on the value of two other fields.

For example:

If field 1 = low and field 2 = high make field 3 show dog,

If field 1 = high and field 2 = low show cat,

If field 1 = low and field 2 = low show mouse,

If field 1 = high and field 2 = high show horse.
1 réponse
  1. Steven Kayanja Nsubuga (UN World Food Programme, Rome)
    18 juil. 2018, 10:38
    Field 3 should be a text formula field.

    Tweak this formula to reflect your actual field API Names and image locations.

    IF( 
     AND(TEXT(field1__c) =='low', TEXT(field2__c) =='high'), 
    	IMAGE("/img/samples/dog.gif", "dog"), 
    		IF(
    			AND(TEXT(field1__c) =='high', TEXT(field2__c) =='low'), IMAGE("/img/samples/cat.gif", "cat"),
    				IF( 
    					AND(TEXT(field1__c) =='low', TEXT(field2__c) =='low'), IMAGE("/img/samples/mouse.gif", "mouse"),
    					IF( 
    					AND(TEXT(field1__c) =='high', TEXT(field2__c) =='high'), IMAGE("/img/samples/horse.gif", "horse"),
    										IMAGE("/img/s.gif", "NA"))
    				)
    		)
    )

     
Rédiger une réponse...
0/9000