Service Duration Value

Hello,

I am trying to implement a formula: ifElse(contains($arr_yes_no_c,"Y"),divide($sub_new_arr_c,"service_duration_value"),"")

However, I am getting an error message: Unknown field: service_duration_value

Anyone knows the standard name for Service Duration Value?

Thanks!

  • This field is not Studio enabled by default. In order to reach it you can configure the attribute formula via Extended Vardefs instead.

    Fullscreen
    1
    2
    3
    $dictionary['theClass']['fields']['the_field']['calculated']='true';
    $dictionary['theClass']['fields']['the_field']['formula']='ifElse(contains($arr_yes_no_c,"Y"),divide($sub_new_arr_c,$service_duration_value),"")';
    $dictionary['theClass']['fields']['the_field']['enforced']=true;
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • I think it should be

    ifElse(contains($arr_yes_no_c,"Y"),divide($sub_new_arr_c,$service_duration),"")

    Bests

    Björn

  • I tried this formula and I am still getting the error message.

    Unknown field: service_duration_value 

    By now I know that The Service Duration field is a combination field that contains:

    Service Duration Value
    Service Duration Unit

    I just need the Value part for my formula

  • That's all quite new for me - need to read more on Vardefs.

    What you included:

    $dictionary['theClass']['fields']['the_field']['calculated']='true';
    $dictionary['theClass']['fields']['the_field']['formula']='ifElse(contains($arr_yes_no_c,"Y"),divide($sub_new_arr_c,$service_duration_value),"")';
    $dictionary['theClass']['fields']['the_field']['enforced']=true;

    Is that an example of how my formula can be embedded in the Extended Vardefs? 

    Where would I insert a ready formula?

    Thanks so much for your help on that
    Ada