Cumulative fields (like post address)

[Monkeyman]

How can I create cumulative fields like default post address field?
I mean, when I create 3 fields and their values display with given order in the 4th field.

For example, there are 3 fields:

F1: Dude,
F2: is my car?
F3: where

And 4th field displays it in order F1+F3+F2 which gives us:

F4: Dude where is my car?

[FishGuts]

Hi,

Maybe you could try creating a logic hook. That's what I did the other day, and it worked! I had the same issue - I needed to set the value of a field by concatenating the values of two other fields. So here's what I did:

1. Created the file custom/modules/ModuleName/SetField.php, containing the code:

 <?php
require_once('data/SugarBean.php');
require_once('include/utils.php');
class SetField {
    function setField(&$bean, $event, $arguments) {
        $new_value = $bean->field1 . '  ' . $bean->field2;
        $bean->field3 = $new_value;
    }
}
?>  

2. Created the file custom/modules/ModuleName/logic_hooks.php, containing the code:

 <?php
$hook_version = 1;
$hook_array = Array();
$hook_array['before_save'] = Array();
$hook_array['before_save'][] = Array(1, 'setField', 'custom/modules/ModuleName/SetField.php','SetField', 'setField');
?>  

This solution doesn't set 'field3' while you're typing field1 and field2; it waits until you click Save. It's a 'before_save' logic hook. The Sugar Developer Guide describes all the other types of logic hooks available.

I hope this all helps.

AG

[Monkeyman]

That's great! Thatnk you very much!
Worked perfect for me.

[Monkeyman]

Found a small problem with that. If you have a dropdown menu, then chosen value is being added, not label as needed.

For example, I have a dropdown country list translated to German. If I choose "Russland" in list, it'll add "RUSSIA" in cumulative field since it's a value.

How can I make it add labels, not values?