I have a table that has two fields, that the user can change:
- Stage;
- Probability.
However if the Stage is ‘Lost’ the probability should be automatic 0 and if is ‘Won’ should be 1.
I setup a trigger on field Probability with an onchange on the field Stage, the formula is something like:
1 if $Deal_Stage == 'Closed-Won' else (0 if $Deal_Stage == 'Closed-Lost' else $Probability)
However I get a circular Reference Error
, I guess I cannot set the field to its value.
How can I maintain a field the can be changed by the user and also changed by a formula?