hclleapforum

Open full view…

Update of responses

grobi13
Wed, 14 Aug 2019 10:44:12 GMT

Hello, I created an application. With a first form the user can request advances in local currencies. To approve it, the amount has to translate into Euro. So in a second form of the application I have stored all currency exchange rates. Monthly we get a new internal list of these rates. So my question is: my idea is to take the (csv) list of the new rates, store it on the Leap server and update all the responses in the form via REST API. Is it ok or has somebody a better solution to update these rates? BR, Andreas

christopher_dawes
Fri, 23 Aug 2019 18:43:58 GMT

Yes this would be an acceptable solution. Would you have to update all the submitted forms with the new exchange rate as well? If you do then this operation will get more expensive as the number of submitted records grows. You could change how your application works, if this is the case. You could add a service in the onLoad to look-up the exchange rate every time and re-calculate, this way you never have to manually update the data stored in the submitted record. You may want to store which exchange rate was used, for audit sake, but it would always grab the latest when the form is opened and then re-submitted. I would be happy to discuss further with you if needed.