question Re: Show Dependent question in GRC forum

Show Dependent question

harinya — Mon, 07 Apr 2025 03:54:51 GMT

Hi,
can someone please help i need to show one dependent question when it's above question was answered as partial/complete, that system needs to check other table data( central table asset field has specific value) in smart assessment form please help i am new to GRC

Re: Show Dependent question

Ankur Bawiskar — Mon, 07 Apr 2025 03:56:01 GMT

@harinya

sorry your requirement is not clear. please share some more details along with screenshots.

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

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 04:03:15 GMT

@Ankur Bawiskar Thanks for Response

On the Assessment Form, I need to display a dependent question when the following conditions are met:

The answer to a specific question is Partial or Complete.
The dependent question should only be shown if, in another table (which contains an asset field), the central solution value is Onboarded. The asset field in this table corresponds to the instance ID field in the Business Application table.

How can I implement this logic to check data in the other table and display the dependent question dynamically on the Assessment Form?

Re: Show Dependent question

Ankur Bawiskar — Mon, 07 Apr 2025 04:12:43 GMT

@harinya

you cannot make this much dynamic logic to show/hide the survey question

I have posted a workaround for something like this in below link and it is working fine, see if it works for you, please enhance further

How can we show incident reference field to filtered incidents where they are the requested for / requested by on survey .

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

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 04:19:09 GMT

gone through link but seems above is not relevant to my case , here i need to show dependent question as the text field not any reference field

Re: Show Dependent question

Kieran Anson — Mon, 07 Apr 2025 04:45:40 GMT

Hi @harinya ,

Within the Assessment Workspace designer, you can only make questions conditionally visible based on other questions. So you could show your question if the answer to a previous question is Partial or Complete. But not based on a table lookup; which is what I'm assuming you're wanting for question 2.

Question visibility is set via the additional attributes menu

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 04:53:11 GMT

Thanks for Response , yes we can show a question based on previous answers but here we need to check the other table data, i have tried with created a text question and using the automate response trying to create the script seems that also not working
will it work please help
by gliding the business app table and central solution table

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 05:07:34 GMT

try {

} catch (error) {
gs.error("Error in Automated Response Script: " + error.message);
return false; // Return false in case of errors
}

Re: Show Dependent question

Ankur Bawiskar — Mon, 07 Apr 2025 05:05:57 GMT

@harinya

then it's not possible to call any script include etc

You can simply show/hide based on previous survey questions.

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

Re: Show Dependent question

Kieran Anson — Mon, 07 Apr 2025 05:21:53 GMT

Ah, good idea to use the automated response feature!

In combination to using the script, have you used that with the condition builder?

So your If/then condition would invoke the automate response when a previous question is the partial/complete answer you desire

Can you share a screenshot of your current automatic response setup (of the modal that appears)

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 07:33:25 GMT

@Kieran Anson
But i don't see the if /Then conditions in the automated Response

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 09:20:58 GMT

HI @Ankur Bawiskar , @Kieran Anson
Can you please help to glide the table central solution table data and that Asset value is onboarded or not

try {
// Step 1: Query the Central Solution Table
var centralSolutionGr = new GlideRecord('central_solution_table'); // Replace with the actual Central Solution table name
centralSolutionGr.query();

while (centralSolutionGr.next()) {
// Get the asset field from the Central Solution Table
var asset = centralSolutionGr.getValue('asset'); // Replace 'asset' with the actual field name

if (asset) {
// Step 2: Query the Business Application Table using the asset as the Instance ID
var businessAppGr = new GlideRecord('business_application_table'); // Replace with the actual Business Application table name
businessAppGr.addQuery('instance_id', asset); // Replace 'instance_id' with the correct field name in the Business Application Table
businessAppGr.query();

if (businessAppGr.next()) {
// Found a match: Business Application Instance ID matches Central Solution Asset
gs.info('Match Found: Central Solution Asset = ' + asset + ', Business Application Instance ID = ' + businessAppGr.getValue('instance_id'));

// Step 3: Check if the asset is "Onboarded" and update the created text field
if (asset === 'Onboarded') {
centralSolutionGr.setValue('created_text_field', 'Asset is Onboarded'); // Replace 'created_text_field' with the correct text field name
centralSolutionGr.update(); // Save the record with the updated value
gs.info('Updated created text field for Central Solution Asset: ' + asset);
}
} else {
// Log if no match is found in Business Application Table
gs.info('No match found for Asset: ' + asset + ' in Business Application Table');
}
}
}

} catch (error) {
// Log any errors for debugging purposes
gs.error('Error in script: ' + error.message);
}
will this work

Re: Show Dependent question

harinya — Mon, 07 Apr 2025 09:22:34 GMT

Automate Response will give default Answer, i didn't get that answer how will show
not able see if and Then cond also
please help on this

Re: Show Dependent question

Kieran Anson — Tue, 08 Apr 2025 03:30:56 GMT

You can see this functionality is shown in the docs: https://www.servicenow.com/docs/csh?topicname=automate-response.html&version=latest

If you're not seeing the option, upgrade the plugin/store app and if that fails, speak with ServiceNow Support