How to make multiple field references

Arthur Sanchez
Giga Guru

Captura de tela 2024-04-18 151711.pngThe Area field has the options:

ti and seg: IT in the field system: APP, BRM, CAPTA, GPP

SEG in the system field: SMS, IMS, ACS

 

Now the problem is, I need to reference it multiple times, so when the Area field is selected the following are presented in the Service Type field:

 

TI

  1. Configuration
  2. Maintenance
  3. Customization
  4. Installation
  5. Consulting
  6. Backup and Recovery
  7. Training
  8. Request

 

SEG

  1. Configuration
  2. Maintenance
  3. Backup and Recovery
  4. Training
  5. Request
  6. Incident

some fields are repeated and so I am unable to reference them, the first reference I did this way

Captura de tela 2024-04-18 152520.png

 

1 ACCEPTED SOLUTION

Start with creating a new Script Include; for that open module "System Definition ↳ Script Includes":

6.png

 Make sure there is no script include named "Tickets" already (in scope Tickets Register):

7.png

Start the creation of a new record by clicking New.

In the new Script Include record set fields:

  • Name to Tickets
  • Script to
    var Tickets = Class.create();
    
    Tickets.prototype = {
    
    	'initialize': function () {
    		this._dependentValue = typeof dependent_value == 'undefined' ? '' : dependent_value;
    		this._sessionLanguage = 'en'; // gs.getSession().getLanguage();
    	},
    
    	'getSericeTypesForArea': function () {
    		return this._getChoiceList();
    	},
    
    	'type': 'Tickets',
    
    	'_addRecordToChoice': function (glideChoiceList, record) {
    		glideChoiceList.add(record.value, record.label);
    		return glideChoiceList;
    	},
    
    	'_getChoiceList': function () {
    		return new GlideQuery('sys_choice')
    			.where('name', 'x_1316384_tickets_tickets')
    			.where('element', 'service_type')
    			.where('language', this._sessionLanguage)
    			.where('inactive', false)
    			.where('dependent_value', 'CONTAINS', this._dependentValue)
    			.limit(999)
    			.orderBy('sequence')
    			.select(['label', 'value'])
    			.reduce(this._addRecordToChoice, new GlideChoiceList());
    	},
    
    };​

Save the record.

Open up the dictionary record for field "Service type"; switch view to Advanced, otherwise field Attributes will not be displayed:8.png

Modify field Attributes by adding text:

choice_script=new Tickets().getSericeTypesForArea()

 

 

like this:9.png

If there is some text in there already, place a comma between the existing and the new text.
E.g: if it already contains:

edge_encryption_enabled=true

like this:

10.png

the value for Attributes will become:

edge_encryption_enabled=true,choice_script=new Tickets().getSericeTypesForArea()

like this:11.png

That's all there is to it.

Now for each choice for field "Service Type" you have to update field "Dependent value".

In case of "Service Type" choices that should only show for "Area" ti, the value in "Dependent value" should be ti (not ti,seg).

In case of "Service Type" choices that should only show for "Area" seg, the value in "Dependent value" should be seg (not ti,seg).

In case of "Service Type" choices that should show for both "Area" choices, the value in "Dependent value" should be ti,seg as is now.

Of course should you add more "Area" choices, you would just add it to the "Dependent value" as needed.

 

View solution in original post

15 REPLIES 15

Maybe you need to mimic adding users to groups as seen on the 'sys_user_group' form. Where records in the sys_user table, along with group data is stored in the sys_user_gr_member table. the form shows those in a Related list. You could include a similar custom table and use form configuration (related list) and business rule (for ex.) to create and maintain records in that table to reflect the desired 'choices' for the desired fields. (Seems previous posts haven't helped you.)