+ Start a Discussion
JillWJillW 

Update Custom Activity Field

Hello,

 

I have two custom Activity fields: Result (picklist) and Result Date.

 

When somebody selects a Result, I want the Result Date to be filled in with the current date.

 

I can't figure out what the proper syntax is. Can anybody help me?

 

Thanks in advance!

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

You should be able to evaluate if "any value" from your picklist has been selected, rather than having to evaluate all 21 values just to see if 1 of them has been picked.

 

Something like

NOT(ISPICKVAL(PicklistField,""))

 

 

 

Message Edited by Stevemo on 03-03-2009 09:51 PM

All Answers

JillWJillW

Picklists are driving me nuts. :smileysad:

 

I've got this working:

IsPickVal(cst_result_code__c, 'Complete with Contact'). The trouble is, I have 21 possible results. Do I have to create a rule for each of them?

 

Is there a way to say "If a value from the Result Picklist has been selected, then set the Result date to today?"

 

OR

 

Is there a way to put all 21 options into the same rule?

SteveMo__cSteveMo__c

You should be able to evaluate if "any value" from your picklist has been selected, rather than having to evaluate all 21 values just to see if 1 of them has been picked.

 

Something like

NOT(ISPICKVAL(PicklistField,""))

 

 

 

Message Edited by Stevemo on 03-03-2009 09:51 PM
This was selected as the best answer
JillWJillW

Yes! That's the syntax I was looking for. Thank you!

 

:smileyhappy: