Caspio Bridge

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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.

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

    24 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 →
  7. 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 →
  8. Allow editing across multiple Tables in View

    Currently only one Table per View can be edited. This forces designers to create more DataPages then necessary to work around this shortfall. By allowing multiple Tables to be edited, designers could reduce the overall DataPage count.

    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 →
  9. 17 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 →
  10. 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 →
  11. using file field in triggered actions

    I'd like to copy inserted record including file field to another table

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

    the ability to copy or move the Triggered Actions from testing table to live table, since Caspio team advise to run the Triggered Actions on a testing table first and sometimes the Triggered Actions is complicated and there is a possibility to rebuild the Triggered Actions with missing pieces or rule.

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

    15 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 →
  16. 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.

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow formula fields to be linked with other tables

    Any formula field should be allowed to be used to join with other tables, of course, as long as all possible outputs of the function are of the same type (numeric value or text)

    12 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 →
  18. 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
    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 →
  19. Many-to-Many Relationship

    Caspio can only handle a "one-to-one" or a "one-to-many" relationship in a table field. As a result, creating a "many-to-many" relationship requires creating a third table.

    Competing database programs (even those that are less developed than Caspio) allow a table field to easily hold references to multiple other entries in another table -- i.e. a native many-to-many field. (Webflow, Knack, Bubble are other ones I've looked at, and they all had it).

    Increasingly, the world works in a "many-to-many" way. For example...
    - A blog post will have many categories
    - An article may have multiple authors
    - An event…

    11 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 →
  20. Run Tasks outside of Caspio Website

    I would like to see the ability to create a button/link to run a specific task inside of a Datapage. For example, I have many tasks that my staff need to run on demand. Currently, I have to set these tasks up to a schedule, or log in and run them on demand for my staff.

    If we had the option to add specific task buttons inside of datapages, or even a specific link that would trigger the task to run, then my staff could run these tasks as they complete their work.

    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 →
← Previous 1 3 4 5 6
  • Don't see your idea?

Feedback and Knowledge Base