Dynamically Populate Dropdown in Record Producer Based on Selected Table

TEJAS · ‎03-19-2025

Hi All,
Hope you are doing well,

Description:

I have created a Record Producer and need help dynamically populating a dropdown field based on the selected table.

Variables in the Record Producer:

Table Name (Variable Name: table_name)
- Type: Reference
- Reference: sys_db_object (Tables)
- Only specific tables should be visible its working.
Condition Fields (Variable Name: condition_fields)
- Type: Select Box
- Requirement:
  - When a user selects a table from the Table Name dropdown, the Condition Fields dropdown should dynamically populate the fields of the selected table.
  - This should happen using an onChange Client Script.
    
    IMP: one more thing this is done in other scope not in global scope
    Thanks in advance

GopikaP · ‎03-19-2025

Hi @TEJAS ,

Create an onChange Client Script on master table -

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    //Type appropriate comment here, and begin script below
	var table = g_form.getReference('master_table');
    var ga = new GlideAjax('ClientSideCall');
    ga.addParam('sysparm_name', 'getFieldName');
    ga.addParam('sysparm_tableName',table.name);
    ga.getXML(getFields);
    function getFields(response) {
        var answer = response.responseXML.documentElement.getAttribute("answer");
        alert(answer);
        var fields = answer.split(',');
        for (var i = 0; i < fields.length; i++) {
            g_form.addOption('select_fields', i, fields[i]);
        }
    }
}

Create a Glide AJAX enabled script include -

var ClientSideCall = Class.create();
ClientSideCall.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    getFieldName: function() {
        var fields = [];
        var tableName = this.getParameter('sysparm_tableName');
		gs.log("Hi "+JSON.stringify(tableName));
        var getFieldNames = new GlideRecord('sys_dictionary');
        getFieldNames.addQuery('name', tableName);
        getFieldNames.query();
        while (getFieldNames.next()) {
            fields.push(getFieldNames.getValue('column_label'));
        }
		gs.log("Hi "+fields);
        fields = fields.join(',');
        return fields;
    },
    type: 'ClientSideCall'
});

View solution in original post

TEJAS · ‎03-19-2025

Sorry for the problem

Table Name (Variable Name: Table_Name)
it is Table_Name
and one more thing now i saw i am getting this error in the onchange client script

GopikaP · ‎03-20-2025

Hi @TEJAS , did you do any kind of debugging, any brackets left out? I am not able to reproduce the error in my instance.

TEJAS · ‎03-20-2025

Now i am getting
Thank @GopikaP

Ankur Bawiskar · ‎03-19-2025

@TEJAS

so please share what script did you start with?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ankur Bawiskar · ‎03-19-2025

@TEJAS

why not use Reference field to sys_dictionary and show the fields based on above table selected?

It's not a good user experience to show 100 fields if that table has 100 fields

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader