Would be nice if there was an SQL query for Caspio whereby you can write SQL statements to manipulate data in your Caspio database. In addition, be able to schedule jobs to run SQL query. Furthermore, it would also be great to trigger queries based on insert or update or records. See attached.

Ability for the apps to be responsive to automatically adjust the content on the screen to multiple device types

Customizable validation for data submission forms and update reports and forms would be very nice.

i.e...
0 < DOBmo < 13
0 < DOBday < 32
1900 < vehicleYear < DATEPART(year, now())
FirstName (Not Like "*[!((a-z) or (0-9))]*")
999,999 < Phone < 10,000,000,000

Using Autonumber is not desirable to use as a key-field in a table as a related field to another.
First, Caspio allows the user to re-number, although with warnings, it could still corrupt your database with orphan links left behind. Also you can only create a join with another like "autonumber" (can't use a number field).

Suggest a fix for above, or create a new sequence generator similar to what Oracle has.

Have the ability to download the table preoperties like fields, records, size, last modified etc. or datapage properties. This is available when you click on datapages or tables, but it would be nice to have it downloadable.

Add SQL capability when creating a new View. I believe this would be very useful to generate aggregate totals like:"Max(), Sum(), Exists" and concatenation of values. This view should also be available for scheduled downloads .

Currently you can only display the chart and report constituents in a 'Chart and Report' datapage one below the other. Give users the ability to also display them one beside the other

Autonumbering with a alphanumeric prefix would be a nice feature.

Add web services connection for DataHub.

I wish the Caspio program would allow users to download the exact same report as seen on the report display to MS. Excel. For example I have spent time formatting my data elements as a percentage , or with an extra decimal place, or currency as dollars with the two extra decimal places. However once I downloaded the report I notice that all formatting is gone. I am fully aware that I can make format changes in MS Excel but I feel like I am doing the work twice I wish that these items would export automatically.

Caspio needs to include a PDF output option to bring it up to spped with other applications in this area.

As an Destination option, Caspio should provide a flag that allows a Datapage to display in PDF.
This can be applied with a simple html to pdf conversion tool.

Example.
Create a HTML Datapage which receives parameters and styled as a document.
Choose this data page as the destination page (Tick for PDF) and the page/pdf should Open/Display as pdf when called by the browser.

it would be great to have caspio's api in zapier so we can connect to several different apps.
https://zapier.com/zapbook/

http://www.labnol.org/internet/regular-expressions-forms/28380/

Sometimes a developer may want to display, and not allow edit, a piece of data from a previous datapage. This displayed datapage element may need to be referenced from javascript which I don't believe is possible now. All other configurations of elements can be referenced, even hidden elements, but now the display only element.

Currently, using aggregate functions such as Count will return an integer, meaning if you attempt to calculate something of the form of Colunt_non_Blank/Count, you will get 0 since both are integers. This seems like an unnecessary limitation. I was able to bypass by multiplying by both number by 1.0, but this seems cumbersome and should not be required to perform such a calculation.

Carousel or other way to easily and attractively display multiple photos on a page...especially those uploaded by viewers

Can we have HTML blocks that can take more characters, say 20k or 30k characters? I'm using HTML blocks in Results pages a lot now and the current 10k allowance is quite limiting

As a maker of Caspia forms, I'd like to use Caspio's web-form creator service, plus send the data to another webservice API (potentially several other WSDL).