Show location based on region

Anna_Servicenow · ‎11-26-2022

I have 2 fields in service portal, location and region. Location refers cmn_location table and region has 5 choice.

If i select region(say ASIA) it should show all asian region location in cmn_location field. How to achieve this

Saurav11 · ‎11-26-2022

Hello,

Is region also a field on cmn_location and are the values same for region field on location table and region varibales if yes then in the location variable please use the below code in the reference qualifier:-

javascript&colon;'replaceregionfield='+current.varibales.replaceregionvaribalename

Please mark my answer as correct based on Impact.

View solution in original post

Saurav11 · ‎11-27-2022

As I said the reference qualifier should work did you try?

Anna_Servicenow · ‎11-27-2022

I made a change that the region is not coming from location table but from the select box variable that i created, the select box variable has 5 values.

In this case it is not working

Saurav11 · ‎11-27-2022

Please share screenshot even if it is in select box it should work till the region backend values match in variables and field on table.

Please share screenshot it would be easier to assist you.

Thanks.