Link new drop down to existing fields

[sinkplaat]

Hi, I would like to create a drop-down to link to the existing country fields, billing_address_country and shipping_address_country.

Is this possible or can I only use custom fields when creating new drop-downs?

Thanks

[lu2007]

sinkplaat:

I don't know if you ever found an answer to your post, but I was also looking for an answer to this same problem.

I just happened to open the EditView.html file because I was trying to figure out how to adjust the columns on the view panel and I found the answer (I haven't tested it yet, but I believe this will work).

The EditView.html file is located in the Sugar/Modules/Leads directory. Edit this file and change the name of the Select object that contains your drop-down to match the field in your database that you want to link it to.

For instance, I created a drop-down menu called "lead_class_c". The label for this menu is also called lead_class_c. However, the existing field in the database is called "targetsale_c". So in order to store the data from the drop down in the database under the existing field, change the name of the select object to match the existing field name.

<select name="lead_class_c" tabindex='1'>{OPTIONS_LEAD_CLASS_C}</select

gets changed to:

<select name="targetsale_c" tabindex='1'>{OPTIONS_LEAD_CLASS_C}</select>

Please let me know if this works for you. I had already recreated my fields in the database, so I am unable to test this. But I am pretty sure this will work.

LU2007