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 .12 votes
Add order by to views... it's especially important when views are used for automated exports and emails.5 votes
Should be easy to add I would have thought and would really help us in managing our apps. Seems odd that there is no property feature for file folders as there is with datapages, tables etc.1 vote
Conitional formating of the fields, such as if a field is greater than 5, the background would turn red0 votes
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.5 votes
What would really make Caspio powerful is to have a way to create a JSON and/or XML view of data that could be accessed dynamically by web applications. I want more flexibility in how I present data, and I'm willing to develop that myself, but I could still use Caspio as a back end to enter and manage and store data, without having to build that infrastructure myself every time.15 votes
It would be great to see the results of the relationship created before clicking save.1 vote
It would be great to be able to build views based on effective dated tables.
EmployeeID EffectiveDate Change
A 10-12-2010 ABCD
A 10-1-2011 jkebfbe
B 1-1-2011 lwqfwf
B 4-9-2012 kefkhk
C 5-3-2012 hkvhkg
I have no way to build a view that gives me the current rows for A, B and C1 vote
Provide a listing of all locations of fields that if deleted from tables will cause dependent Datapages/Views to become unstable.
When trying to delete unused fields from a table, if they show up ANYWHERE in any datapage or view the system gives a warning that proceeding with the deletion may cause instability. It takes LONG time to go into each possible datapage and and view to try to locate where you've got those fields and delete them so they don't cause this problem. Since the system found them well enough to tell you they exist, why can't the system provide you a list of there they are located so you can find them easily, too???2 votes
- Don't see your idea?