Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
-
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?
148 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.
133 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.
16 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 -
Caspio must support "group by" and Calculations in views, not only in datapages.
This option will allow us to create views that groups the records of a big table based on some distinct criteria. Also it is necessary to make simple calculations such us sum, or count in our tables without the need of datapages.
94 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…
1 vote -
drop and recreate the triggers
Triggers in database should be dropped and recreated while performing migration from one instance to another, right now it is creating duplicate trigger each time we migrate schema
1 vote -
Use views in triggers
You can currently only reference tables when building a trigger. Adding the ability to reference Views from triggers would be very helpful, rather than having to rebuild a view's functionality in the Trigger.
0 votes -
Default table fields
How about having a global option to set default field names and types so everytime I create a new table, all these fields are automatically created.
For example, I always use ID(autonumber), Createdon(Timestamp), Createdby(Text), etc.. in all my tables but I need to create them all or have an empty copy of the table and duplicate it, it would be nice to have a default table fields location to define "common" fields.
3 votes -
Export photos
I want to scheduled a daily task to export all new files which were uploaded that day. Currently I receive a daily file of the data in my tables, but not files. For my business, I really need an incremental file with files (in my case photos) for Caspio to be more efficient.
2 votes
- Don't see your idea?