Set Field – Number field – do calculation

[Sergio Giusti]

Hi Alex

I would like to have a rule that is triggering a number field being set to a new value, i.e.

if X = Yes then set field {Y} to {Y} + 1

can I do this? if so, how?

Thanks

[Alexander Bautz]

Hi,
I’ll add this to the setfield functionality in the next release (with a “sum:” prefix), but in the meantime you must use a custom function like this:

function customCalc(){
    var a = getFieldValue("YOUR_SOURCE_FIELD_NAME");
    var b = parseFloat(a) + 1;
    setFieldValue("YOUR_TARGET_FIELD_NAME",b);
}

Alexander

[Sergio Giusti]

Thank you

[Author]

Posts