Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
157 results found
-
Add file type to email triggers
It would be beneficial to also have the "file" type field be sent as an attachment in the email triggers. This way, a user can essentially submit emails with an attachment.
9 votes -
Provide a way to compact Tables to minimum size
Large Tables frequently take up more space than they should because some datapages, views, and relationships may have been deleted. Please provide a compaction feature
2 votes -
Option to create Formulas inside Views.
For example:
I have Users and Roles tables. One to may relationship from Roles to Users but I would like to have a dropdown that reads Username (Role) but that is not possible unless we could have the ability to create Formulas in our views.I think this will increase usability a lot.
46 votes -
Add an new Triggered Action selector
It would be nice to have the ability to run a Triggered Action on only a single field being Updated. In this case I have a table which has a field which can contain the ID number for another user. This field might start out blank and can later be edited. None of the current selectors (less than, blank, exists, etc..) can accommodate a random value that you don't have any idea in advance what it might be. Might it be possible to have "Changed, or Unchanged" meaning compare the new value to the old value or lack of and…
2 votes -
using file field in triggered actions
I'd like to copy inserted record including file field to another table
41 votes -
Allow importing values into List datatype fields
Currently, there is no way to bulk upload into this datatype via the Import feature in the bridge, even if the data is formatted right. Such table fields are simply invisible upon import, which makes it cumbersome to convert existing tables built before this feature was rolled out to utilize this leaner option.
28 votes -
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
- Don't see your idea?