@mrpasini I have added variables for the rates, to preset them:
Could you please give me a hand to make the calculation correct again?
Another strange thing is that the cursor initially is placed in the 50% row, instead of the Perfect Matches row.
Thank you in advance!
version10.zip (161.5 KB)
Sure. I'll put something together based on your update a bit later today.
Meanwhile (for anyone following along), the cursor location is controlled by the word autofocus in the input tag. Just use one of those in the field you want to use first.
And tabindex=1 orders the field entry when you tab from one to the next. In my example prompt, it was used to go down the right column, assuming values in the left column were set by earlier code, as they were in the example. But still editable if required.
The totals in the last line are tallied with the += calculation. There's only one in my example prompt.
Sorry about the obscure variable names. I may revisit that later today.
Here's the v11 with a few substantial changes.
It seems like you have values for all the fields from your XML data and some constant rates, so I've set the form to calculate totals when you display the form.
You can edit any of the fields to instantly update the Amount display but Totals will be blanked because it is no longer valid. To recalculate the totals, click the Update button. I didn't update automatically in case some fields are empty.
If that isn't the case, the easiest way to make the form automatically calculate the totals is to add the calculate() function to the getAmt() function in each Rate field. You can even add them to the Word field. Here's an example.
oninput="getAmt('fiftyWords','fiftyRate','fiftyTotal');calculate()"
Just depends on whether the fields might ever be blank. I've made minimal assumptions here (that Rate might be blank).
Minor changes:
Changed the tab widths to accommodate "Cross-fFile Repeitions" on one line
Wrote a function to return the Amount for any particular line so editing a line's Words or Rate will instantly show a correct Amount (and blank the grand totals until you click the Update button).
Only the Custom HTML Prompt was changed in this version (well, apart from the title)
Job Calculator v11.kmmacros (31 KB)
Thank you @mrpasini! This is very nice. I'll add two things to this macro:
Then I'll publish the macro in the Macro Library :).