Details about this thread
  • State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 78 subscribers
  • Views 689 views
  • Users 0 members are here
Related content from around SugarClub

Service Duration Value

Ada Napierala
6 months ago

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!

Parents
  • 0 6 months ago

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

    $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;

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 6 months ago in reply to André Lopes

    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 

Reply
  • 0 6 months ago in reply to André Lopes

    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 

Children
No Data