Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
151 results found
-
Pre-populating the labels from an Excel import
When I import a table from Excel, the first row is generally the field names. I should be able to tell Caspio that the cells in the second row are the field labels.
3 votes -
Ability to mark fields required when creating data tables (Same as NULL and NOT NULL at MS SQLServer Level)
The front end has the ability to mark fields required from data page. Need the same at the table level. If the field is a required field at the table level should automatically be required in the data page.
3 votes -
Lock fields instead of entire tables when custom programming uses a table.
Currently, if professional service does any custom work (i.e. triggered action, etc) the entire table is locked and the user cannot do any further development using that table (i.e. cannot add fields, etc.). This causes users to have to submit tickets just to have a new field added. That can take from hours to days to get done through that process. This directly contradicts the use-case for Caspio which should allow users to develop their own apps.
Previously users may have changed a field used in custom programming which would break the programming. A support ticket would then go in…
3 votes -
1 vote
-
servant
App which visitors can select food on at restaurant and appear the order in a kitchen screen
1 vote -
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 -
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 -
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 -
Allow Folders/Organization in Views
Allow Views to be arranged/organized into Folders of View. This should be a simple fix.
1 vote -
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 -
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 -
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 -
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 -
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 -
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
- Don't see your idea?