News & Updates
Training & Certification
to create and rate content, and to follow, bookmark, and share content with other members.
In which table custom fields stored!!
Question asked by
on Aug 6, 2015
on Aug 6, 2015 by Francesca Shiekh
Show 0 Likes
Hello guys ,I'm new sugarcrm developer ,im wondering where are the custom fields that i created using Module Builder stored (custom_fields table is empty).
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Aug 6, 2015 2:10 PM
If you created a whole module via module builder, then you will get a new table for that module. The table name matches your module name and starts with the key you selected when you started creating the package. Many choose to use an acronym for their company/client as the key, so they can tell which tables were created by them and which are stock SugarCRM.
The field definitions themselves will be in <sugar_root>/modules/<your_moduleName>/vardefs.php
If you ADDED fields to modules using Studio, be they yours or out-of-the-box ones, the fields_meta_data table will have field definitions.
When you add a custom field to an existing module through Studio (be it a SugarCRM out-of-the-box module or one you have previously built in Module Builder and deployed), the field itself is added to a table called <module>_cstm where <module> is the module you added the field to.
So, for example, if you added a field to Accounts you will find it in accounts_cstm.
The custom table links to the original module's table via id. For example:
accounts.id = accounts_cstm.id_c
You will notice that all your custom fields end in _c. That makes it easier to identify them as custom when coding and especially when re-reading code or viewing the source of your application.
There is not a lot of detail about where things end up, but this is a good starting point for using Module Builder:
One note of caution: If you make modifications to the module after you have deployed it, you will loose them if you deploy again from Module Builder.
I hope this answers your question.
Show 1 Like
Retrieving data ...
Help or Alternative for Custom-Triggered Dropdown
SugarCon and Sugar Scholars
Just about everything you need to know about the Fall '18 Release
Developing CTI for Sugar
Setting Up Your Profile