I created this module for currency conversion, variable "pair" = currencies in ISO format (example $ to Taiwan Dollar = "USDTWD"
String url ="http://download.finance.yahoo.com/d/quotes.csv?s="+pair+"%3DX&f=l1n";
return new URL(url).getText().trim();
Returned result = 32.8200,"USD/TWD"
Feel free to use it!
I work in a database that has several currency fields all set that way in US dollars. Maybe 1 out of 10 times I need to create a record where the currency would need to be displayed in euros, pounds, etc. Is there a way to make the fields editable so that I can ovverride the $ symbol only when I need to? Its not worth making the fields general since the majority of the time the value is $. Its also too clumsy to make a drop down box next to each field where you can select the currency symbol because there are MANY fields on the layout that display currency and its already a tightly structured layout. Any other ideas? Thanks!
I have a field which is defined as a 'text' field as it will contain both numbers(currency) and text.
The field is defined by the following calculation:
Case(IsEmpty(_pk_InvoiceID); "(Not Invoiced)"; Paid - Subtotal) Because this field is defined as a text field (to allow insertion of "(Not Invoiced)" string), I can't use the currency formatter in the Inspector.
Any suggestions on how I can force a currency format on the numerical values in this field?