Jump to content
  • 0

Functions in data tables


jc_hill
 Share

Question

Hi ...

I was wondering if there was a way in Caspio to have table columns of calculated data. Basically, I'd like to have some kind of function, similar to Excel, that could calculate the field based on other data in that or a separate table.

For example, we have a database of restaurant inspections. One table lists every inspection, another lists a summary of each restaurant. I would like to be able to calculate, say total violations, by using like a count function that would parse the first table and count all the violations for each restaurant.

Can this be done?

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi ...

I was wondering if there was a way in Caspio to have table columns of calculated data. Basically, I'd like to have some kind of function, similar to Excel, that could calculate the field based on other data in that or a separate table.

For example, we have a database of restaurant inspections. One table lists every inspection, another lists a summary of each restaurant. I would like to be able to calculate, say total violations, by using like a count function that would parse the first table and count all the violations for each restaurant.

Can this be done?

Hello,

Unfortunately, the ability to do calculation in result page is not available in Caspio Bridge at this time. However, this is something we are considering in adding to future release of Caspio Bridge.

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
Answer this question...

×   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...
 Share

×
×
  • Create New...