Auto-filling fields

[leowolff]

Using Sugar CE 5.2

Hello, I want to put a bunch of new fields (read only) of account (like adress, email, zip code) in a custom module, and once I fill the name of the account it will bring all the info related and complete the other fields.

What I dont know how to do is the autofill process once the main field (account name) is imputed.

Can anyone help me?

[andopes]

Hi Leo

You may add a code like that

             'displayParams' =>
            array (
              'field_to_name_array' => array(
                'id' => 'accounts_tenyaccounts_ida',
                'name' => 'accounts_test_company_name',
                'billing_address_street' => 'billing_address_street',
                'billing_address_city' => 'billing_address_city',
                'billing_address_state' => 'billing_address_state',
                'billing_address_country' => 'billing_address_country',
                'billing_address_postalcode' => 'billing_address_postalcode',
                'website' => 'website',
                'phone_office' => 'phone_office',
                'phone_fax' => 'phone_fax',
                'phone_alternate' => 'phone_alternate',
                'employees' => 'employees',
                'annual_revenue' => 'annual_revenue',
                'industry' => 'industry',
                'account_type' => 'account_type',
              ),
              'additionalFields' => array(
                'website' => 'website',
                'phone_office' => 'phone_office',
                'phone_fax' => 'phone_fax',
                'phone_alternate' => 'phone_alternate',
                'employees' => 'employees',
                'annual_revenue' => 'annual_revenue',
                'industry' => 'industry',
                'account_type' => 'account_type',
              ),
              'billingKey' => 'billing',
              'shippingKey' => 'shipping',
            ), 
  

into field defs on custom/modules/<ModuleName>/metadata/editviewdefs.php

Cheers

[leowolff]

Hey Andre, thanks for replying, just a bit confused, where is the main field on the code?That would show the dependence? In my case the account name, that once is filled will complete the others fileds.
Second, what are field_to_name_array and additionalFields on the code?
Another question, the fields on the custom modulo must be related type?

[leowolff]

Let me put a simple code example:

   'LBL_PANEL_CONTACT' => 
      array (
        0 => 
        array (
          0 => 
          array (
            'name' => 'company',
        'displayParams' => 
            array ( 'website' => 'website', 
              ), 
            'label' => 'LBL_COMPANY',
 
 
          ), 
  

What should I change to just show the website?

[andopes]

field_to_name_array will manage the fields to be automatically filled in when selecting a record from popup. Inside this array, the key represents the name of the field into source module (module into popup) and the value represents the field name into target module (module in editview).
additionalFields will manage the fields to be automatically filled in when selecting some record from ajax auto-completion.

Cheers

[leowolff]

So far so go, I made a few fields to work, thanks Andre.

[leowolff]

Hello Andre, could you enlight me the right place to fit the code?

     'LBL_PANEL_CONTACT' => 
      array (
        0 => 
        array (
          0 => 
          array (
            'displayParams' => 
            array ( 
              'field_to_name_array' => array( 
        'name' => 'company',
            'billing_address_street' => 'billing_address_street_c',
            'razaosocial_c' => 'razaosocial_c',
            'website' => 'website_c',
        ),
        ),
        'name' => 'company',
            'label' => 'LBL_COMPANY',
          ),
          1 => 
          array (
            'name' => 'website_c',
            'label' => 'LBL_WEBSITE',
          ),
        ),
        1 => 
        array (
          0 => 
          array (
            'name' => 'razaosocial_c',
            'label' => 'LBL_RAZAOSOCIAL',
          ),
          1 => 
          array (
            'name' => 'billing_address_street_c',
            'label' => 'LBL_BILLING_ADDRESS_STREET',
          ),
        ),
      ), 
  

Becuase right now I am getting an error on account name.

[johnius]

This is exactly what I want Sugar to do for me. I know absolutely nothing about coding, how to edit the .php files, or even where they are stored. I am also wondering if I can put a twist on this: I work in aviation. Every airport has at least one fuel vendor and some have more. I want to input the airport name and have options for that airport's fuel vendor in a drop down and have the drop down auto fill the contact details for that vendor. I would also like this to update in real time from the database (e.g. I am going to an airport I have not been to before, I want to be able to input the airport name and all information onto the same page I'm currently viewing or a new vendor opens and I need to add them to my vendor list for that airport).

Thanks for your help.
John

[andopes]

Hi Leo

Note the the account_name field is dupped.

Cheers

[leowolff]

Hello, just to let everyone knows, the function 'field_to_name_array' calls the file custom\modules\<Module>\metadata\popupdefs.php. So if you want to autofill a field from another module it must be in that file too, if its not there it will not bring it.

My problem was that I was unable to bring onwership, phone_office, website from account module. So I went to popupdefs.php and I add the the fields that I wanted to bring, like this:

'OWNERSHIP' => array(
'width' => '10',
'label' => 'LBL_OWNERSHIP',
'default' => false,
),

and it worked. I hope this info wil help more people out there.

Regards