Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
161 results found
-
Ability to colour code data pages, tables, views for a quick reference.
In most cases, large and/or complex applications built on multiple data pages, views and tables etc. While building such applications also creates multitude of waste such as redundant data pages, tables, views etc.
In my opinion It would be good to have a function to colour code data pages, views, tables etc. to have a quick reference point on what is okay and not okay to delete. What data pages, views, tables are redundant in the process an what aren't!
2 votes -
allow views on views, so the data source design can effectively become a bit more "object-oriented" and more maintainable
and also allow "full SQL" definition of views - set unions, set differences etc.; plus creation of combination / concatenation fields in views; would be great in itself but also provide solutions to some of the front end limitations like drop downs can't be sorted on some other field etc.
7 votes -
Search for identical data in separate tables
How do I get Caspio to search two separate tables and report identical information found in both?
1 vote -
Ability for App users to import data into tables
Ability to create a datapage for App users to import data into tables without using a scheduled task or having to log into caspio. App users can add data manually; why not have the ability for admin level users to import directly into the tables?
192 votes -
Filter a View by comparing two fields like a calculation.
For example. I would like to be able to create a view by comparing two separate fields.
- Field1 Equal to Field2...
- Field1, Greater Than or Equal to Field2..
- [Sale_Price] - [Cost] < "500"
- [LastImportDate] = Max of [LastImportDate]
Examples, COST vs SALE PRICE. Create a filter that allows me to show
9 votes - Field1 Equal to Field2...
-
It would be great if a table field could be set with a default value or do a calculation on update.
If you use importing to get data into a table you can't interact with the data without manual intervention. That defeats the purpose of automatic importing or importing at al really.
4 votes -
1 vote
-
Many-to-Many Relationships - Views as a source for a view
Many-to-Many relationships are powerful for many reasons; in particular action items that have many users that interact with them.
Please consider this scenario:
tblActionLog
FielduserCreator
FielduserAssigned
Field_userCompleter
...A report to display all three users would be very useful, and an easy approach (easy from our end, IDK what this would require from your end) would be to use three User table views as a source for the view that would be the source for the report.
viewUserCreator, viewUserAssigned, viewUserCompleter, tblActionLog -> sources for viewActionLogReport
Thanks for your consideration
CHAD5 votes -
allow copy/paste data from Excel into Caspio tables
I move data around a lot between Excel spreadsheets with copy/paste. I'd like to put some of these spreadsheets online with Caspio, but the inability to copy/paste from Excel to a Caspio table is a serious obstacle.
4 votes -
0 votes
-
Add "Order By" to views
Add order by to views... it's especially important when views are used for automated exports and emails.
5 votes -
Files - could we see how many are in a folder
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 -
Download table/datapage properties
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 -
Add SQL capability when creating a new View.
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 .
15 votes -
View Relationship results before saving
It would be great to see the results of the relationship created before clicking save.
1 vote -
Create a JSON output feed from views or tables
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.
19 votes -
Date format in table
It is a good feature if the Date format can be changed in the table level. Currently, the date values are stored in the tables in the format MM/DD/YYYY.
22 votes -
Ability to have calculated fields on a view.
In SQL I can create calculated fields for a view it would be nice to be able to do that same thing in Caspio view.
139 votesThank you for this idea. We are looking into adding this feature in future product updates.
-
Effective Dated tables
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 hkvhkgI have no way to build a view that gives me the current rows for A, B and C
1 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?