Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
161 results found
-
Add a SUM field as a data type to perform cross-table tabulation
I chose Caspio over a newer competitor of Caspio because I could have a LITTLE more latitude using Caspio....however, I nearly went with the competitor because they had a SUM field option, that I could set up in a separate table and sum amounts in another table based on criteria determined in my current table.
This functionality is sorely missing. It was the basis of my first support ticket with Caspio. I was told "if you are looking to have a table value updated based on some action or value changed in a different table, this may require a trigger…
0 votes -
Allow vertical size of tables to be smaller
Allow the table sizes in the relationship view to be smaller. Right now there is a limit on how short you can make the box and that makes it more difficult to see all the relationship connections. It would be nice if small tables didn't use up as much vertical real estate in the ERD.
2 votes -
Allow Folders/Organization in Views
Allow Views to be arranged/organized into Folders of View. This should be a simple fix.
1 vote -
Union Views/Queries
It would be valuable to be able to use a union query to combine multiple queries into a single result. For example, suppose your database has two unrelated tables where one stores customer data and another stores data about suppliers – and both tables have a contact information field. You’d like to see the contact information from both tables in one view. We cannot do this today in Capsio like we can in SQL Server or even MS Access. To do this, we would need to create a view for each table to retrieve the contact information, and then combine…
66 votes -
Apply SQL 'AND' clause when creating a view
This would be helpful for restricting tables before doing the join when creating a view. A possible workaround would be giving the option to link a view with a view. This is very valuable for historical type tables.
For example:
I have 2 tables, I need to filter table 1 before joining with table 2.
Customer table:
Customer | State
A | S
B | V
C | LEntry table
Customer | Entry | Category
A | 123 | D
A | 325 | C
A | 496 | D
A | 3874 | M
B | 3478 |…3 votes -
Password protected table from deletion that can maximize security
I would like to see if the table that can be protected from deletion without putting passcode or password of the author or admin for maximum table security. Because if the table deleted all things are gone.
4 votes -
Download link on [TABLES> NEW >TABLE DESIGN tab] to download the table design into a csv or other file.
Currently you have a link on the Datasheet tab to download the table to a file. It would be nice and efficient for a DOWNLOAD link on [Tables>New>TABLE DESIGN tab]
to download the TABLE DESIGN into a XLS, CSV or other file.4 votes -
Move up/move down arrows on join page in view setup
Currently when setting up views, the order of the table joins cannot be altered. When a modification has to be made to the joins in a certain order, all joins below the one to be modified or added must be deleted and re-added.
1 vote -
Move Up / Move Down option in Tables datasheet view
There needs to be a Move Up / Move Down option in Tables datasheet view. I created a lookup table called in from a Form field multiple choice. The only sort options are alphabetical. Tech support said thats my only option except delete all the table datasheet entries and redo them in the order you want. Not ideal if I have 50 entries and/or add to it occasionally. With each new option I have to rebuild the table? An Insert Here or Move Up/Down option would be fantastic here.
4 votes -
Ability to put apps into a development mode such that you can test without deploying
I have installed the Contact Log ready-made app to investigate how the logging panel works.
However in order to do so, and this would apply in a lot of cases - not just the ready-made apps but your own app, you need to deploy it to a web server in order to test it since it uses passed parameters between the various view panels.
This makes it difficult for non-technical people to develop such apps.
A 'development' mode interface where the views do not need to be deployed in order to test them out would be handy especially since preview…3 votes -
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
- Don't see your idea?