What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there a way to convert USD and EUR to a GBP total, depending on options in a radio field?Asked by redgatefinance on June 10, 2016 at 05:20 AM
Hi there, I have a radio field for currency followed by an 'amount'. When USD/EUR is selected in the radio field I would like my form to calculate the value in GBP using real time exchange rates, and then total the GBP amounts at the bottom of my form. I tried to do this with the currency converter widget using conditions but I cannot seem to make it work. Do you have any suggestions on how to do this please?
I would need the 'total reimbursement' number field at the bottom of the page to calculate the total claimed in GBP, even if the amounts are in another currency.
Thanks for your help!
Unfortunately at the moment it is not possible to have real time currency conversions being passed to other fields.
I will create a feature request. We'll contact you as soon as we have more details on this.
Let us know if we can assist you further.
While there is no option to automatically show the realtime conversion between USD/EUR to GBP, there is a workaround to show your clients the total based on the selected currency. You can utilize our calculation feature and show/hide conditions.
Please check this cloned version of your form: https://form.jotform.com/61615420397960.
Here are the needed changes to accomplish the same form:
1. Remove the currency symbol in all expenses section/collapse
2. Add four (4) calculation fields based on the ...currency of you claim.. field. For example, the USD:
Just do the same for the rest, here's the complete list:
3. Now, just show the currency calculation based on the ...currency of you claim.. field. Here's an example:
Here's the complete list of conditions for the currency field:
Note, if you don't want to add multiple calculation fields, you can also do this using update/calculate field condition. Let me know if you want this method instead and I'll give the steps.
Thank you for your suggestion above, I have used this in my form but it is not ideally what I need the form to do.
I wonder if there has been any further development on a feature that will allow real time currency conversions being passed to other fields??
This is a really important feature in my form as currently the user has to convert the total and enter the GBP equivalent themselves - which leaves room for error.
Thanks in advance for all your help!
Unfortunately feature you requested is still not implemented. We can not give you exact time when and if this will be implemented. If there are any updates we will inform you via this thread.
For now I can only suggest you to use workaround my colleagues provided you.