I want to create a task associated with a lead once that lead is added to a particular target list. At first glance, I see no way to achieve this using a workflow. So what would be the best method and place to create this function?

Hello. I'm using SugarCRM Enterprise Edition 7.5.2.4, using an "On Demand" instance. I developed a logic hook to the native module "RevenueLineItems", that is related to the module "Opportunities". The logic is: on creating a RevenueLineItem (here I will…

If any additional information is needed that would help you solve the problem, just let me know. I'm running SugarCRM 6.5.20 CE I have a logic hook that fires for a custom module and when I go to check the log, the query shows an execution time and appears…

Hi I am not able to add more than 40 product in quotes sugarcrm Enterprise 7.6. if I add forcefully then all product got deleted and quotes got crashed. is any limitation in quotes module for product. please help me out Thank you

Hello, I create a new action menu from account record menu ; this menu run a synchronization process that copy data to an external system. At the end of the process, my sugar webservice update the record to define or change some fields value (ie the last…

My code in Cases module hook: $sql = "select c.id from cases c left join emails e on e.parent_id = c.id and e.parent_type = 'Cases' left join emails_text et on et.email_id = e.id where c.id = '{$focus->id}' and et.to_addrs like '%_string_%'"; $result…

Hello, Having some concerns with calculated fields and the solution employed. Given : 2 modules , a date field date_vis on module B , a date field date_vis on module A and looking to update the date_vis of module A , set it up as calculated field in studio…

Hi, I use the translate function to get the label of a dropdown list. However, the result is truncated at 10 chars. $bean->region_c = "Lajemmerais"; $value = translate($bean->field_defs['region_c']['options'], '', $bean->region_c); $value will contain…

I mean uppercase all fields without having to go through this.. $bean->first_name = strtoupper($bean->first_name); $bean->last_name = strtoupper($bean->last_name ); $bean->address = strtoupper($bean->address ); $bean->gender = strtoupper($bean->gender…

Dear Sugar Experts, I have deleted an account record from my local SugarCRM. I have the below logic hook code for Accounts module: Logic Hook file location: /custom/modules/Accounts/logic_hooks.php <?php $hook_version = 1; $hook_array = array(); $hook_array…

Following various posts here I am trying to conditionally Show/Hide some panels on a record view using dependencies. I have tried the following but clearly have a problem as it is not working. IF someone can point out the error of my ways I would really…

I'm going crazy trying to copy one encrypted field into another one. All I've been able to find is the blowfishDecode() method (which works): blowfishDecode(blowfishGetKey('encrypt_field'), $clientBean->dl_num_c); So what's the opposite? What's a code…

Hi, I'm trying to create a calculated/concatenated field that pulls fields from related records and would like to have line breaks between the field values, not spaces? As an example, I'm trying to pull the contacts company address fields and the contacts…

Hi there, I'm refactoring a custom 'Multiple Attachments' field type. The user uploads files, via AJAX request to an API endpoint, while record is in 'edit' action. On 'cancel' ('cancelClicked' in 'record.js'), I need to remove those uploaded files again…

I've been encountering an issue when working with SugarCRM 7.6 On Demand (aka SaaS instance) in making a custom field auto-increment on every update. Since I can't access the code directly to modify Sugar's internals to create an auto-incremented field…

How to make Cases description readonly in editview after it has been save? TIA, Longki Dela Cruz

Hi, I was looking for a way to display a message or Alert after I save a record in sugar 7.x Which would be the best way to do it?

Hello, I have a need to query the DB for all products sold to a client then get the total. This then needs to be displayed in a field. I am using SugarCRM CE 6.5.13 I would greatly appreciate any assistance. Thanks.

Hello everyone, I am using SugarCRM CE 6.5.X version. I want to use the hashed value of the new password of a user, when user changes his password using after_save logic hook. I used $bean and get_all_vars(), but no help. I got new password in a plain…

Hi everyone I have a really big problem and can't find a solution yet, hope someone know what the issue might be. I have 4 Logic Hooks inside a custom module. logic_hooks.php <?php $hook_version = 1; $hook_array = Array(); $hook_array['after_relationship_add…

Hi all, i am facing a strange behaviour: my sugar logs are set to FATAL in administration panel configuration, i wrote a lot of custom code, which works well, in wich i log a lot of things (errors and other stuff) always using $GLOBALS['log']->fatal.…

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…

If the Leads is in particular status the users are not allow to create Cases from Leads subpanel ( the button '+' in subpanel) I can't hide the button but i have to show an alert. I am using SugarCRM pro 7.2 Thank you

The subject sorta sums up my question. Basically I want to be able to do any of the following: 1. Make a specific subpanel entry required after inserting a parent account. OR 2. Redirect to subpanel insert screen after inserting a parent account. Any…

Hi, I have seen in other threads where you can conditionally hide\show panels in a records Detail view. Is it possible to similarly control the visibility of Tabs in a records Detail view? I have seen from here http://support.sugarcrm.com/Documentation…