Caspio
Welcome to Caspio Ideabox. We love to hear your improvement ideas.
164 results found
-
create a pivot table View
The filtering logic for views is great. Adding pivot tables in views would allow pivot tables to be exported, referenced or accessed via API.
2 votes -
1 vote
-
Move a record from a table to another
Hello,
would be nice to have an option to move a record from a table to another.
In my case for example, when I want to blacklist a record I have on my table, I move it to a Blacklist table to then make sure with a view between the two tables that the blacklisted company is not registered again in the first table.Right now we need to export/download the data, delete the record in the first table, then import it on the new table, quite time consuming.
1 vote -
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?
202 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
- Don't see your idea?