• enum shows multienum default values in studio

    In Pro v11.0.5 (and all preceding versions since v6) an enum field would have a single choice of default value and a multienum multiples, which makes total sense. In Ent v12.0.3 I just noticed that an enum has a multi-selection of default values.…
  • PHP error in studio

    Hi, I am getting the following error when accessing the studio and trying to edit a field. Also the CSS is not properly loading. Anyone having any experience with this? PHP Fatal error: Uncaught TypeError: Cannot access offset of type string…
  • Updating my formula

    Hi, I would like to update my Total Contract Value formula. At the moment this is it: rollupConditionalSum($revenuelineitems,"total_amount","sales_stage",forecastSalesStages(true,false)) I would like this field to sum from additional fields…
  • Studio not able to restore default layout?

    Hi All, I hope you can help on this one.. I have an issue on Opportunity module. I will explain the issue as I am not sure why this odd behaviour only occurs on Opportunity. (Sugar version 11.0.2) - ON site no customisations Step's - this is mine…
  • How to utilize Quick Repair from the CLI and the Profile Menu

    In the next post at https://sugardevelopersguide.substack.com/ . We will publish our thoughts on QRR from the command line and from the profile menu. Detailed instructions and Module Loadable Packages to add QRR functionality to the SugarCRM Console…
  • Roles - Want to edit but not create without adding code

    Hi everyone. Maybe a simple question, but wanted to confirm. Looking at roles on the front end "Edit" ties into both Edit and Create. We have scenario where the customer would like to edit records but doesn't want anyone creating any (As they come in…
  • Is it possible to set the link text for a URL field type?

    Is it possible to provide a "link text" for a URL field type such that displaying the URL-typed field shows the link text and not the URL stored in the URL field? Background: In a "parent" Opportunity / Account / Contact, we store a link to the last…
  • How to import a Revenue Line Item correctly?

    Hello Devs, in this ocassion I want to ask you if you can please help me with the following: I want to import A LOT of Opportunities with their Revenue Line Items, I am importing directly the RLIs so the Opportunities can be created automatically…
  • What is the Product Bundles module in Studio? (zero documentation)

    Hi, Does anyone know what the Product Bundles module is used for? I've searched high and low, and I cannot find any answer from SugarCRM. Thanks, James.
  • Any rules against using capitals in the naming of fields?

    I have some very old fields (circa Sugar v.6.x) that have names that start with capital letters like: VIP_status_c I just now noticed that in v9.0.3 Professional and v.10.0.3 Professional when I add them to a layout using Studio, the layout is saved…
  • How to import or populate Contact on Case

    Hello! I've been learning Sugar for the past few months. I've setup some workflows for notifying portal users when their case changes status. This WF uses the Contact Subpanel to get the recipient to send the notificacion via email. However when…
  • How to know the data types of the fields of the different modules?

    Is there any place where the datatype values are stored? I need to know what kind of data they are in order to display them. For example if the status field is a dropdown I will put a dropdown, if it is a text area I will put a text area etc.
  • Email validation is not working

    Email validation is not working. It is getting saved even if we are not giving anything after @.
  • How set a value as selected on relate field

    Hi All, How to set the relate field value as selected , based on the value of a field on same module or another module ? Please help me to find a solution.
  • Record View Layout in studio is showing single column

    Hi Everyone, In studio for all modules in record view layout it is showing single column( fields are updating in single column) and in module view I am able to see the layout in two columns. Layout in Studio: Layout in module: If I add new fields in record…
  • Studio view not refreshed on Save

    After moving a SugarCRM instance from one server to another we discovered an issue in Studio. When modifying something in Studio, like adding or removing fields and panels in the Record View layout of the Accounts module, after clicking Save & Deploy…
  • how would I do show the total number of cases a company has that are not resolved in a calculated field?

    I would like to show how many cases a company has got open that have not been resolved. I would like to show this in a calculated field inside of an account.
  • Sugarcrm 7 Multi-select keys display wrong characters in database

    Hello fellow sugarers ! I have a big weird issue with multiple choice dropdowns, the keys in the database are encapsulated within "^" characters In admin, via the Studio, i create a new Multi choice Dropdown field under Accounts module, called list_test_c…
  • Some calculated fields does not change

    Hi guys ! I have a problem with my Opportunity module. So I have 2 custom fields: Category (which is a dropdown: H&S, ICT, TBD) and Reference (which is a calculated field). The reference is a mix of some other data, the thing is: for some reason it only…
  • Default values not working

    Hi, I am using SugarCRM version 7.5.2.3. I have set default value for a 'date' field as 'today'. But the field still shows only blank space. I have tried 'Quick repair and rebuild', cleared browser cache etc. But the issue still there. I have also tried…