Caspio Bridge

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Apply SQL 'AND' clause when creating a view

    This would be helpful for restricting tables before doing the join when creating a view. A possible workaround would be giving the option to link a view with a view. This is very valuable for historical type tables.

    For example:

    I have 2 tables, I need to filter table 1 before joining with table 2.

    Customer table:

    Customer | State

    A | S
    B | V
    C | L

    Entry table

    Customer | Entry | Category

    A | 123 | D
    A | 325 | C
    A | 496 | D
    A | 3874 | M
    B | 3478 |…

    3 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. Password protected table from deletion that can maximize security

    I would like to see if the table that can be protected from deletion without putting passcode or password of the author or admin for maximum table security. Because if the table deleted all things are gone.

    4 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 →
  3. Allow Folders/Organization in Views

    Allow Views to be arranged/organized into Folders of View. This should be a simple fix.

    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 →
  4. 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.

    2 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 →
  5. We should be able to develop app with dynamic search bar displayed with results without using another data page

    At the moment, through viewing your ready-made apps and tutorials, we need to use up a DataView from our limited (5) dataviews when you create a search display simply to be able to have the search and results on the same page. This seems very restrictive.
    You should be able to have a setting to display search and results on the same page without this extra data page.

    8 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 →
  6. 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.

    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 →
  7. Move up/move down arrows on join page in view setup

    Currently when setting up views, the order of the table joins cannot be altered. When a modification has to be made to the joins in a certain order, all joins below the one to be modified or added must be deleted and re-added.

    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 →
  8. 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.

    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 →
  9. Apply localizations to views and tables

    It would be great to apply things like custom time zones to tables and views.

    6 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 →
  10. semicolon seperator

    Allow to use semicolon as field delimiter when importing files

    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 →
  11. Better SQL features. DELETE query (esp for duplicates). UPDATE query for mass updates

    Deleting duplicates in a table requires a filter and checkbox deletion by hand. Updates can only be made outside of Caspio and re-imported. These basic execution SQL functions should be enabled in some form other than imports.

    Especially with big data, using imports to update and delete tables is tedious at best and unachievable at worst.

    2 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 →
  12. 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
    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. create a pivot table View

    The filtering logic for views is great. Adding pivot tables in views would allow pivot tables to be exported, referenced or accessed via API.

    2 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 →
  14. 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. Move a record from a table to another

    Hello,
    would be nice to have an option to move a record from a table to another.
    In my case for example, when I want to blacklist a record I have on my table, I move it to a Blacklist table to then make sure with a view between the two tables that the blacklisted company is not registered again in the first table.

    Right now we need to export/download the data, delete the record in the first table, then import it on the new table, quite time consuming.

    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 →
  16. Ability to colour code data pages, tables, views for a quick reference.

    In most cases, large and/or complex applications built on multiple data pages, views and tables etc. While building such applications also creates multitude of waste such as redundant data pages, tables, views etc.

    In my opinion It would be good to have a function to colour code data pages, views, tables etc. to have a quick reference point on what is okay and not okay to delete. What data pages, views, tables are redundant in the process an what aren't!

    2 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 →
  17. Search for identical data in separate tables

    How do I get Caspio to search two separate tables and report identical information found in both?

    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. It would be great if a table field could be set with a default value or do a calculation on update.

    If you use importing to get data into a table you can't interact with the data without manual intervention. That defeats the purpose of automatic importing or importing at al really.

    4 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. 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 →
  20. Many-to-Many Relationships - Views as a source for a view

    Many-to-Many relationships are powerful for many reasons; in particular action items that have many users that interact with them.

    Please consider this scenario:

    tblActionLog
    FielduserCreator
    Field
    userAssigned
    Field_userCompleter
    ...

    A report to display all three users would be very useful, and an easy approach (easy from our end, IDK what this would require from your end) would be to use three User table views as a source for the view that would be the source for the report.

    viewUserCreator, viewUserAssigned, viewUserCompleter, tblActionLog -> sources for viewActionLogReport

    Thanks for your consideration
    CHAD

    5 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 →
  • Don't see your idea?

Feedback and Knowledge Base