asked on June 25, 2015
•
Show version history
On a mileage form we have created, if we save it as a draft and then go back into to add additional auto-calculated rows (database lookup), each added row automatically adds the value 4.5 (sometimes a different value) in the miles field.
I have not been able to figure out why it is doing this and was wondering if anyone would be able to help try to solve the mystery. Below is a screenshot of part of the form and also the custom JavaScript we are using on the form.
In the above picture I simply loaded a saved draft and then clicked on "Click to add miles" link and it automatically put in the miles values even though the To and From options were not selected.
01 | $(document).ready(function () { |
02 | |
03 | //make fields with read-only class read-only |
04 | $('.read-only input').attr('readonly',true); |
05 | $('.read-only select').attr('disabled',true); |
06 | |
07 | |
08 | //Start Add row mile fields together |
09 | $('.cf-table-block').change(sumtotal); |
10 | function sumtotal() { |
11 | var sum = 0; |
12 | $('td.sum').each(function () { |
13 | var s = 0; |
14 | $(this).find('input').each(function () { |
15 | if ($(this).closest('td').siblings('td.roundTripCheck').find('input').is(':checked')) { |
16 | s += parseNumber($(this).val() * 2) |
17 | } |
18 | else { |
19 | s += parseNumber($(this).val()); |
20 | } |
21 | }) |
22 | $(this).find('.subtotal input').val(s); |
23 | sum += s; |
24 | }); |
25 | $('.total input').val((sum).toFixed(2)); |
26 | } |
27 | function parseNumber(n) { |
28 | var f = parseFloat(n); //Convert to float number. |
29 | return isNaN(f) ? 0 : f; //treat invalid input as 0; |
30 | } |
31 | //End Add row mile fields together |
32 | |
33 | //Start Calculate mileage reimbursement |
34 | $('.cf-table-block').on('change', 'input', sumreimbursement); |
35 | function sumreimbursement() { |
36 | var s = 0.44; |
37 | $('.totalmiles input').each(function () { |
38 | s *= parseNumber($(this).val()); |
39 | }); |
40 | $('.totalreimbursement input').val((s).toFixed(2)); |
41 | } |
42 | function parseNumber(n) { |
43 | var f = parseFloat(n); //Convert to float number. |
44 | return isNaN(f) ? 0 : f; //treat invalid input as 0; |
45 | } |
46 |
47 | //End Calculate mileage reimbursement |
48 | |
49 | //Uncheck verify checkbox field |
50 | document.getElementById('Field51-0').checked = false; |
51 | |
52 | //End Uncheck verify checkbox field |
53 | |
54 | //Start Auto Fill |
55 | function tableAutofill() { |
56 | $('.cf-table-block tbody tr').each(function () { |
57 | $(this).find('button.autofill').trigger('click'); |
58 | }); |
59 | } |
60 | |
61 | function autofill() { |
62 | //$('.autofill').trigger('click'); |
63 | $(this).closest("tr").find('button.autofill').trigger('click'); |
64 | } |
65 | |
66 | $('.lookupCondition input').blur(autofill); |
67 | $('.lookupCondition select').blur(autofill); |
68 | $('.cf-table-add-row').click(function(){ |
69 | $('.lookupCondition input').blur(autofill); |
70 | $('.lookupCondition select').blur(autofill); |
71 | }); |
72 | //$('.cf-table-block').change(tableAutofill); |
73 | //End Auto Fill |
74 | |
75 | }); |
Thanks in advance for your help.
0
0