How can I add 'Other' option in a variable which is showing choices based on reference qualifier

[Amol Pawar]

Hi Experts,

I'm stuck on one requirement. Please go through it and let me know the approach:

I have 2 variables in a record producer. One is a reference type, to core_country table. Second one is also a reference type but it is refering to one custom table which has the reference fields as country name. In that custom table, we've created a list of Names of offices in different countries. If we select one country from 1st variable, in second variable, office names from that country are populating. 

We've done this using reference qualifier in that variable as javascript:'country='+current.variables.infosys_entity_location. 

Now, client wants to populate 'Other' option in Infosys Entity variable for every country.

How can we achieve this since we're populating office names based on selection of country?

Let me know if anyone has any workaround.

Thanks in advance,

Amol

[Mark Manders]

You need to create an 'other' on your custom table, with no country and adjust your reference qualifier to show all none-countries and the selected country ones.

[Amol Pawar]

Hi @Mark Manders,

Thank you for your reply. Could you please tell me what modification I need to do in reference qualifier since I don't use reference qualifier regularly.

Thanks,

Amol

[Mark Manders]

I don't know how your custom table is setup, but if you have the 'other' defined in there, you can add it with an 'OR' action. Something like this:

javascript:'country='+current.variables.infosys_entity_location+'^ORcountry=other'

This example assumes you have named your 'other' record in the custom table with 'country=other', but it could also be a name field or something like that.