how do i create a custom field without using studio?

[schnagga]

hi,

i want to create a custom field in an upgrade safe manner without using studio for existing modules like Opportunities.
i.e: if i create a currency field with the studio, it creates a db field of varchar(255) (MySQL). i want to specify a different type, and in general want to be more flexible with field parameters.

i found the <module_name>vardefs.php and the fields_meta_data table, but i am not sure how to implement new fields in code, so that they are applied to the db and the existing module.

i am using Sugar Version 5.0.0e

[nileshdave]

Hi ,
You have to put field defination in custom/<modulename>/Ext/<module>Vardef.php &
custom/<modulename>/metadata/detailviewdef.php &
custom/<modulename>/metadata/editviewdef.php

try this i hope it solves the problem and its 100% upgrade safe

Thanks
NileshDave
iNetPrecess

[DragonflyMaster]

To learn about the correct syntax, you can build a custom field via studio and deploy. Then go in custom/modules/<module_name>/ and look at the files/folders created in there, so you can replicate them at your wish.

[schnagga]

hi, thx for your help.

i couldn't get it to work to make a custom field of type 'currency' with 'dbType' double. i finally reduced the varchar(255) size to varchar(14) with the 'len' attribute. dbType seems to have no effect when specifiying type 'currency'.

kind regards