Questions tagged [sugarbean]

SugarBean is the base class for all business objects in Sugar CRM. It implements the primary functionality needed for manipulating business objects: create, retrieve, update, delete. It allows for searching and retrieving list of records. It allows for retrieving related objects (e.g. contacts related to a specific account).

SugarBean is the base class for all business objects in Sugar CRM. It implements the primary functionality needed for manipulating business objects: create, retrieve, update, delete. It allows for searching and retrieving list of records. It allows for retrieving related objects (e.g. contacts related to a specific account).

53 questions
1
vote
1 answer

SugarCRM How to save multiple record using before_save logic

When I am trying to save multiple record in the following way: public function generateName($bean, $event, $arguments) { $record_id = $bean->id; $module="PNGM_AI_Projects"; $mybean =…
1
vote
2 answers

Joining two SugarCRM modules on linked field using SugarQuery()

Background and Context I am attempting to create a custom REST module in SugarCRM 8.0 that joins two modules on a linked field. The two modules are; Accounts ( a OOTB module ) ConsumerLeads ( a custom module ) These two modules are a linked field…
Chris Maggiulli
  • 3,375
  • 26
  • 39
1
vote
0 answers

Add validation to duplicate value in suitecrm

I want to add a custom validation to first name and last name field to avoid duplicate values i tried following this example link but its not working for me. Is there any experts who knows other ways to do this ?
s0m3d3v
  • 177
  • 1
  • 13
1
vote
0 answers

Product Catalogue side pane loads the entire data while adding the line item?

We have upgraded to sugar 8.0. In that, as a new feature, we have a product catalogue dashlet in the sidebar to add line item directly to quotes on the quote create view. Now if I click on the record in the product catalogue it loads the entire…
Parithiban
  • 1,656
  • 11
  • 16
1
vote
1 answer

SugarCRM 6.5.26 CE - contacts export using SugarBean [php]

I've got SugarCrm plugin which is exporting data to external service. I'm using logic hooks for updated/deleted/new Contacts, but I've got problem with synchronizing already existing data. I have to extract all the data from the SugarCRM and there…
maciey_b
  • 147
  • 1
  • 11
1
vote
1 answer

Sugarcrm module Subpanel create dosent trigger hook

I am working in the hook. When I create a record from subpanel it doesn't trigger the hook. But when I use link existing record the hook is executing. Which hook should we use when create from a subpanel. $hook_array['after_relationship_add'][] =…
DonOfDen
  • 3,968
  • 11
  • 62
  • 112
1
vote
1 answer

Want to get the html for pdf template from PDF manager(Sugar 7.6)

I want to get the html of pdf manager using bean. I know how to get the html for email template but unable to get the html for pdf template which u build in pdf manager. $template = new EmailTemplate(); …
anila
  • 119
  • 2
  • 3
  • 8
1
vote
1 answer

sugarcrm display field in editview based on value in user details

I am trying to display a field in editview alone based on a fieldvale in userdetails. Ex: For an user can_add_no will be in user details, if it is checked than that particular user can add a quote_extra_no in quote module. I tried the following.…
DonOfDen
  • 3,968
  • 11
  • 62
  • 112
1
vote
1 answer

SugarCRM Field Calculation example of ifElse

I am new to SugarCRM. I have a requirement to calculate a field value through studio. But, in one of the fields which comes in denominator can be 0. So, i want to modify the formula through ifElse, how to do that. Example - If…
Atul kumar singh
  • 454
  • 10
  • 24
1
vote
1 answer

Sugar query equals method in sugar CRM

I have one to many relationship in two tables. I want to fetch records based on equals values (of specific field) in both the tables. Right now I am doing it like this $queryProspects = new…
user6344444
1
vote
2 answers

Sugar query syntax error in SugarCRM

I am trying to join table prospects with leads. I am executing this query $queryProspects = new SugarQuery(); $queryProspects->from(BeanFactory::getBean('Prospects')); $leads =…
user6344444
1
vote
3 answers

Retrieve SugarCRM employee emails

I'm writing some code for sugarCRM, and I'd like to notify employees via email. I'm using the active record model to get employees, but their emails are nowhere to be found. $employees = BeanFactory::getBean('Employees')->get_full_list(); How do I…
Derrek Bertrand
  • 596
  • 7
  • 13
1
vote
1 answer

Lead Save Database Error In SuiteCRM

I've created a Logic Hook within the Leads module to save to a field in the database. The problem is that when I save the Lead first it displays a duplicate message: Database failure error check SuiteCRM logs. If I comment out this code the Lead…
Anuradha
  • 69
  • 8
1
vote
1 answer

How can I get a subtotal by looping. Using SugarCRM CE 6.5.13

I am trying to get a total from the rows returned for the selected opportunity. When a opportunity is selected each product they have purchased and its price is listed. I am trying to use the price for each purchased product to get a subtotal for…
Damund
  • 75
  • 11
1
vote
1 answer

Can't Relate Contact and Opportunity in SuiteCRM / SugarCRM CE

I'm working on a script to import data into SuiteCRM / SugarCRM CE. I need to create a Contact and an Opportunity. I then need to relate the two. I have a many to many relationship between Contacts and Opportunities. Each contact should be able to…
Matthew Jones
  • 197
  • 1
  • 10