Establishing Field Dependency in ServiceDesk Plus Using CSV Data and Field/Form Rules

Establishing Field Dependency in ServiceDesk Plus Using CSV Data and Field/Form Rules

This Knowledge Base article outlines the process of establishing field dependency in ServiceDesk Plus using CSV data and Field/Form Rules. By following these steps, administrators can enhance the flexibility and efficiency of form interactions, leading to better service delivery and user satisfaction.

Usecase:
Assume, a request template includes four additional fields: 'Zone,' 'Region' and 'District' and 'Cluster'. When a pick-list value for the 'Zone' field is selected, the corresponding field values for the 'Region', 'District' and 'Cluster' data must be dynamically populated by retrieving it from an externally stored CSV file. This will be useful when the number of field values increases.

Steps to follow:
1.  Create 4 Additional fields and include these in the required template
  1. Zone - Single line additional field - Content will be populated from the CSV file as a Picklist value.
  2. Region - Single line additional field - Content will be populated from the CSV file as a Picklist value.
  3. District - Single line additional field - Content will be populated from the CSV file as a Picklist value.
  4. Cluster - Single line additional field - Content will be populated from the CSV file as a Picklist value.
2.  Compose a CSV file with first column as the "Zone", then "Region", then 'District' and finally "Cluster".   Place this CSV File in "<SDP_Home>\custom" Folder

3.  Download the attached script and update the UDF Field names & CSV file headers in the script.

UDF Field Names can be taken from the FAFR window itself, type in the Field Label and you will get the respective Field Name.


4. Set up the script to execute On Form Load. The designated single-line fields will transform into picklists according to the user's selection.

If you are still unable to view the file despite retaining it in the custom folder, replace the attached security xml in location: <SDP_Home>\custom\WEB-INF\security folder

Included with this article are scripts for 3-field dependency, 4-field dependency, and 5-field dependency. Ensure that the required additional fields and their respective scripts are utilized accordingly.

                    New to ADSelfService Plus?

                      • Related Articles

                      • How to update Request Additional fields during request create/update using Business Rules

                        This is a sample python script to update the Request Additional Field Values during request create/update based on certain criteria using Business Rules Execution Steps:  1. Download the attached zip 2. Move the files to ...
                      • How to migrate ServiceDesk Plus from one server to another

                        Following are the steps to move data from the existing server to a new server, Step 1: Stop ManageEngine ServiceDesk Plus service. Step 2: Kindly Upgrade ServiceDesk Plus if required. Refer to the link below to check if you are in the latest version, ...
                      • Host ServiceDesk Plus on the Internet

                        In order to make ServiceDesk Plus available for users on Internet, let us assume the following scenarios. Scenario 1: ServiceDesk Plus is installed in LAN and should be available in LAN and WAN: Assume ServiceDesk Plus is installed on a server in the ...
                      • ServiceDesk Plus On Premise : Integrate with ServiceNow using Zoho Flow

                        This document will guide you through the steps to integrate ServiceDesk Plus with ServiceNow upon Zoho Flow. The pre-requisites for this integration : Make sure the Zoho Flow Agent is up and running in the machine in which the ServiceDesk Plus server ...
                      • How to restore your data in ServiceDesk Plus

                        1. Stop the ManageEngine ServiceDesk Plus service from the Services console(services.msc).   2. Click the Windows icon and select Command Prompt (Admin).   3. Go to Bin directory and run restoreData.bat   4.Browse to the backup file from backup ...