Where are custom fields located

[routledge]

Hello peeps

Well this may sound like a dumb question, but where are the files containing custom fields in leads. I'm using 5.0

Cheers all

[andopes]

Hi routledge

In database:
table fields_meta_data: each record refers to a single custom field
table <table_name>_cstm: custom field with the same name in fields_meta_data table

In system:
cache/modules/<ModuleName>/<ModuleName>vardefs.php: file containing all fields for the module, including the custom fields.

If you need to modify the custom fields then you should perform this action in the Studio;
If you need to modify the type of the custom field so you should perform this action updating the table fields_meta_data and after that go to Admin -> Repair -> Repair Database
If you need to create an installer so you could copy the field defs for the custom field in the cache folder.

Cheers

[routledge]

Cheers Andre

What i'm really trying to do is change the vardefs for the custom fields, is this possible.

Regards

John

[andopes]

Hi routledge

Unfortunately it is not possible because always when you create a new custom field or install a new package the vardefs is rewrote automatically erasing all your changes.

Cheers

[routledge]

Hi Andre

Will have to rethink my strategy, but as always thanks so much for the help.

Regards

John