Is there a way to convert USD and EUR to a GBP total, depending on options in a radio field?

  • redgatefinance
    Asked on June 10, 2016 at 5: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!

    Jotform Thread 857815 Screenshot
  • Carina
    Replied on June 10, 2016 at 6: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.   

  • Welvin Support Team Lead
    Replied on June 10, 2016 at 1: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:

    Is there a way to convert USD and EUR to a GBP total, depending on options in a radio field? Image 1 Screenshot 50

    Just do the same for the rest, here's the complete list:

    Is there a way to convert USD and EUR to a GBP total, depending on options in a radio field? Image 2 Screenshot 61

    3. Now, just show the currency calculation based on the ...currency of you claim.. field. Here's an example:

    Is there a way to convert USD and EUR to a GBP total, depending on options in a radio field? Image 3 Screenshot 72

    Here's the complete list of conditions for the currency field:

    Is there a way to convert USD and EUR to a GBP total, depending on options in a radio field? Image 4 Screenshot 83

     

    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.

  • redgatefinance
    Replied on August 31, 2016 at 4:32 AM

    Hi there,

    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!

  • BJoanna
    Replied on August 31, 2016 at 7: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.