Question

Forms currency type setting

Updated October 9, 2017

asked on October 6, 2017

A customer would like to know if there's a table in the database that lists all the currency types that can be configured. He wants to allow his users to select which type of currency they're entering and would like to take the possible values from a table in the Forms database (if it exists).

I didn't see anything that looked like it would contain that info.

Thanks!

0 0

Answer

SELECTED ANSWER

replied on October 9, 2017 • Show version history

Hi Sheila,

I believe this post outlines a solution to your issue. It doesn't answer the question as to where the list itself is being retrieved from, but should help set up the solution as your client has requested.

0 0

Replies

replied on October 9, 2017

Thanks, Eric! That gave me the starting point I needed.

Based on that, I was able to give the customer some javascript he could modify to either populate a dropdown list or put in a Forms table and have Workflow populate an external database table that could be used for lookups in a dropdown list. This script just prints to the console the 3-letter code, currency description, and the symbol for each currency Forms can be configured for.

$(document).ready(function(){
  $.each(currency_list, function(key, value) {
    $.each(value, function() {
      console.log(value['code'] + ' : ' + value['currency'] + ' : ' + value['symbol']);
    });
  });
})

0 0

You are not allowed to follow up in this post.

Question

Question

Forms currency type setting

Answer

Replies

Sign in to reply to this post.