Table Type field query

[Deepa Srivastav]

Dear All,

I have a "table name" type field whose base table is alm_asset. According to my requirement it should show all extended tables except one/two. Also it shows table name in bracket i.e. dropdown value are in format ... Hardware[alm_hardware] etc, which we don't want.

To implement this I have added tableschoicescript attribute in the field and hardcoded extended table names there..

But problem is that I want first option to be "--None--" but in the field by default some other value is coming from script include (one of the table name) when I open the form .It is proper if I click the dropdown.

I wrote a client script to to add "--None--" in index 0..but nothing is helping..

Can somebody suggest me way to achieve this..Please check screenshots for reference.

Thanks in advance!

[Abhinay Erra]

Deepa,

    If your field is mandatory, then the following script will work. If it is not mandatory, DOM manipulation is the only way I could think of to achieve your requirement.

onLoad Client script:

g_form.addOption('u_table_name','','-- None --',0);

  if(g_form.isNewRecord()){

  $('incident.u_table_name').options[0].selected=true;

  }

[Deepa Srivastav]

Field is not mandatory Abhinav

[Deepa Srivastav]

Thanks Abhinav for your help

[Kalaiarasan Pus]

Selected this on dictionary level?

[Deepa Srivastav]

Yes Kalai checked with this too..

But Abhinav's approach is working as that field is becoming read only after submission and value is not changing...