I have a form that uses a dropdown field to determine currency, then number fields to store the 'raw' decimal amount. So, for example, a user might choose "Dollar" from the dropdown, then add values of 0.06 and 50 to a couple of other fields, which means $0.06 and $50. Alternatively, a user might choose "Pounds Sterling" from the dropdown, in which case the 0.06 and 50 would mean £0.06 and £50.

I ultimately want to produce a report with totals in US$. So, I assume there will need to be an intermediary step where the amounts in pounds sterling are converted to dollars.

My question is, does Zoho Creator have inbuilt currency conversion functionality? I assume that the easiest way to get the solution I'm after is to run a script that identifies all fields that need to be converted (i.e. the ones in pounds sterling), convert them, then total them along with the other fields that were already in US$, but I'm not sure how to go about doing that.

Thanks!