Caspio Bridge

Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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…

    44 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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…

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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…

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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?

    72 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.


    1. Field1 Equal to Field2...

    2. Field1, Greater Than or Equal to Field2..

    3. [Sale_Price] - [Cost] < "500"

    4. [LastImportDate] = Max of [LastImportDate]

    Examples, COST vs SALE PRICE. Create a filter that allows me to show

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    108 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    13 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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.

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  13. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  15. Ability to add SQL to the table formula field for cross table calculations (like you can in a DataPage formula)

    Triggered actions are a great feature on their own and work well for new projects. However, they do not replace an SQL statement and only work for new records/actions.

    Someone else already commented this on a previous request (http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/16414099-can-we-add-sql-to-the-table-formula-field-for-cros) that was marked "complete".

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

    77 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    11 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  18. Unique values in view

    Instead of filtering by duplicates, I would like to return only the unique values - that is, I would like to hide the duplicates and show only the unique values for a particular field (this would be the inverse of the current "filter by duplicates" option).

    23 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base