How to add currencies of the world to a field?

RohanDS · ‎05-10-2023

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 · ‎05-10-2023

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 · ‎05-11-2023

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!

RohanDS · ‎05-11-2023

Thank you this really helps!