Custom Field Location

Hi Russel Vasquez,

Go to database check for the table leads_cstm table you can find all the custom field for leads module

Thanks & Regards 

G Varun Kumar

Hello G Varun Kumar, thank you. I check it and give a feed back.

Hi Russel,

In addition to Varun's Reply, I would like to add a few things to this. As he mentioned whenever a custom field is created in any module sugar creates a custom table in the database. It stores all the custom fields (which ends with _c) in the custom tables only. So for the leads, all the custom tables will be stored in the leads_cstm table only. Similarly, if it accounts all the custom fields will be stored in the accounts_cstm table and respectively for all the modules.

And Sugar will not store the email addresses directly in the main module. It has a separate set of tables for storing all native email addresses of different modules. Please go through this link to know more about how Sugar stores email addresses of various modules in the Database.

Hope this information helps you:)

Thanks and Regards,

PK,

www.bhea.com

Hi Russel,

In addition to Varun's Reply, I would like to add a few things to this. As he mentioned whenever a custom field is created in any module sugar creates a custom table in the database. It stores all the custom fields (which ends with _c) in the custom tables only. So for the leads, all the custom tables will be stored in the leads_cstm table only. Similarly, if it accounts all the custom fields will be stored in the accounts_cstm table and respectively for all the modules.

And Sugar will not store the email addresses directly in the main module. It has a separate set of tables for storing all native email addresses of different modules. Please go through this link to know more about how Sugar stores email addresses of various modules in the Database.

Hope this information helps you:)

Thanks and Regards,

PK,

www.bhea.com