Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
150 results found
-
Convert View to Table
There have been a few instances I've ran into where it would be helpful to be able to convert a view to a table directly in Caspio rather than having to download the view and re-import it as a table.
1 vote -
Provide a parameter for when a table was last updated.
I update a certain table 1 time per week manually via import. After the import I need to enter 1, (or many) datapages that reference the table, and manually update HTML text field for "last updated MM-DD-YYYY).
It would be nice to have system parameters for the tables that can give for example
"last added record date"
"last deleted record date"
"last added or deleted record"
or
"last modified" (Any change to the data table)1 vote -
Please allow incremental update of imported tables
Once a large table is imported from Excel, please allow at least APPENDING to the table easily with only updated rows. For example, I have daily data and already imported historical data of 1M rows, I need just this month's rows.
1 vote -
I was getting duplicate name for the column header in table design view
I think It was because I was swapping column headers with the same name and did not save in between each. the issue was that the first row for the first column would be the one highlighted in red. I nice feature would be to highlight the actual one.
Also for it not to dumb all your work and just not let you save it....because when you do, all the work goes away, as another suggestion.. I should be good now thank you!1 vote -
Add Function to display a message in Triggered actions
It would be useful to be able to display a message when a triggered action runs and meets a certain condition.I could then inform the user of confirmation, actions required to rectify or warn them the other table did not update and why.
1 vote -
Make it possible to edit formulas that are referenced
Right now, if I want to edit a formula, Caspio won't let me, because there are references to the formula in tasks and triggers. I understand that this is an attempt to keep me from breaking the application. But as a consequence, to edit my formula, I now have to remove all the references to my formula across the application, change the formula, and then put those references back, praying I don't forget one or break something else in the process. That's a terrible way to accomplish this task.
1 vote -
Enable sql views, Functions and Stored Procedure
I am new in Caspio but I loved it very much. I believe that Caspio will be perfect if it allows writing views, functions, and stored procedures just like SQL server, besides the easy way of generating views. I believe this would solve many issues for developers. It would also make Caspio appropriate for experts and non experts.
Thanks1 vote -
simulator in tasks
I want to suggest to have a simulator in the task, this is different that validating.
The simulation would show if the task is going to do exactly what I want to.1 vote -
make it possible to timestamp a table when it was last updated for use in datapages reports
It would be nice to have a datestamp for when a table was last updated or imported. I import a dataset every week into a table and have to manually go to the datapage report to inform the users last updated on MM/DD/YY. Sometimes it is different language reports and the date update needs to happen on all the language versions of the datapages.
1 vote -
Adding an automatic Import undo
You should have an automatic undo import for records in and out of tables. You can see the message confirming the import but there should also be an easy way to undo it.
1 vote -
Manually select records to download from results returned
Allow users to review all results matching their search criteria, but also allow them to manually select which records to export into Excel.
1 vote -
Import/Update data from multiple files into a "single" Caspio Table
Equivalent Excel function:
MENU: Data > Get Data > From File > From Folder
ACTION: Combine > Combine & Load
USE CASE: Thousands of source files, each file represents a stock symbol containing end-of-day prices and trade data. I want to update one master Caspio Table that holds all stock symbols with the end-of-day prices and trade data.
1 vote -
1-to-Many Relationship in the Table Design tool
When creating a 1-to-many relationship in the Table Design tool, it would be more efficient if I could drag the Primary key from the Parent table, place it in the Child table, automatically change the Type to Text (255), and show the relationship connector with the appropriate "infinity" label at the Child end fo the connector.
1 vote -
Allow Bulk Editing of Records within Tables Datasheet View
Allow bulk editing of records within the Datasheet view of Tables. The ability to Filter records is there, but no way to update multiple fields of the filtered records.
1 vote -
Table Variable Headers
I would like to be able to create table variables for use in Triggers/Tasks that allow for changing the column headers. Currently table variable column headers use the field name in the table and this is usually not a readable, intuitive label to someone who might be sent a notification email.
1 vote -
Eliminate duplicate fields
I have several tables that reference each other. I really should not have a CourseNames field in more than one table, but because of the way the formula fields, views, lookups, etc. don't work well with other tables, I have to list those names in more than one table. This is not proper database protocol....and a Caspio expert told me that this is the only way to accomplish what I have to do.
1 vote -
Allow data type change from Text (64000) to GUID
Currently, when importing data from a CSV the GUID fields are auto-classified as Text (64000). When updating the table design one has to change the field to Text (255) first, then to GUID. Changing the data type on the import configuration doesn't help this either as the GUID specification import is overridden.
1 vote -
"Deselect all" button for tables in Relationship view
You can select "All relationships" in the view but then to undo that selection to deselect all of them and clear the canvas is a very time-consuming proccess.
1 vote -
Color Code Table Relationships
Color coding table relationships would make visualizing much easier to follow
1 vote -
compatible matching blocks when coding.
When you are creating triggers if the blocks that you can use after selecting the block you want to use are highlighted.
In the UI, all of the available blocks seem usable until you try and get an error. It's like when you have "assist" mode on when playing chess. It shows you all of the moves you can make instead of the ones you shouldn't have made. That would change my life lol.
1 vote
- Don't see your idea?