• How to add a related Field without adding an explicit relationship?

    Hi Developer, In SugarCRM Studio I can add a field with the type relate and link to the Accounts module. There should not be an explicit relationship between the modules. A custom table is then created for this, in which the ID of the account is inserted…
  • Button Field - How to embed the "definition" in a vardef file instead of partial DB storage

    Hi Guys, I have a quick question : do you know how to store in a vardef file the FULL definition of a button field (instead of the current storage when created from the studio with partial storage in DB table) ? The purpose of this request is…
  • Custom Tax and Currency fields on Account

    Dear Sugar Users, I'm attempting to add two custom fields to our Accounts. These are: Tax Rates Currency As neither of these fields can be added via the Relate data type in studio, i.e. they are not in the list of available modules, I have…
  • Is it possible to use an enum field with a function defined as the data provider as a trigger for another fields visibility grid?

    I have one enum field where there is no options parameter, instead, I am using a defined function. $dictionary [ 'Case' ][ 'fields' ][ 'pr_department' ][ 'name' ]= 'pr_department' ; $dictionary [ 'Case' ][ 'fields' ][ 'pr_department' ][ 'vname' ]= …
  • populate_list - Relationship

    Hi all. I'm looking to simply use populate_list to pull a relationship from Leads into Opportunities. I've created what I thought was the correct simple file of: <?php $dictionary["Lead"]["fields"]["opportunity"]['populate_list'] = [ 'contacts_leads_1_name…
  • I need to

    I have an Use Case where : 1. There is one checkbox in Account Module which should get enable or visible only when : a. Account Inofrmation is saved successfully without any error and this account should have atleat one Address and atleast one case…
  • how to make a cloud compatible studio customization for enums

    Hi, is there a way to modify the studio view "modification of a field" in order to add some custom properties to the vardefs while being cloud compatible ? As of now we were using an admin view and the method "array_to_file" to push our custom properties…
  • Related Field - Search

    Hi all, I extended the Calls module by a ID field pae_contact_id, linked to the Contacts Module. (see code below of the pae_vardef) Additional I want to display & search the Contact Name and Country in the Calls List View. Displaying the data works…
  • issue adding email field to cases module

    I am trying to add the email field to the cases module, I tried to follow the Adding the Emails Field to the Record View from the sugar developer guide and everything seemed to work well, the field appears but when the record is saved it throw me the…
  • Why is Package not uninstalling correct?

    CreditFields.zip Above is a link to the package I am using. The package installs just fine, yet when I uninstall it I get the following errors. Wed Sep 30 16:05:49 2020 [ 6385 ][ 1 ][ ALERT ] Query Failed: ALTER TABLE campaigns_cstm drop COLUMN…
  • quotes total and subtotal field ignore vardef required setting

    The total and subtotal field appear to ignore the vardef "required"=false setting. They are still required when saving a quote. Any idea why? or how to allow a quote to be saved without a total or subtotal value? (the calculations have been removed and…
  • Calls: Related To: more data in list view

    Hi all, I'm trying to extend the Calls List view with new columns: Related Country Related State Related City These Data should be pulled by the "Related To" Record if existing. Related to can be Lead / Contact / Account or also something else, where…
  • Defining the custom index in a Vardefs Extension

    HI All, I Just want to w hat is the purpose of defining the custom index in a Vardefs Extension and Is it any relation elastic search ?
  • optimistic_locking parmeter in vardefs.php (vardefs location for custom modules)

    Hi, thanks for looking! This support documentation page: https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.0/Data_Framework/Vardefs/index.html ...suggests that the vardefs.php file is in the location: ./modules/Contacts…
  • How to manually create dependent dropdowns

    The documentation section Manually Creating Custom Fields provides a good description of creating fields using the module loader, including dropdowns. But how can I do the same thing for dependent dropdowns, where I need to specify a parent dropdown and…
  • Has populate_list stopped working for quotes in 7.10?

    We had a pretty simple customization in 7.8 that was populate a phone number and email field when a contact relate field was populated in quotes. After upgrading to 7.10 it no longer works. We were adding the following to the vardef $dictionary [ 'Quote…
  • Trying to create a relationship between Opportunities and Meetings and use the existing subpanel

    The goal is to create a one-to-many relationship of Opportunity to Meetings ( opportunity_meetings_1 ). As you know, Opportunities already have such a relationship ( opportunity_meetings ) because Meetings has a native flex-relate field. I know that creating…
  • "Data not available" error message after editing custom dropdown field

    I'm working in a 7.6.1.0 Sugar Professional instance. I created the dropdown field sales_person_c in the Accounts module, which will later list all the users with certain roles. To accomplish this I replaced the field vardefs with the following: $dictionary…
  • Clarification needed on len, size, precision in vardef for decimal

    in vardefs a decimal has a length, size, and precision. How are the three related and what do they correspond to in the database definition? if you have len and precision, wouldn't size be superfluous? or is size just a display parameter? I am toying…