Java to calculate in search form

[Richard]

Does anyone know if I can allow a user to select values from a series of questions in a search form to trigger a calculation of all lines of data to display in the "results" page?

Example:

Search page and answers

Question A: 3 (3 is the answer chosen by the user)

Question B: 2

Question C: 1

The table would be prefilled data for each question:

Name 1: 10 for Question A, 5 for Question B, 2 for Question C.

Name 2: 5 for Question A, 10 for Question B, 1 for Question C

Based on what the person enters in the search page, I would like to calculate this way using the above example and display a total:

Name 1: 42

(3*10)+(2*5)+(1*2)=42

Name 2: 35

(5*3)+(10*2)+(1*1)=35

[mingmeijiaoluo]

I don't think its something you can do without programming. You can either ask the caspio to program it for you or add some JS to perform the calculation.

[bahar_vm]

This requires custom programming, either a Java Script or a backend trigger to do the calculations. Caspio can write the program for you, you can fill out the Custom Application Development form at http://www.caspio.com/services/custom-a ... opment.asp to have a representative contact you to discuss in more details.

Best,

Bahar M.

[JolliBeng]

Hi ,

You can now add Calculated Fields on your Report DataPages.

 

-JolliBeng