CA Service Management

  • 1.  Lookup field

    Posted Feb 19, 2018 09:23 AM

    Hi,

     

    We have a requirement that when end user selecting a value through a lookup field, based on the value selected a field should be show or hide in form. How can we do this? can any one share an idea?

    Below is the code we have tried.

     

    tenantreq: function() {

    var one = ca_fdGetSelectedOptionValues('ServerBuildForm', 'cust_tenant_name');

    //var isConsulente = ca_fd.js.az_isConsulente(one);

    alert('The value of one is',one);

    if (1)

    {

    ca_fdShowField('ServerBuildForm','owner');

    }

    else

    {

    ca_fdHideField('ServerBuildForm','owner');

    }

    },

     

    Regards

    Venky 



  • 2.  Re: Lookup field

    Broadcom Employee
    Posted Feb 19, 2018 09:46 AM

    Good Afternoon Venky.

    Just an example as a possible way to get this working for you.
    Please note, it is an example to get you started.
    It is not meant as 'the solution' for you on this subject.

    Thanks in advance for your understanding and kind regards, Louis.

    {
    getProducts : function ()
    {
    ca_fdFetchSelectData(ca_fd.formId, 'sel_1');
    },

    getProductbyID : function (selValue)
    {
    console.log('getProductbyID1');
    ca_reportQuery('300378685f4e-78878ef215cea3c2da9-7f2a1498628830682',
    {'productID':selValue,'inuserid':ca_fdGetTextFieldValue(ca_fd.formId,'hid_user')},
    function(result)
    {
    ca_fdShowFields(ca_fd.formId, ['lbl_9']);
    if (result.length > 0)
    {
    ca_fdSetTextFieldValue(ca_fd.formId, 'lbl_cat_string','(ISO 9999) / Hjälpmedelsområden / 12 Förflyttning / 1222 Manuella rullstolar / 122203 Manuella tvåhjulsdrivna rullstolar');
    ca_fdSetTextFieldValue(ca_fd.formId, 'ncust_product_name',result[0]['cust_product_name']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nproduct_nr',result[0]['product_nr']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nsupplier',result[0]['supplier']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nproduct_nr_supplier',result[0]['product_nr_supplier']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nsupp_product_name',result[0]['supp_product_name']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nupdated_date',result[0]['updated_date']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nproduct_unit',result[0]['product_unit']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'nunit_qty',result[0]['unit_qty']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'product_color',result[0]['product_color']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'product_material',result[0]['product_product_material']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'product_weight',result[0]['product_weight']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'product_color',result[0]['product_color']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'class_category',result[0]['class_category']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'class_code',result[0]['class_code']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'class_description',result[0]['class_description']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'part_of_class',result[0]['part_of_class']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'price',result[0]['price']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'agreement_name',result[0]['agreement_name']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'selling_party',result[0]['selling_party']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'bying_party',result[0]['bying_party']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'agreement_number',result[0]['agreement_number']);
    ca_fdSetTextFieldValue(ca_fd.formId, 'agreement_status',result[0]['agreement_status']);
    }
    ca_fdHideFields(ca_fd.formId, ['lbl_9']);
    },
    ca_fd.js.onFailureFetch);

    },

    getSelectedRow : function ()
    {
    console.log('getSelectedRow');
    var selValue = ca_fdGetSelectedOptionValues(ca_fd.formId, 'sel_1');
    console.log(selValue);
    ca_fd.js.getProductbyID(ca_fdGetSelectedOptionValues(ca_fd.formId, 'sel_1'));
    },

    }



  • 3.  Re: Lookup field
    Best Answer

    Broadcom Employee
    Posted Feb 20, 2018 11:25 AM

    We solved this in a Support case - the problem was that the field being selected from was a text field, not a select one. So the function used to retrieve the data is

     

    var one = ca_fdGetTextFieldValue(ca_fd.formId, 'cust_tenant_name');

     

    thanks

    Iain