Jump to content

Search the Community

Showing results for tags 'calculations'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • 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


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 4 results

  1. I am building a report and want to create a virtual field which shows the result of subtracting one time/date field from another and then sums the times at the bottom. Ie this is for calculation the time taken to enter data for each record. Can anyone advise me on code for this?
  2. 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>
  3. 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
  4. 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...