- redgatefinanceAsked 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!
- CarinaAnswered on June 10, 2016 at 06:16 AM
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.
- JotForm SupportWelvinAnswered on June 10, 2016 at 01:22 PM
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.
- redgatefinanceAnswered on August 31, 2016 at 04:32 AM
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!
- JotForm SupportBJoannaAnswered on August 31, 2016 at 07:21 AM
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.