I created a programme which includes a table for [COUNTRY], [EXCHANGE RATE], [MARKUP %] so on and so forth. I added a inputfield [EXHANGE RATE], so that the rate can vary when i click it.
The problem i face now is that, when i change the value of the exchange rate, and close the programme, and i open it back again, it would be the value which i changed. So lets say i changed the Rate for Malaysia from 2.4 to 2.6, and close the programme, it remains as 2.6. What i want is for the 2.6 to change back to 2.4 when i open up the file again.
Create a second variable (eg vExRateOriginal) and set this value to be your base value that you want to default to when opening (2.4). Now on open add a Trigger / Action that sets your first variable to be the contents of vExRateOriginal. You can then amend the first variable without altering the value in vExRateOriginal and it should always revert back to 2.4 each time the document is opened.
It may need a little alteration to meet your exact needs but hopefully that points you in the right direction.
Create a second variable (eg vExRateOriginal) and set this value to be your base value that you want to default to when opening (2.4). Now on open add a Trigger / Action that sets your first variable to be the contents of vExRateOriginal. You can then amend the first variable without altering the value in vExRateOriginal and it should always revert back to 2.4 each time the document is opened.
It may need a little alteration to meet your exact needs but hopefully that points you in the right direction.
You'd have to undertake some experimentation to be sure but I've not had any issues with variables on a server (although not exactly this scenario).
You may even have nothing to worry about with a server deployment as users may well be able to amend variables via Input objects but not save them ergo the next time the .qvw is opened it has automatically reverted back to the original value -but as I say that would need some simple experimentation to find out how it behaves in the wild.
