• What is the best practice to add a database index to a custom table?

    I want to add indexes to a custom table (to speed up reports) but is there an upgrade-safe (and rebuiild safe!) way to do this? i.e. is there a way to add a php file to define the index?
  • Custom Field Location

    Hello Everyone! Can you help me? I'm just working on custom query for Leads Module. My problem is I can't find all the custom field we use and also the email field. Where or what table name does custom field belongs? and why email field is not included…
  • How can I display fields from one module on the create and detail view screens of another module?

    In the module builder level, I have created three modules. We are using the SugarCRM sidecar method to display the modules. Module 1: Contracts Fields: Name, Email, Mobile Module 2: Contracts_Sales Fields: Sales_person_name, Sales_company, Sales_email…
  • Database failure. Please refer to sugarcrm.log for details in SugarCRM Professional 11.05

    Good Day! I have a problem with creating fields because I am unable to create columns in the database due to the error I encounter every time I finish the Quick Repair and Rebuild. Check the error logs below: Fri Jan 20 01:26:13 2023 [1447][1][ALERT…
  • What is the right way to add a custom badge

    I have a flag on Accounts for Partnerships and want to show a custom badge near the name of the record, in a similar way to Converted Leads. I was able to get this done in a very roundabout way, which I am pretty sure is not the right way... so I…
  • How to add a custom button into the footer on SugarCRM Sell UI ?

    We are a system integrator and custom software development service provider for the Customer Relationship Management space. Currently, we are building an application for SugarCRM salespersons. We need to customize the SugarSell UI by adding a new button…
  • this.context.parent.get('model') missing columns from model

    I have a custom model. currently in record view and subpanel when I click to add new subpanel row it retrieves the model. from backend I can see all the new columns which I have added but on the front end they are missing? How can I get it to not be missing…
  • Showing timeout while trying to search on custom field

    Hi All, I created and deployed a custom field through Studio and when I trying to search the particular custom field in the list view it seems to be timeout. How can I solve this issue ?
  • Create custom field just like tag

    Hi. I am trying to create a new field just like "tag" under the Account module. I created the field via studio under the "Account" module. My new field name is "auto_name_c" and the field type is "multi-select". In the multi select i selected "drop down…
  • Custom field in Global Search not show in list view

    Hi, I tried to add custom field brand_c to Global Search but it not show in a list view, it will show after click preview in full Global Search page. Screenshot: field brand_c and status are already in Studio > Leads > Layouts > Search in Default column…
  • Custom Field - Mobile - Problem

    Guys, I created a new type of field has been implemented in Desktop version correctly , but is not visible on the mobile version , there is some code that should be implemented more ? I follow the tutorial below , but it seems that something is missing…
  • How do can I get a field from the current user in an entry point?

    Greetings, I added a custom field to the Users and through research I found out that I can get that field by using something like: <?php global $current_user ; $fieldData = $current_user - > my_field_c ; I tested this out on my local instance and it worked…
  • create custom field in sugarcrm database and get that value using REST

    Hi I just created a custom field in in database(in user table, i don't know it is good way or not), now i want to get the custom field value using REST api,all value are retrieving except my custom field. Below is my rest api params $get_entries_parameters…
  • Custom Fields Are Not Showing After Deployment

    I've added some new fields to a custom module within my development environment. I've tested it and it works. I pushed it up to my Git repository and then pulled down those changes within my staging environment. When I try to edit/create one of these…
  • where to find table for custom field in a custom module?

    I created a custom field inside a custom module, The custom field is working as expected and changes were made to its value when I edit it inside the edit part of the module for testing. But what I want to do is to update the value of the custom field…