Adding and Subtracting in a from.

This site is best viewed in a modern browser with JavaScript enabled.

Adding and Subtracting in a from.

EnocPerez

Made a copy of the from from a Test site. https://forms.laparrilla.com/view.php?id=70416

eswbitto

EnocPerez you need to use a number field instead of the price field. the element ID is different than if you use a number field.

Jason123

Here is my form: https://www.dealingwithbailiffs.co.uk/forms/view.php?id=80275

It has 5 number fields, the first four are entered by the user, and the total needs to go in field 5.

I trying this script: https://www.nationalbailiffadvice.uk/jasonscripts/arithmetic.js

and the script URL is entered under Form Properties -> Load Custom Javascript File.

But the total does not appear in field 5 "Total".

Can anyone help?

eswbitto

EnocPerez


var c1, r1, r2, r3, r4, r5, r6, r7, r8, t1, t2, t3, t4, b1, b2, b3, b4, b5, b6, b7, s1, s2, s3, s4, s5, s6, s7, s8, s9, s10, s11, s12, s14, ,s15, s16, s17, s18, s19, s20, e1, e2, e3, e4, e5, e6, e7, e8, tr, tcc, tpc, te, cd, ts, ttp, ttpi, tss,;

// Why are you adding a comma at the end for tss? You don't need it for the variable declaration there.


tr = parseInput(r1) + parseInput(r2) + parseInput(r3) + parseInput(r4) + parseInput (r5) + parseInput (r6) + parseInput (r7) + parseInput (r8);
$('#element_14').val(parseInput(mt).toFixed(2));

ttp = parseInput(s1) + parseInput(s2) + parseInput(s3) + parseInput(s4) + parseInput (s5) + parseInput (s6) + parseInput (s7) + parseInput (s8) + parseInput(s9) + parseInput(s10) + parseInput(s11) + parseInput(s12) + parseInput (s13) + parseInput (s14) + parseInput (s15) + parseInput (s16) + parseInput(s17) + parseInput (s18) + parseInput (s19) + parseInput (s20) ;
$('#element_125').val(parseInput(mt).toFixed(2));

te = parseInput(e1) + parseInput(e2) + parseInput(e3) + parseInput(e4) + parseInput (e5) + parseInput (e6) + parseInput (e7) + parseInput (e8);
$('#element_57').val(parseInput(mt).toFixed(2));

ts = parseInput(b1) + parseInput(b2) + parseInput(b3) + parseInput(b4) + parseInput(b5) + parseInput(b6) + parseInput(b7);
    $('#element_64').val(parseInput(yt).toFixed(2));
	

// Calculate Income - Expenses

ttpi = parseInput(ttp) + parseInput(ts); 
    $('#element_31').val(parseInput(EM).toFixed(2));
	
tpc = parseInput(ttp) ; 
$('#element_17').val(parseInput(EM).toFixed(2));

cd = parseInput(tr) + parseInput(tpc); 
    $('#element_31').val(parseInput(EM).toFixed(2)); //This is where you calculate fields that have totals to come up with a grand total.

//you need to go through this again. You are using variables set that are unused. I would suggest using an IDE to catch these.

EnocPerez

So it will not add till it has be submit. How do I get it to add as your adding the information?

eswbitto

EnocPerez

I would have to see your code in order to answer your question. Did you make the corrections in my previous responses?

EnocPerez

Hi It does not add as I put in the numbers. is there a way to auto sub as I input the numbers. So as I in putting Price 1 of $1.00 The total would already have an total of $1.00 and so on with the Price 2, Price 3, Price 4.

eswbitto

EnocPerez yes, I have already answered this question initially with the snippet of code at the very beginning of this thread. Its basically all components you need in order to obtain what you are wanting. Keep in mind you need to use number fields, NOT price fields.

Example: element_1 we want to add with element_2 and then calculate the total and put it in element_3.

EnocPerez

eswbitto

Ok I started again. This time took out everything just kept it easy and just added the number Fields. But the total does not appear in element_12 "Total Revenues".

https://forms.laparrilla.com/view.php?id=71619

https://forms.laparrilla.com/custom_js/71619.js

Sorry again eswbitto eswbtto I ready want to get this.

eswbitto

EnocPerez

$(document).ready(function () {
    

var r1, r2, r3, r4, r5, r6, r7, r8, tr;

if ($('#form_71619').length) { 
    $(document).change(function () {

    r1 = $('#element_4').val();
    r2 = $('#element_5').val();
    r3 = $('#element_6').val();  // Here we are setting each of these elements to an assigned variable which will hold its value to calculate later.
    r4 = $('#element_7').val();
    r5 = $('#element_8').val();
    r6 = $('#element_9').val();
    r7 = $('#element_10').val();
    r8 = $('#element_11').val();

//This is where we assign a variable (an element) and also we calculate what that variable should be from above.
        


tr = parseInput(r1) + parseInput(r2) + parseInput(r3) + parseInput(r4) + parseInput(r5) + parseInput(r6) + parseInput(r7) + parseInput(r8);
    $('#element_12').val(parseInput(tr).toFixed(2));
    

});
}
});

// Default values to 2 decimal points

function parseInput(val) {
    val = parseFloat(val, 10);
    if(isNaN(val)) {
        return 0;
    } else {
        return val;
    }
}

3min0r

eswbitto Hey there, I have used this JS also but it doesn't appear to work for me, have put it in a test form at https://potterandmoore.forms-db.com/view.php?id=24865 with the following script. Any help you can offer would be great, thanks.

(document).ready(function () {

var r1, r2;

if ($('#form_24865').length) { // Replace XXX with your form ID
$(document).change(function () {

    r1 = $('#element_1').val();
    r2 = $('#element_2').val();
   // r3 = $('#element_6').val();  // Here we are setting each of these elements to an assigned variable which will hold its value to calculate later.
  //  r4 = $('#element_7').val();
  //  r5 = $('#element_8').val();
   // r6 = $('#element_9').val();
   // r7 = $('#element_10').val();
   // r8 = $('#element_11').val();

//This is where we assign a variable (an element) and also we calculate what that variable should be from above.

tr = parseInput(r1) + parseInput(r2); //+ parseInput(r3) + parseInput(r4) + parseInput(r5) + parseInput(r6) + parseInput(r7) + parseInput(r8);
$('#element_3').val(parseInput(tr).toFixed(2));

});
}
});

// Default values to 2 decimal points

function parseInput(val) {
val = parseFloat(val, 10);
if(isNaN(val)) {
return 0;
} else {
return val;
}
}

mmetcalf

williamansley William, I noticed that you are very knowledgeable regarding MachForm. I used it for 4 years at my previous company and I want to use it my new position. I need to control the entry number starting point so that each form begins at a number of my choosing. Can this be done? I do not want to purchase the platform without being able to do this. It's a necessity. Thank you, Marian.

williamansley

mmetcalf Unfortunately, there isn't any easy way to do this in Machform. If you wouldn't mind explaining why you want to do this, perhaps I or someone else could come up with an alternative way of accomplishing your goal.

3min0r

Did anyone get this to work? Machform doesn't even really seem to be attempting to run the JS, just nothing in the total field?

eswbitto

3min0r you haven't created a js file and pointed your form to it in the form properties.

Jason123

Yes I have, and it doesn't work.

I've been stuck with this for nearly two years, and I eventually gave up.