[Vtigercrm-developers] 5.4 - converted leads - default picklist values ignored

[Adam Heinz]

If you're not averse to modifying the database, what we did here was

ALTER TABLE vtiger_foo
MODIFY COLUMN leadsource NOT NULL DEFAULT 'bar';

We actually went a step further with a

REFERENCES vtiger_leadsource (leadsource) ON UPDATE CASCADE

so that any renaming of lead sources is propagated.



On Sun, Aug 4, 2013 at 7:27 PM, Richard Hills <richard at tw.co.nz> wrote:

> I am experiencing the following problem:
> When I create an account/opportunity from a lead if no values are mapped
> for my custom picklists, rather than defaulting these to the values
> selected in the module manager these values are filled as null.
>
> I was just wondering if anyone can suggest a solution, I presume the code
> in the conversion part of the system simply ignores these defaults and if
> possible I would like to avoid having to write this script. If this has
> never been done however I may look at fixing up the code to look properly
> for default field values. I would love to hear I have just done something
> wrong, so if this is working for you then please let me know also.
>
> I have considered writing a cleanup workflow but again as we can not match
> on null in the conditions area of the workflow setup this does not seem to
> be possible.
>
> Thanks
>
> --
> Richard Hills
> TechnologyWise Ltd, Tauranga, NZ
> richard at tw.co.nz
> www.technologywise.co.nz
> ph: +64 (0)7 571 1060
> fax: +64 (0)7 571 1061
>
> ______________________________**_________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130805/775ecdfc/attachment.html>