concantination of field values

Avee90
Tera Contributor

Hello, 

    I'm currently creating a catalog item. Item have choice 4 choice fields. Based on the choice field 1, choice field 2, choice field 3, field 4 should populate. I thought of using generic catalog data lookup table. I've concatenated a choice for field 1,  field 2 and field 3 ( Value field in generic catalog data lookup: field1choice;field2choice;field3choice).

If I match concatenated values from generic table to catalog variables then field 4 should populate. I'm new to script include how can I achieve this using Script Include and Catalog Client Script?

4 REPLIES 4

SANDEEP28
Mega Sage

@Avee90 Can you explain your requirement with example ? its not clear

Avee90
Tera Contributor

In the item screen short, I have 4 drop down fields, where 3 fields has values. So, based on the selection of 1,2 and 3, 4 field value should populate. 4 field has more than 100 values. So, instead of adding from script using g_form.addoption. I wanted to use a custom table which is generic one. setting 1, 2 and 3 values in variable field on custom table and giving value for 3 fields in VALUE field in custom. So, Here I'm trying to get 4 field choice value based on 3 fields using table and script include. How can I achieve this using script include

Ankur Bawiskar
Tera Patron
Tera Patron

@Avee90 

please share some screenshots.

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

In the item screen short, I have 4 drop down fields, where 3 fields has values. So, based on the selection of 1,2 and 3, 4 field value should populate. 4 field has more than 100 values. So, instead of adding from script using g_form.addoption. I wanted to use a custom table which is generic one. setting 1, 2 and 3 values in variable field on custom table and giving value for 3 fields in VALUE field in custom. So, Here I'm trying to get 4 field choice value based on 3 fields using table and script include. How can I achieve this using script include.