Newbie Questions

Re: where to save exchange rates that are used in a form?

omerkadari — Tue, 10 Nov 2009 05:55:07 GMT

Hi! How can u modify the objects of the expense report, no matter what i do it's locked?

Re: where to save exchange rates that are used in a form?

Matt Faus — Tue, 08 May 2007 14:52:00 GMT

Well done!

Re: where to save exchange rates that are used in a form?

galliumarsenide — Tue, 08 May 2007 12:58:22 GMT

aah.. i got the solution!

the descriped if/else tree can be modelled as:

field_value=

specified_price * (contains(currency, "CHF") + contains(currency, "EUR") * 1.5 + contains(currency, "USD") * 1.3 )

since the contains(A, B) function returns 1 when field A contains string B, and 0 if it doesn't. :D

Re: where to save exchange rates that are used in a form?

galliumarsenide — Tue, 08 May 2007 12:16:17 GMT

thanks for the hint! unfortunately, in that example form the user has to enter the exchange rates every time he fills out the form. i need to specify those rates within the form itself, somehow.. :/

(i need just approximate values.)

what would be a really convenient way is if i could use some kind of if statements in the 'default value' box, since i only have a handful of currencies. like:

if currency="CHF" {field_value=1*entered_price}
else
if currency="EUR" {field_value=1.5*entered_price}
else
if currency="USD" {field_value=1.3*entered_price}
else {field_value=0 }

....... isn't there any documentation or so on the expression syntax?

Re: where to save exchange rates that are used in a form?

Matt Faus — Mon, 07 May 2007 22:13:16 GMT

Hi GaAs,

InfoPath includes an International Expense Report form as a sample, which implements exactly what you are talking about. Maybe you can just modify this example to suit your needs. Check it out!

where to save exchange rates that are used in a form?

galliumarsenide — Mon, 07 May 2007 21:45:36 GMT

Hi,

I need to impement a form were the user can select from different currencies, whereupon the values in the fields are recalculated depending on the choice.
concretely:

a field: specified_price, "specify price:"
dropdownmenu: currency, "specify currency:" (USD/EUR/CHF etc.)

an unchangeable field/formula box: price_in_CHF, "price in CHF"

so when the currency is changed the "specify price"-field value should be multiplied with a factor to obtain the price in CHF. clearly, those factors (exchange rates) need to be specified somewhere and my question is where/how. I've tried using unchangable data-fields with standard values within the form template, but then wasn't able to implement the calculation. The problem is, I need to have the rates in some kind of repeating data-source form to perform (something like):

price_in_CHF = (exchange_rate where currency_name=currency) * specified_pice ...

So next, i tried having the exchange rates in an external XML file, which worked, but it is rather troublesome to change the values like this (the xml file needs to be imported anew every time). The rates don't have to be changeable quickly, i was told that they just want to be able to adapt them once or twice a year, so they told me they could do it by changeing something in the infopath-template.

Anyone got some suggestions how to implement this conveniently?

Regards,

Fabian