Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
146 results found
-
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 -
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…
63 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.
1 vote -
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 -
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…
21 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?
163 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.1 vote -
allow views on views, so the data source design can effectively become a bit more "object-oriented" and more maintainable
and also allow "full SQL" definition of views - set unions, set differences etc.; plus creation of combination / concatenation fields in views; would be great in itself but also provide solutions to some of the front end limitations like drop downs can't be sorted on some other field etc.
7 votes -
Filter a View by comparing two fields like a calculation.
For example. I would like to be able to create a view by comparing two separate fields.
- Field1 Equal to Field2...
- Field1, Greater Than or Equal to Field2..
- [Sale_Price] - [Cost] < "500"
- [LastImportDate] = Max of [LastImportDate]
Examples, COST vs SALE PRICE. Create a filter that allows me to show
9 votes - Field1 Equal to Field2...
-
allow copy/paste data from Excel into Caspio tables
I move data around a lot between Excel spreadsheets with copy/paste. I'd like to put some of these spreadsheets online with Caspio, but the inability to copy/paste from Excel to a Caspio table is a serious obstacle.
4 votes -
Add SQL capability when creating a new View.
Add SQL capability when creating a new View. I believe this would be very useful to generate aggregate totals like:"Max(), Sum(), Exists" and concatenation of values. This view should also be available for scheduled downloads .
12 votes -
Ability to have calculated fields on a view.
In SQL I can create calculated fields for a view it would be nice to be able to do that same thing in Caspio view.
136 votesThank you for this idea. We are looking into adding this feature in future product updates.
-
Create a JSON output feed from views or tables
What would really make Caspio powerful is to have a way to create a JSON and/or XML view of data that could be accessed dynamically by web applications. I want more flexibility in how I present data, and I'm willing to develop that myself, but I could still use Caspio as a back end to enter and manage and store data, without having to build that infrastructure myself every time.
19 votes -
Date format in table
It is a good feature if the Date format can be changed in the table level. Currently, the date values are stored in the tables in the format MM/DD/YYYY.
22 votes -
add a semicolumn as separation character for importing ,csv files
self-eplanatory, I think
1 vote -
Need to access password field in triggered action to filter if blank/not blank
You make it impossible for us to determine if a customer activates his/her registration. Cannot filter on unblank password fields in triggered actions. Can't set a yes/no hidden field in password reset datapage (see other suggestion just added). Need these fields opened up!
1 vote
- Don't see your idea?