Hi All, I have one custom subpanel in contacts module. All the record values for that subpanel are coming from other services using REST API's and also we are not saving those records in DB as well. I have overridden the filterRelated function in clients…

Hi Everyone, I'm looking for a way of capturing the Change Event within the Quote Stage Drop Down list on the Quote Record List i.e. www.example.com/#Quotes I have been able to successfully detect the change using the hasChanged method ie.: self . model…

Hi All I have a requirement of list the Accounts module details in an custom module and filters out the data. How to Create a custom module that fetch details from the Accounts module table in the same database ?

Hi everyone, We have a customer (on-site) using Ent 9.0.3, who must have their Tracker function in Sugar turned off (for compliance reasons). Using the checkboxes in Admin > Tracker doesn't stop the tracker from running. You can test yourself, it's still…

I just want to search by the TO address to see all emails that came in to a specific sales person. I cant seem to do it in either the ListView or a report. Has anyone ever successfully done this. I am thinking about adding my own relationship but I am…

Hello Everyone, I am working on SugarCRM Enterprise, Version 9.2.0-dev.1 (Build 120) (Fall '19). I have to remove Global team from all the records which I have in SugarCRM all modules. Earlier I was thinking about deleting team id of Global Team (i.e…

Hi All, I am Trying to create New Custom field same Beauvoir default comment log filed sugar crm 9.x. any one any idea for how to create new custom comment log filed in module.... Thanks

Hello, I want to improved the Contact subpanel for the account's module, by including an additionnal CSS property to highlight contact that do not "work" anymore for the account, ie the contacts marked as not primary in the relationship accounts_contacts…

I am working with Sugarcrm 8 ENT versdion, I want to display values from external ERP as a Sub panel in Accounts module. How can display legacy/external database table values in Accounts module subpanel.

Hi, currently we have an environment that the customer wants to have opportunities with revenue line items enabled. So what I naturaly did was to enable the subpanel en module in de administration and on top of that changed the opportunity settings to…

Hello all, We are encountering an issue when we append a dynamic link ($link) in Email > Email Templates in SugarCRM. The $link contains a custom link generated from a logic. However, when we hover on it, it shows and opens as http://crm.com/$link . We…

I need to run a script when an item is Saved on the Quote. So you pick a product from the dashlet, it is added to the SubPanel and then you click on the green button to save it. As it is saved I need to check its 'product_template_id' and if it is one…

I might be wrong but ever since the change over to Prepared Statements the queries from errors or slow queries in the logs have been difficult to use at best. I have had to manually reconstruct more than a few queries. Maybe there is a tool out there…

Say you had a custom field called "agent_type" so you have a directory called custom/clients/base/fields/agent_type and that directory has agent_type.js in it. Now in that script it preforms some sort of check on the data in this field, say a duplicate…

Hi All, How can I test logic hook functions using PHPUnit test. Please help me create PHP unit test for Sugar 8

I want to add a validation to make sure the email address added to a record is unique. This, of course, requires an API call to go check the current email address to all the others. The problem is, in my validation function, by the time the API call returns…

How To save date and time value in date and time field in sugarcrm using before save logic hook ?

I’m wondering about the utility of maintaining both leads and contacts. Up until now the system had 2 modules leads and contacts (contacts essentially being a copy of a lead that has converted), but I’m starting to doubt that we really need this. Leads…

How To create Custom Action In 9.X Like 6.5.

How can I create OAuth keys for a particular user ? Please help me to find a solution to create OAuth key for an particular user

Hi guys, I have a question...is there anyway to create an Advanced Report for information logged into a meeting for instance? I am trying to create a Custom Query to select the data entered into a meeting but I can't seem to gather the information to…

How We can global manage holiday calendar and business hours in sugarcrm 9.X EP

Hi All, Related to data security I need to encrypt data while at rest,How can I apply this ?

How to change the background color of records in a list view according to the Status ??

How to know in before save or after save logic hook data insert through api or sugarcrm application. ..?