How to Achieve the functionality Variable (Countrys)should comup based on Variable(Region selection)

[Community Alums]

Hi 
How to achieve the functionality 
when a user choose the Region as North America
only North America country should comeup in the Impacted country field
guide me steps
Both are from different table
Region- Custom table
Country - core_country table

Thanks in advance

[Dinesh Reddy By]

@Community Alums Country table does not contain region information. To implement region-based filtering, you’ll need to create a custom field  on the Country table and populate it based on your region-to-country mapping. Since this involves adding a custom field without modifying any OOTB functionality, it should not cause any issues or impact system upgrades.

[Robert H]

Hello @Community Alums ,

I'm going to assume you have added a reference field to the Country [core_country] table that references your custom Region table. The solution below assumes it's named "u_region".

On your country variable set the Reference qualifier to:

javascript:'u_regionIN' + current.variables.regions

Important: the community editor changes : to : to please change it back as shown in the screen shot below.

And set Variable attributes to:

ref_qual_elements=regions

If your list collector variable for selecting the regions is not named "regions" then adjust accordingly.

Results:

Regards,

Robert