Jump to content

Calculation / batch processing


Recommended Posts

Hi,

Is it possible for Caspio Bridge to have a calculator function?

e.g. After a web form is completed and submitted, can Caspio calculate an insurance premium (from one of the tables) and provide a quote?

Secondly, if a group of people (e.g. customer table) needs to have a particular details changed, can this be incorporate in Caspio?

Thanks in advance for any help

Andrew

Link to comment
Share on other sites

Hi Andrew -

Caspio doesn't have \"built-in\" functions to calculate values based on entries made in a WebForm, but you can add JavaScript code to your webforms that will allow you to perform calculations.

Caspio has an example of some JavaScript code that performs simple calculations in the \"Support\" section of their website (From the Caspio.com homepage, click the \"Support\" link, then \"Training and Resources\", then \"Customizations with JavaScript\", and then the \"Perform a calculation on values entered in a WebForm DataPage\". The full URL to the \"calculations\" example is http://forums.caspio.com/viewtopic.php?f=14&t=12180.

If you don't feel comfortable modifying the Javascript yourself, I would be happy to talk with you about the specifics of the problem and let you know how long I think it would take to write the custom JavaScript for you (or you can work directly with Caspio's professional services group (http://www.caspio.com/services/services.asp).

I hope this helps.

Mitch Hollberg

Morrison Analytics

mitch@morrisonanalytics.com

Link to comment
Share on other sites

  • 4 years later...

Hello Andrew,

If the web form is already submitted and the data is present in the Table, then you can generate a Report DataPage based on the Table, http://howto.caspio.com/datapages/creat ... -datapage/

Calculated Field is an Advanced Reporting feature, please refer to this article: http://howto.caspio.com/datapages/creat ... ed-fields/

Another feature is the Totals and Aggregation,: http://howto.caspio.com/datapages/creat ... ation.html

Report can also be grouped based on identical data : http://howto.caspio.com/datapages/creat ... uping.html

If you wish to change the record in Details. http://howto.caspio.com/faq/reports-dat ... -page.html.

I hope this information helps,

Thanks, :D

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...