Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
151 results found
-
include a text field which can support 64000k plus text
currently having a trigger for concatinating two fields but gives error of incompatible ntext.
my trigger is like this
SET a(64000) = concatenate a(64000) ';' b(255)
4 votes -
Copying the record from parent table to the child table and triggered action run in child table.
Sometimes we need to split the tables in some sections by creating a new child tables. But when we insert records from parent tables to child tables it is not possible to trigger an action because of currently triggered actions are limited to a maximum of one nested level. This limitation causes the app builders to create complex applıcations. Caspio needs to raise of number nested level otherwıse it is pointless to subscribe to this system.
16 votes -
Make it easier to reorder View fields
For Views with many fields from many tables, it is very helpful to arrange the fields in a logical order, especially when adding a new column which by default goes to the end. At the moment, one has to use up and down arrows for this, which is very clunky and time-consuming for large Views. Please could you consider replacing the current fields control with one that allows the selected item to be dragged to a new position in the list.
8 votes -
run a trigger after record is saved in the table
We need to create a record in the child table when a new record is inserted in the parent table. Since triggers operates with #inserted record (which is not inserted in the table yet) child record cannot be created (we use referential integrity)
16 votes -
Formula fields
Allow formula fields to work with other formula fields
8 votes -
search column feature in table when in Datasheet mode
Sometimes, I have large tables with more than 50 fields and I need to scroll to the right until I get the desired column, I would like to have a search column field which should take me to the column directly or maybe a filter to display certain columns when needed.
It will be also useful in Views.
3 votes -
Add filter Criteria for Previous Day | Previous Week | Previous Month | Previous Year
It's not possible to create a view for a date range that has already past.
Current Year|Month|Week|Day are all nice, but not effective when looking back at data.
4 votes -
Ability to sort View on specific field
When using a single table to store all my drop down values, it would be great to be able to sort on a custom column. There are times where sorting alphabetically is not the correct choice.
Also, if you could sort on a view it would be one less step to configure in the data page. It would help with reusability.
4 votes -
Enhance the View Criteria by using the trigger interface.
Instead of just having the current, kludgy view builder (that has very limited criteria capabilities when it comes to comparing dates in two tables) allow a user to opt to use the Trigger builder interface for building joins and setting criteria. This would dramatically increase the view building functionality.
4 votes -
connect list string datatype to a separate table
Add an ability to connect list string datatype to a separate table so that when I add records, the list will update
2 votes -
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 -
should have option to concatenate table columns into one colum like in sql c= (A+B) for string and number
many times we need to add two columns value into one let's say
there are two fields on which we need to apply unique which we need to do manually by javascript code on sumbmit event.2 votes -
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 -
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 -
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 -
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 -
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 -
semicolon seperator
Allow to use semicolon as field delimiter when importing files
4 votes -
Ability for App users to import data into tables
Ability to create a datapage for App users to import data into tables without using a scheduled task or having to log into caspio. App users can add data manually; why not have the ability for admin level users to import directly into the tables?
187 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
- Don't see your idea?