Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
162 results found
-
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 -
Fix a bug where datasheet only displays date when other parts of timestamp still exist
https://forums.caspio.com/topic/8867-insert-current-date-automatically/?do=findComment&comment=28142
I implemented the above solution in order to insert just the date for a particular column. However, upon creating a task that included a date comparison on that column, we found that matches were not being made correctly because we didn't remove milliseconds as well. This took some trial and error since the datasheet was only showing the date part of the timestamp, even though milliseconds were not 000.
4 votes -
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 -
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 -
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 -
Many-to-Many Relationship
Caspio can only handle a "one-to-one" or a "one-to-many" relationship in a table field. As a result, creating a "many-to-many" relationship requires creating a third table.
Competing database programs (even those that are less developed than Caspio) allow a table field to easily hold references to multiple other entries in another table -- i.e. a native many-to-many field. (Webflow, Knack, Bubble are other ones I've looked at, and they all had it).
Increasingly, the world works in a "many-to-many" way. For example...
- A blog post will have many categories
- An article may have multiple authors
- An event…30 votes -
Allow filtering on List string fields
When you want to filter a table, the List string fields don't appear in the "select field" dropdown list
4 votes -
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 -
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 -
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 -
SQL distinct for views
Add a distinct records option to views. I'm aware of the requests at the report level, some / most of that need could be resolved if we could base that report on a view that has a "SELECT DISTINCT" enabled. Should be easy to implement?
54 votes -
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 -
The Ability To Stop A Trigger If No Conditions Are Met
The use of CASE and IF/THEN statements in Triggers are very helpful - however, it would be nice if there was a logic block or something where we can STOP the trigger from executing.
In example, if you have an email trigger with a conditional CASE statement in the body, and none of the conditions meet the CASE statement, a blank email will still be sent out. If I could use the ELSE part of the statement will a STOP function, there would be no problem.
3 votes -
Add new formula fields in views with more than one table
It would be great I could create formula fields in views (with more than one table). This could make it possible to use, combine or calculate data from multiple tables in a formula.
14 votes -
Image file as URL
Instead of uploading image files to each file field, the ability to pass an image url only as file parameter is easier and space saving.
4 votes -
Option to update record after email is sent
There are a few instances where I have to send an email then update the record with a time stamp to show the email was sent so that we are not sending multiple emails.
Caspio is pushing us to not use if statements but right now I have to for these. It would be great if we had an option to update a field after the email is sent successfully. If we could have that included in the email action then I could eliminate the If statements and hopefully increase the performance of my triggered action. An example of what…
2 votes
- Don't see your idea?