Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
157 results found
-
Multiple fields for unique ID
Allow a combination of fields to be a composite key
In some cases we want a combination of values to be unique. A sample scenario is to ensure that there is one student, attending a particular class on a particular date. This can be achieved if the combination of StudentID, CourseID, and AttendanceDate are designated as key and hence they have to be unique. This is a valid Database concept and it will be great if Caspio implements it.I understand that the formula field is a work-around, but it is not proper database protocol. Rather than bogging down a…
2 votes -
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 -
Make it so Scheduled Import task can trigger Triggered Actions
Would love to have my triggered action being triggered whenever I update the table thru Scheduled import task. For example, I have table with my inventory report and is being updated via scheduled import task daily. It would be nice to add a "Updated as of (date/time the scheduled task was run).
9 votes -
"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 -
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 -
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 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 -
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 copy, cut and paste of task/triggered action elements
You might build a task and find you wish to use it as a triggered action instead - or vice versa.
Currently you have to rebuild from scratch....where if you could copy and paste the different logic sections it would speed up the process
40 votes -
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 -
create a way to set or change the password field to a default value
Idea explained in suggestion tile. Thanks.
2 votes -
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 -
enhance features under Tables
- allow one to freeze a column (e.g. the first 1 or 2 columns) on a Table
- allow one to sort by a column
4 votes -
13 votes
-
Extend Scheduled Tasks with files
Extend Scheduled tasks to export tables including connected files for use as a reliable backup
5 votes -
Expand field names to allow Arrays and enhance subsequent systems to use them
Currently field names are only directly useable if you know the name of them. When a table consists of a LOT of repeating fields, would be nice if we could address them in an ARRAY type of system...This a field of "GameName1" Could become "GameName[1]". Such a system would allow much easier Triggered Actions if we could make a FOR loop that could increment the field names to perform some task on multiple fields. This could also be very useful if JavaScript could access the fields in the same way, make coding scripts much faster on large sets of data.....
6 votes -
Make the way TASKS are written optional graphical or text based
Allow Task writing in text mode in stead of graphical blocks, so one can build an own library and copy past between tasks.
8 votes -
Increase the Capacity of Tasks / Triggered Actions beyond 10,0000 Records
The fact that tasks / triggered actions are limited to 10,000 records is quite limiting. Isn't a benefit of a cloud-based solution that there is unlimited computing power? In my opinion, there's no reason why this isn't possible.
3 votes -
Enable copy and paste directly from and into tables
I suggest enabling direct copy and paste from (Excel or Access) to Caspio tables.
5 votes -
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
- Don't see your idea?