Dropdown menu issue

[jonnywatson]

Hi all,

I have added a dropdown menu in opportuntines, this replaces the probability text box with a choice of 4 percentages. Everything works correctly apart from when you edit a record to put in the percentage, it doesnt get written to the database. The custom table is created in the DB and the feild of the custom probability is there but no link or data is entered. I have tried repairing the relationships and the whole database but nothing seams to work. BTW its sugar 5.0f......

Anyone got any ideas?

Cheers,

Jonny

UPDATE: It appears i can not change anything in the opputunities module just tried to change the list layout and nothing is changing...although it has in studio......hmmmmm

[jonnywatson]

OK so i can now change the layout again...but still cant get my dropdown menu to store in the record.....its not generating the links or the relationships....i think....but i just cant see why....

[jonnywatson]

Nobody can help??

I cant get it work at all.....

[jonnywatson]

*BUMP*

[andopes]

Hi, Jonny.

Make sure there is an entry for this field in the file cache/modules/Opportunities/Opportunitiesvardefs.php
Make sure there is an entry for that into fields_meta_data table and make sure there is this field into opportunities_cstm table.

Cheers

[jonnywatson]

Yep all those entrys are there....It will allow me to select the value from the drop down menu but when i press save it just isnt writting the data to the tables....

[andopes]

Can you paste here the definition for that custom field in the cache/modules/Opportunities/Opportunitiesvardefs.php?

Post also the defs for this field into editviewdefs.php (custom/modules/Opportunities/metadata/editviewdefs.php)

Cheers

[jonnywatson]

Opportunitiesvardefs.php
'oppprob_list_c' =>
array (
'required' => '0',
'source' => 'custom_fields',
'name' => 'oppprob_list_c',
'vname' => 'LBL_OPPPROB_LIST',
'type' => 'enum',
'massupdate' => '1',
'default' => '0%',
'comments' => '',
'help' => '',
'duplicate_merge' => 'disabled',
'duplicate_merge_dom_value' => '0',
'audited' => 1,
'reportable' => 0,
'len' => 100,
'options' => 'oppprob_list',
'studio' => 'visible',
'id' => 'Opportunitiesoppprob_list_c',
'custom_module' => 'Opportunities',
),
editviewdefs.php
array (
0 =>
array (
'label' => 'LBL_ASSIGNED_TO_NAME',
'name' => 'assigned_user_name',
),
),
7 =>
array (
0 =>
array (
'label' => 'LBL_OPPPROB_LIST',
'name' => 'oppprob_list_c',
),
1 =>
array (
'label' => 'LBL_DESCRIPTION',
'name' => 'description',

Hope this helps.....

[andopes]

Hi, Jonny.

Everything seem allright.
But I believe the options could not have "%" as value.

Try to change the options key to number only (20) and the values to percentage (20%)

Cheers

[jonnywatson]

Hmm...well i have just changed it all from having the % in it to having just a number and its made no difference....i will leave it till monday now i think....

Thanks for all your help!