Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
151 results found
-
We should be able to develop app with dynamic search bar displayed with results without using another data page
At the moment, through viewing your ready-made apps and tutorials, we need to use up a DataView from our limited (5) dataviews when you create a search display simply to be able to have the search and results on the same page. This seems very restrictive.
You should be able to have a setting to display search and results on the same page without this extra data page.8 votes -
Raise the table limit on view to 25
I use lots of "dictionary" tables for lookups on drop downs these occur in multiple column in reports so need to be included as a different alias for each said column. Starts to add up pretty quick and I've already met the 16 table limit.
8 votes -
semicolon seperator
Allow to use semicolon as field delimiter when importing files
4 votes -
Apply localizations to views and tables
It would be great to apply things like custom time zones to tables and views.
6 votes -
Better SQL features. DELETE query (esp for duplicates). UPDATE query for mass updates
Deleting duplicates in a table requires a filter and checkbox deletion by hand. Updates can only be made outside of Caspio and re-imported. These basic execution SQL functions should be enabled in some form other than imports.
Especially with big data, using imports to update and delete tables is tedious at best and unachievable at worst.
2 votes -
Record Locking
Not all the time we work with people editing only his own profile info. In our case, we have a lot of users who might access to the same records without any notice that somebody else open it before. This causes information being lost. For example, User A opens a record first and then User B does. As user A only editted the date of birth leaving the middle name empty, as he did not intend to deal with the middle name. Now user B (who accessed the record while it was being editted by User A), only wants to…
24 votes -
Option for printing Table design in Caspio console
For having printout and system documentation , a table structure is mandatory. I wonder what such a simple option is not in the system,
The user should be able to print the table design/structure simply, and directly from Caspio , not by exporting to Excel first.4 votes -
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?
187 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
- Don't see your idea?