Populate asset value based on category, subcategory

xthrv
Tera Contributor

Hi Developers,
I've created a customized catalog form called 'Create an Incident' in which I have used variable 'requested for' which is referenced by sys_user table as category and subcategory which is reference to incident table and asset variable field which is referenced to alm_asset table. I want asset field to show only value assigned to requested for and we have one choice in category I.e., computer peripheral  similarly in subcategory we had 5 choice, keyboard, mouse, adapter, etc.
So based on category and subcategory select asset field value show assigned to requested for and category is computer peripheral and subcategory user selected.

xthrv_0-1704447186008.png

So my question is, how can we populate asset value based on category, subcategory and assigned to requested for?

1 REPLY 1

sachinbhasin11
Tera Guru
Tera Guru

your question seems a little confusing, basically you want assets to be shown based on category , sub category and requested for? 

 

Couple of ways to do this, but i think best would be right down the logic in a script include and then return that array onto this field based on the logic defined 

 

sachin_b_0-1704696619524.png