1

I want to create workflow and i want formula to be like is, When Property_status__c = Unqualified, Watch__c = True, Current_price_list__c = --Decrease, Top__c = ++increase, City__c = Chicago.

For example,If Current List Price goes down And If Top Property Price goes up and meet other criteria, at that time workflow should fire.

In this one i am not sure how can i use increase and decrease for any field?

Any help please.

Improve this question
2
  • The issue is how would you keep track of old value.
    – Mr.Frodo
    Apr 29, 2016 at 14:56
  • Cant i do like if the value goes down from current value(whatever it is) then workflow will fire.
    – Salesfor_dev
    Apr 29, 2016 at 14:59

2 Answers 2

Reset to default
1

Not sure if this is the right syntax, but you could try to create the workflow when the formula evaluates to true. It would look something like this, without having to create any additional fields. 

AND(
(Property_status__c == "Unqualified"),
(Watch__c == "True"),
(City__c == "Chicago" ),
(ISCHANGED(Current_price_list__c )),
(Current_price_list__c-(PRIORVALUE(Current_price_list__c))<0),
(ISCHANGED(Top__c)),
(Top__c-(PRIORVALUE(Top__c))>0)
)
Improve this answer
10
  • Tried that,but its not working.
    – Salesfor_dev
    Apr 29, 2016 at 16:09
  • are all your described fields of type 'Text' , because if they are of type picklist value you'd have to use the following syntax IsPickValue(MyField__c, "Case1")
    – Marc Zaharescu
    Apr 29, 2016 at 16:20
  • What about currency field? Current_price_list__c is a currency field.
    – Salesfor_dev
    Apr 29, 2016 at 16:24
  • the currency shouldn't be a problem as it will interpret the value when performing the calculations as far as I'm concerned. try To eliminate 1 condition at a time and see where is failing. From a logical perspective the workflow should work
    – Marc Zaharescu
    Apr 29, 2016 at 16:32
  • AND( (IsPickValue(Property_status__c, "Unqualified")), ( Watch__c == "True"), (City__c == "Chicago" ), (ISCHANGED(Current_price_list__c )), (Current_price_list__c -(PRIORVALUE(Current_price_list__c ))<0), )
    – Salesfor_dev
    Apr 29, 2016 at 16:37
0

You will probably need a new field for the previous price. and have a workflow that will copy the value into this field when the price changes. then on your other workflow you can do if old price is larger than new or if old price is smaller than new fire the workflow.

Improve this answer
3
  • Thats what i also thought, but how can i store previous value in other field?
    – Salesfor_dev
    Apr 29, 2016 at 15:20
  • you will need a workflow for the price with ISCHANGED(Field name) and then workflow can use update field and update the new field (old price) with the price.
    – Benjy Hunt
    Apr 29, 2016 at 15:29
  • I think directly using PRIORVALUE() is much better choice rather then creating new field.See @marc answer.
    – Mr.Frodo
    Apr 29, 2016 at 15:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .