Jump to content

Search the Community

Showing results for tags 'calculations'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 3 results

  1. I have a details page I need to make calculations for multiple fields to do estimating. I am entering values in fields and need to create a cost on the form. I was successful in creating some of the calculations but after the 4th calculation is made, the rest of the fields to be calculated display NaN. Here is the script and attached is a screen shot of the results.... <button style="background:red" onclick="calculate()">Calculate</button> <SCRIPT LANGUAGE="JavaScript"> function calculate() { var a = [@field:Area1_Sq_Ft] document.getElementById("EditRecordArea1_Sq_Ft_Cost").value = a*7; var b = [@field:Area1_Vertical] document.getElementById("EditRecordArea1_Vertical_Cost").value = b*7; var c = [@field:Area1_Steps] document.getElementById("EditRecordArea1_Steps_Cost").value = c*7; var d = [@field:Area1_Cracks] document.getElementById("EditRecordArea1_Cracks_Cost").value = d*7; var e = [@field:Area1_Pitting] document.getElementById("EditRecordArea1_Pitting_Cost").value = e*7; var f = [@field:Area1_Removal] document.getElementById("EditRecordArea1_Removal_Cost").value = f*40; var g = [@field:Area2_Sq_Ft] document.getElementById("EditRecordArea2_Sq_Ft_Cost").value = g*7; var h = [@field:Area2_Vertical] document.getElementById("EditRecordArea2_Vertical_Cost").value = h*7; var i = [@field:Area2_Steps] document.getElementById("EditRecordArea2_Steps_Cost").value = i*7; var j = [@field:Area2_Cracks] document.getElementById("EditRecordArea2_Cracks_Cost").value = j*7; var k = [@field:Area2_Pitting] document.getElementById("EditRecordArea2_Pitting_Cost").value = k*7; var l = [@field:Area2_Removal] document.getElementById("EditRecordArea2_Removal_Cost").value = l*40; } </SCRIPT>
  2. I am trying to pass the value from specific column totals for use in html page(s) and/or virtual fields. Any help is appreciated. e.g. table with 3 columns and n rows I want to retrieve and pass the total value of column 1, column 2 and column 3 for use on a different webpage or for a custom html field Thanks in advance
  3. My Update form has 7 dropdown fields (Q1 – Q7) in which Rate/Yes/No options have corresponding numeric values. (Rate=No - No value, Yes=5, No=0) . We need help in 2 things. 1. Calculate and store the total Value of all the fields.To Calculate and store the total value of the Q1 – Q7 dropdown, we use the following script in the footer of the update form, (but it seems that it's not working) <SCRIPT LANGUAGE="JavaScript"> function calculate() { var Q1 = parseInt(document.getElementById("EditRecordQ1").value); var Q2 = parseInt(document.getElementById("EditRecordQ2").value); var Q3 = parseInt(document.getElementById("EditRecordQ3").value); var Q4 = parseInt(document.getElementById("EditRecordQ4").value); var Q5 = parseInt(document.getElementById("EditRecordQ5").value); var Q6 = parseInt(document.getElementById("EditRecordQ6").value); var Q7 = parseInt(document.getElementById("EditRecordQ7").value); QRating=parseInt( Q1 + Q2 + Q3 + Q4 + Q5 + Q6 + Q7); document.getElementById("EditRecordReferral_Rating").value = QRating; } document.getElementById("caspio").onsubmit=calculate; </SCRIPT> 2. Calculate and store get the Percentage of the answered questions. --> Need help on this. Our URL https://c2arw288.caspio.com/dp.asp?AppKey=DA284000754da7037a634519be3d&bestemailID=cmedrano@orangetheoryfitness.com Thank you in advance.
×
×
  • Create New...