StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTroubleshooting dynamic dropdowns in SugarCRM 6.5
primarykey
Id
19419499
data
AcceptedAnswerId
19444513
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-10-17T06:15:21.327
FavoriteCount
1
LastActivityDate
2016-03-14T15:48:29.307
LastEditDate
LastEditorUserId
0
OwnerUserId
1644831
ParentId
0
PostTypeId
1
Score
1
ViewCount
1252
LastEditorDisplayName
text
Body
I had asked a question here a while back about setting up database populated dropdowns for SugarCRM. I received a really good answer and, after more php studies and a dev instance running, I decided to give it a shot. The instructions I followed can be found <a href="http://www.eggsurplus.com/home/content/populate-a-dropdown-from-the-database/" rel="nofollow">here</a>. After I run the repair and rebuild, I would expect to see the custom field in my Fields list under the module in studio, but have not been able to find it. The module is named Makers (a1_makers as a database table). For good orders sake, there were no errors when I repaired/rebuilt after saving the files. Per the instructions, I first created a php file with a custom function to query the database (custom/Extension/application/Ext/Utils/getMakers.php): <pre><code><?php function getMakers() { static $makers = null; if (!$makers){ global $db; $query = "SELECT id, name FROM a1_maker"; $result = $db->query($query, false); $accounts = array(); $accounts[''] = ''; while (($row = $db->fetchByAssoc($result)) !=null) { $accounts[$row['id']] = $row['name']; } } return $makers; } ?> </code></pre> Then, I set 'function' field in Vardefs to point to the function (custom/Extension/modules/Maker/Ext/Vardefs/makers_template.php): <pre><code><?php $dictionary['Maker']['fields']['list_of_makers'] = array ( 'name' => 'list_of_makers', 'vname' => 'LBL_MKRLST' 'function' => 'getMakers', 'type' => 'enum', 'len' => '100', 'comment' => 'List of makers populated from the database', ); ?> </code></pre> Unfortunately, there are no errors and the repair/rebuild runs fine. I am just unable to see the custom field when I go into studio. Can anyone please help point out what I may be doing wrong?
Tags
<php><mysql><sugarcrm>
Title
Troubleshooting dynamic dropdowns in SugarCRM 6.5
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USSandwich Heat
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POTroubleshooting dynamic dropdowns in SugarCRM 6.5
 UserUserId
 USnmjk
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.