copy the value of a relate field, to other module

[garciasanchezdaniel]

hello friends, now my sugar is starting to like to me haha
I have other issue, I will try to explain it at the next image at the best way:

NOTE:The fields of the second module are of kind related to contacts

[andopes]

You can implement this code instead, so you can access the related values directaly.

 $first_module = loadBean('FirstModule');
$first_module->retrieve('first_module_id');
$this->field = $first_module->related_field; 
  

Cheers

[agcopley]

hello friends, now my sugar is starting to like to me haha
I have other issue, I will try to explain it at the next image at the best way:

NOTE:The fields of the second module are of kind related to contacts

Hola Daniel
Revisa esta entrada Blog
SugarCRM Developer Blog » Blog Archive » HOWTO: Using a relate field to populate a custom field

Slds
Andrew

[agcopley]

hello friends, now my sugar is starting to like to me haha
I have other issue, I will try to explain it at the next image at the best way:

NOTE:The fields of the second module are of kind related to contacts

Hola Daniel
Revisa esta entrada Blog
SugarCRM Developer Blog » Blog Archive » HOWTO: Using a relate field to populate a custom field

Slds
Andrew

[garciasanchezdaniel]

You can implement this code instead, so you can access the related values directaly.

 $first_module = loadBean('FirstModule');
$first_module->retrieve('first_module_id');
$this->field = $first_module->related_field; 
  

Cheers

I added this code firstly, and then appeared an error message that says that the function retrieve calls non a object.

 $contacts = loadBean('Contacts');
$contacts->retrieve($_REQUEST['id_contacto']);
$this->related_to_contactsr_c = $contacts->related_to_contactsr_c; 
  

So, next, I added this other, but nothing happensdoesn't appear any error message but all continues equal

 $contacts = new Contact();
$contacts = loadBean('Contacts');
$contacts->retrieve($_REQUEST['id_contacto']);
$this->related_to_contactsr_c = $contacts->related_to_contactsr_c; 
  

One question: I have realized that, next to create one relate field, in my table_cstm automatic have created two new fields:relatefield_id_c and relatefield_c.
But, it only inserting records in database in relatefield_id_c, not in relatefield_c. For this, I don't find the value in order to retrieve and save it
(as I do with the other fields of database, that contain the values that I need)

[garciasanchezdaniel]

Where the value of a related field is saved in database?

[garciasanchezdaniel]

Now it works, the value of the field of the first module is copied to the field of the second module,

but when I press the button save, appear: "no matches found for the field"

how can I solve this issue?

[garciasanchezdaniel]

Solved!! The issue was that id of the relate field wasn't been copied properly...I realized using firebug,
So, the fix was add to the code:

 $this->related_to_contactsr_id_c = $contacts->related_to_contactsr_id_c; 
  

In this way, the id of the relate field is copied, and I can save this new record withour introduce manually the relate field, instead is copied of the first module

Thanks so much

[garciasanchezdaniel]

Hello again, this question is for andopes:
is this piece of code secure? ,that is, can fail any times this code? specifically, loadBean()?
because I realized that, some times, it doesn't charge properly and then it appears a screen like this in the navigator:
(this happen with some records)

[Angel]

La verdad que nunca he usado loadBean() para poder comentar, pero si he hecho algo parecido varias veces, usando algo como esto:

require_once('modules/Contacts/Contact.php');
$contact = new Contact();
$contact->retrieve($contact_id);
$this->related_to_contactsr_c = $contacts->related_to_contactsr_c;
$contact->save();

Intentelo asi..