Uplift Group decommission form to check for active records

[Passion_of_SNOW]

We have a catalog to request for group deactivation in our service portal. I am wondering if it is possible to show the number of tasks, services (CMDB_CIs) mapped to the assignment group when user enters the group name in the reference field. Something like this - 

Is it possible to achieve it without scripting? 

[Runjay Patel]

Hi @Passion_of_SNOW ,

you can write Onchange client script and call script include. In script include write 2 glide record and get count from both table.

One run on task table and check assignments group to get the count. This will give you tickets count.

2nd run on cmdb_ci table and check support group , this will give you count for all ci .

Now return both count and display in client script.

Accept the solution if it helped.