You need to sign in to do that
Don't have an account?
Pablo Argentina
Autofill Date Field
Hi guys. Another easy question that it's makeing me go crazy!!!
I have 2 fields.
1.- Pick list with 3 different values (Win, Lost, 50%)
2.- Date field
I want to fill in (automatically) the DATE field with the exact day that i choosed WIN as the pick list value.
The idea is to remember when was that lead won and store that date under DATE field.
Any idea??
thanks in advance
Pablo (Argentina)
'apai' that workflow will be fired everytime the record is edited and the picklist value is Win. Hence will keep on updating the date(you wont get the exact date when it was changed to win).
Pablo do this:
All Answers
You can create a workflow rule:
criteria - whenever an opportunity record is created or edited, and did not previously meet the rule criteria
rule - when opp stage equals WIN
add workflow action - field update -
select date field and using the formula editor, set the value as TODAY()
'apai' that workflow will be fired everytime the record is edited and the picklist value is Win. Hence will keep on updating the date(you wont get the exact date when it was changed to win).
Pablo do this:
abhi, i have a similar problem. I'm trying to create a workflow that would change the case status automatically to 'New' when a case is transferred to another person. But I don't want it to run for one particular case owner.
What is the unique ID in your case? Is it a field or is it the user ID appered on the address bar when clicked on that user?
AND(ISCHANGED(OwnerId), OwnerId <> 'owner id')
*the user ID appered on the address bar when clicked on that user[Your Name | Setup | Manage Users | Users | ]. Similar to this 005A0000001cbIr
It was the user id when I clicked on the users name under Users.
However, I see now that you have a quote mark around the ownerid. I did not have that and now it works!
Thanks so much for your help! I really appreciate it.
In a WFR you have the option of triggering "When a record is created, or when a record is edited and did not previously meet the rule criteria" that will prevent the date field from being updated every time the record is editied.