Automatically display related information

[Diana Yazmin]

Hi experts,

We have a service form with a field that queries the assets in the alm_asset table (asset tag). How can we display associated asset information once the user selects the asset in other fields (invoice, company, contract, etc.)?

[AndersBGS]

Hi @Diana Yazmin ,

You could do it by an OnChange Client script. But I could also ask the question, why at all show the fields on the form if the user shouldn't fill them out. Isn't that?

[Diana Yazmin]

Hi,

To confirm that asset selected is the correct to created request.

[kaushal_snow]

@Diana Yazmin ,

I have replied it here: https://www.servicenow.com/community/itsm-forum/automatically-display-related-information/td-p/34519...

You can automatically display related asset information on a form once a user selects an asset (like asset tag) by writing a client script that reacts to the asset reference field change, uses g_form.getReference().....to fetch the selected asset’s record from the alm_asset/alm_hardware table, and then populates your other fields (invoice, company, contract, etc......) with the corresponding values so they appear right away on the form......by creating an onChange client script on the asset field that retrieves the referenced asset details and calls g_form.setValue() on the target fields with the data you want displayed.......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Ankur Bawiskar]

@Diana Yazmin 

is that field on form a reference to asset table?

if yes then you can use onChange client script to grab the other fields and populate

what did you start with and where are you stuck?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏