Caspio Bridge

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. include a text field which can support 64000k plus text

    currently having a trigger for concatinating two fields but gives error of incompatible ntext.

    my trigger is like this

    SET a(64000) = concatenate a(64000) ';' b(255)

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

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

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

    3 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. Attach Object

    There is a way to detach an object from a specific App but there isn't a way to attach it to a specific App. You can Share the object but sometimes you simply want to move something to a specific App as part of house keeping.

    3 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. Add the ability to perform "star" ratings for reviewing a table entry.

    Today the user has the ability to rate a table entry using numbers, but how about what is common today for rating (like hotels, travel suggestions, etc.) is a 5 star rating.

    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 →
  10. All Assets - Additional Columns and Filter

    When looking at the All Assets view it would be helpful to have a column for DataPage. This way you could quickly see what is being used and if you have any orphan objects.

    Also there should be a way to filter objects by name and DataPage. This is helpful if you have large numbers of objects (either Shared or App specific).

    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. Pivot Tables Details and Sorting

    The new Pivot Table feature to view details is helpful, but when the details have thousands of records, it beats the purpose of a Pivot Table.

    Pivot Table Details should be able to be summarized just like it's parent pivot table so when we want to see details, we can see a few hundred rows rather than be stuck with the whole data table results.

    also a sorting feature that can sort values A-Z even when there is a grouping on the table would be great. Pivot tables can be sorted by values ONLY if there aren't any groupings. This…

    6 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 →
  12. Editable e-mail fields for scheduled task exports

    If I set up a scheduled task to e-mail a table or view, I have no way to edit the From, Subject, or Body fields. So I can't distinguish between different reports when they arrive in my inbox, and I can't provide instructions to the recipients about what to do with the attached files.

    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 →
  13. Revision history

    It would be great if it was possible to have a revision history for a given datafield together with a date and user stamp

    3 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. Pre-populating the labels from an Excel import

    When I import a table from Excel, the first row is generally the field names. I should be able to tell Caspio that the cells in the second row are the field labels.

    3 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. Ability to mark fields required when creating data tables (Same as NULL and NOT NULL at MS SQLServer Level)

    The front end has the ability to mark fields required from data page. Need the same at the table level. If the field is a required field at the table level should automatically be required in the data page.

    3 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. Lock fields instead of entire tables when custom programming uses a table.

    Currently, if professional service does any custom work (i.e. triggered action, etc) the entire table is locked and the user cannot do any further development using that table (i.e. cannot add fields, etc.). This causes users to have to submit tickets just to have a new field added. That can take from hours to days to get done through that process. This directly contradicts the use-case for Caspio which should allow users to develop their own apps.

    Previously users may have changed a field used in custom programming which would break the programming. A support ticket would then go in…

    3 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. 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. servant

    App which visitors can select food on at restaurant and appear the order in a kitchen screen

    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 →
  19. Allow vertical size of tables to be smaller

    Allow the table sizes in the relationship view to be smaller. Right now there is a limit on how short you can make the box and that makes it more difficult to see all the relationship connections. It would be nice if small tables didn't use up as much vertical real estate in the ERD.

    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 →
  20. Add a SUM field as a data type to perform cross-table tabulation

    I chose Caspio over a newer competitor of Caspio because I could have a LITTLE more latitude using Caspio....however, I nearly went with the competitor because they had a SUM field option, that I could set up in a separate table and sum amounts in another table based on criteria determined in my current table.

    This functionality is sorely missing. It was the basis of my first support ticket with Caspio. I was told "if you are looking to have a table value updated based on some action or value changed in a different table, this may require a trigger…

    0 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