Related fields and their values ​​managed by admin

[vandelft]

Hi guys,

I was chosen by a company, even thou they know i never worked with SugarCRM, to form a Case.

In this form, three of the fields must be pop-ups and will only be enabled when the first is chosen, and values ​​will be different every second choice and so on.
ie, a tree that each option has no options.
the values ​​of these fields must be managed through admim.

Has anyone done something like that?, Is this possible?

CAN SOMEONE GIVE ME A LIGHT?



Thank you.

vandelft

[ashdwi1]

Hello,
can you please elaborate requirement with an example.
as for as it is looking requirement of No Duplicates with popup fields dependency of another popup field.
please elaborate more , so that we can understand better.
thanks

[vandelft]

Hi ashdwi1, thank you for answering.

I will try to make myself more clear.


I have to customize this form on Support -> Cases;

In this form I must have three pop-up fields:
- Description of Problem ;
- Reason of case;
- Treatment of case;

for example:
Product with error: CD-ROM
Description of Problem: Product didn't pass quality control.
Reason of case: Reading error.
Treatment of case: Sent other product to client

On this form the three last fields must be chosen of an pop-up window just like when choosing a client.

the first window must have values:
- desc 1
- desc 2
- desc 3
...
- desc n

if i, for example, chose DESC 1 on the first window, the field "Reason of case" will be enabled to changes
with values:
- reason 1,1
- reason 1,2
- reason 1,3
...
- reason 1,n

if i chose DESC 2:
- reason 2,1
- reason 2,2
- reason 2,3
....
- reason 2,n

And so on

the same happens when I chose a reason. The "Treatment of case" is enabled and ready to change

All those values must be managed by a user through the admin panel.

I really hope I made myself clear.

Thank you so much

vandelft

[ashdwi1]

Yes, that was good elaboration and was clear in thoughts.
Well , this will going to be good Sugar knowlege as well.

First you need to create 3 modules ( I am not sure all 3 are needed to dependent relationships between description , reason and treatment , but for 3 different popups , 3 modules are needed)
i) Description
ii) Reason
iii) Treatment

from studio add a relate field for description , Reason , Treatment.

now you need to field definitions at editviewdefs.ph at metadata like wise

'displayParams' =>
array (
'initial_filter' => '&user_type_dd_advanced=PM',
),

please change user_type_dd_advanced to reason_name_advance and treatment_name_advanced .

thanks

[vandelft]

Hi ashdwi1,

I want to thank for all your help and the time you spent writing me the answer.

The part on the relation to the Case work like a charm... I mean, it's where it should be, but I still have some doubts about somethings.

mainly:

"now you need to field definitions at editviewdefs.ph at metadata like wise

'displayParams' =>
array (
'initial_filter' => '&user_type_dd_advanced=PM',
),

please change user_type_dd_advanced to reason_name_advance and treatment_name_advanced ."

what does that do...

My modules are called:

Causa_Reclamo
Dettagli_Reclamo
Trattamento_Reclamo

how would that be?

On the file editviewdefs.php:
$module_name = 'ath_Causa_Reclamo';



'displayParams' =>
array (
'initial_filter' => '&Causa_Reclamo_name_advanced=PM',
),

//please change user_type_dd_advanced to reason_name_advance and treatment_name_advanced .

$viewdefs[$module_name]['EditView'] = array(
'templateMeta' => array('maxColumns' => '2',
'widths' => array(
array('label' => '10', 'field' => '30'),
array('label' => '10', 'field' => '30')
),
),


'panels' =>array (
'default' =>
array (

array (
'name',
'assigned_user_name',
),

array (
'description',
),
),

),

);

How can I manage the values through the admin panel?

Thank you so much
vandelft