How to add currencies of the world to a field?

[RohanDS]

Hello peeps,

I have a requirement where I need to define a variable on a catalog item that would show all the currencies of the world. For eg:

Field name: Please select the currency in which the project is being performed.

Drop down or reference should be: USD, EUR, INR, CAD, etc,,,

Is this possible? Do we have predefined table for this?

[Karan Chhabra6 · Accepted solution]

Hi @RohanDS ,

You can leverage the 'fx_currency' table for this, create a field of type reference and refer to the 'fx_currency' table.

Output:

If my answer has helped with your question, please mark it as correct and helpful

Thanks!

[Karan Chhabra6 · Accepted solution]

Hi @RohanDS ,

You can leverage the 'fx_currency' table for this, create a field of type reference and refer to the 'fx_currency' table.

Output:

If my answer has helped with your question, please mark it as correct and helpful

Thanks!

[RohanDS]

Thank you Karan! That was indeed helpful.

[RohanDS]

In addition to this, can I display two values from two different columns? I know we can mark only one value as true but I wanted the code as well as the country name to be displayed from the same fx_currency table.

[Karan Chhabra6 · Accepted solution]

Hi @RohanDS ,

You can add a variable attribute for this reference field, use this line as variable attribute:

ref_ac_columns=name,ref_ac_columns_search=true,ref_ac_order_by=name,ref_auto_completer=AJAXTableCompleter

Output:

If my answer has helped with your question, please mark it as correct ans helpful

Thanks!