We recently upgraded MySQL from version 5.7 to 8.0.41. Post-upgrade, we have observed a noticeable improvement in overall query performance. However, we are encountering a significant performance issue, specifically when accessing list views in modules…

It turns out that Sugar does not enforce 1:1 relationships, it overwrites them with no warning to the user. (Bug?) Is my only option for enforcement a custom before-relationship-add logic hook? Thanks, Francesca

Hi All, I have a column named Date. I want to extract quarter from date, but as per our business logic if Date is in the year 2024 and in the month of March and feb it is Q0 and year 2024 and Apr,May,June Q1, and year 2024 July and august is in Q2, year…

1) Is it possible to upload a csv file on sftp via php code inside SugarCloud? 2) Is it possible to get the csv file from sftp server via php code inside SugarCloud. Second question is similar to connect sftp and get csv file from folder and then…

Hi, We have created a custom view / dashlet which is loaded on the side of our create view to perform checks and give suggestions when creating a record of a custom module. In this dashlet I want to add a relate field so I can adjust my logic based…

Dear All, I want to customized Some input received in Sugar by Default API . How can I customized if ? And Also share the path of default API in SugarCRM used. For Example :- I have share a case crate API with portal user and I received regularly in…

Dear Team, I have Upgraded our sugar CRM 11.0.6 to 12.0.3 & we are Getting CRM after login screen ( HTTP: 500 Internal Server Error Invalid subscription json data ) Please help what can i do for this issue

Hello folks, The modal is functioning in Sugar Ent Version 13.0.2 but is not working for 14.0.0. Using the following code: custom\Extension\application\Ext\JSGroupings\new_js_grouping.php $js_groupings[] = $sugar_grp_sidecar = array_merge( …

Hello, Since the last update to 13.3.0 one of our pages lost the ability to scroll. To fix this, I tried to add a custom.less file to the custom/theme folder as stated in the documents with simple styling *{ overflow:scroll } and I uploaded it to the…

Is there a best way to get a count of all documents/task etc . Like is there a URL endpoint we can just call that's like documents/count?

Hi All, I have below scenario where I need help/suggestion how we can customize Studio created Action Button functionality. In the Case module of SugarCRM, I've implemented two action buttons from studio: (1) "Complete" and (2) "Cancel." Each Case…

Hey Dear, Using a silent upgrade method, I have successfully upgraded SugarCRM from version 12.0.3 to 13.0.2. However, when I attempt to access it via the URL, the login page is not displaying. Upon further investigation, I noticed that several files…

Hi All, Query 1: Can anyone suggest how to import meeting attendees/guest/participants though CSv file? Please share template if you have. Query 2: In meeting import how to skip Meeting Duration and Minute field, but at the same it should…

I am not able to find the Rest API endpoint for the Product catalog. Please help me with this.

Hi All, We have process definations and now some users we have marked as inactive. So if any new lead is created the we are sending email to assigned to user but email sent with TO blank even though there was email address. can anyone suggest…

Hi all, I need suggestions on how to display inactive users in all modules assigned to fields and all fields which are related to users module. Please suggest on urgent basis. Kindest Regards, Shreya

Hello Folks I am trying to use ExternalResourceClient Instead of PHP Curl. But not able to get the results. I have gone through the below link and other questions on Sugarclub. (+) Introducing ExternalResourceClient your friendly Transport Client…

Hi All, I have one use case, as a sugarcrm user if I am creating meeting for converted lead then system should display error popup message "meeting cannot be created for converted prospect." on meeting create view in sugarcrm Mobile app. Can anyone…

Anyone know how to create a combined field in a layout? I am trying to add an address to a layout and would like to turn it into a combined field.

Hi All, Sugarcrm version : 13.0.0 I have created custom Scheduler and its running properly but in custom Scheduler (module=Schedulers) -> Job Log it throws some warnings which I am not getting what might be the root cause for the same: " …

HI All, Can anyone suggest why I am getting below error when working with document module. " Warning [2]: stat(): stat failed for upload/a9c/04ebda9c-4c31-11e7-a5d1-0250d4f82a21 in /13.1.0/ent/include/upload_file.php on line 1022 Warning [2]: stat…

Is it possible to create a relationship based on another relationship? For example, in Opportunities I need to add two Contact relationships to track both Commercial and Technical contacts for an Account, but I need to limit the ability to select the…

Hi, I have created a new custom module. After a successful deployment, navigate to "Navigation Bar and Subpanels" where I need to manually move it from "Hidden" to "Display." However, I want it to be displayed automatically after a successful deployment…

$("input[name=name]").val('test'); when applying the value using Jquery. then after clicking the save button value is automatically erased and throws the required error message.

Hello, how can I edit the listed modules in the Record View Dashlet? Many Thanks in advance, Theresa