Copy link to clipboard
Copied
I need some help. On page 3 meals and lodging detail, there is a drop down list that contains first, last, and all. If user selects first, then the amount put into the Total GSA per diem rate is to be mulitplied by 75%, and the value put into the box next to it. If the user selects all, then the full amount put into the Total GSA per diem rate is copied into the cell next to it. If the user selects Last, then again the amount put into the Total GSA Per Diem Rate is multiplied by 75%. If N/A is selected then 0.00 is put into the box next to it. If have created the following code:
Copy link to clipboard
Copied
Replace value with event.value
Copy link to clipboard
Copied
thanks for the reply, i tried replacing value with event.value, and still getting 0.00 for each one.
Copy link to clipboard
Copied
You are using that script at wrong field, put it in field where you wan't to show result.
Make changes that Bernd suggested and also change:
this:
var g = getfield("GSA$").valueAsString
to:
var g = Number(getField("GSA$").valueAsString)
Copy link to clipboard
Copied
I put the formula in the field when i wanted to show results, made the changes you suggested, and made the changes that Bernd suggested, but still gettting the same result.
Copy link to clipboard
Copied
EDIT: there were also an error:
var g = Number(getfield("GSA$").valueAsString)
should be:
var g = Number(getField("GSA$").valueAsString)
Also in "DR1" and all dropdown fields in options tab check 'Commit selected value immediately'.
Copy link to clipboard
Copied
It worked!!!!!!! thank you so much.