Caspio Bridge

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. Please allow incremental update of imported tables

    Once a large table is imported from Excel, please allow at least APPENDING to the table easily with only updated rows. For example, I have daily data and already imported historical data of 1M rows, I need just this month's rows.

    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. The Ability To Stop A Trigger If No Conditions Are Met

    The use of CASE and IF/THEN statements in Triggers are very helpful - however, it would be nice if there was a logic block or something where we can STOP the trigger from executing.

    In example, if you have an email trigger with a conditional CASE statement in the body, and none of the conditions meet the CASE statement, a blank email will still be sent out. If I could use the ELSE part of the statement will a STOP function, there would be no problem.

    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 →
  4. Option to update record after email is sent

    There are a few instances where I have to send an email then update the record with a time stamp to show the email was sent so that we are not sending multiple emails.

    Caspio is pushing us to not use if statements but right now I have to for these. It would be great if we had an option to update a field after the email is sent successfully. If we could have that included in the email action then I could eliminate the If statements and hopefully increase the performance of my triggered action. An example of what…

    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. Provide a parameter for when a table was last updated.

    I update a certain table 1 time per week manually via import. After the import I need to enter 1, (or many) datapages that reference the table, and manually update HTML text field for "last updated MM-DD-YYYY).
    It would be nice to have system parameters for the tables that can give for example
    "last added record date"
    "last deleted record date"
    "last added or deleted record"
    or
    "last modified" (Any change to the data table)

    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 →
  6. 9 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. Add new formula fields in views with more than one table

    It would be great I could create formula fields in views (with more than one table). This could make it possible to use, combine or calculate data from multiple tables in a formula.

    8 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. Image file as URL

    Instead of uploading image files to each file field, the ability to pass an image url only as file parameter is easier and space saving.

    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. Convert View to Table

    There have been a few instances I've ran into where it would be helpful to be able to convert a view to a table directly in Caspio rather than having to download the view and re-import it as a table.

    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. Formula Field Width

    Increase the size of formula fields from 255 characters to at minimum 1,000 or greater. Some applications require generating a unique id from concatenated fields that exceed the current 255 characters limit.

    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. Allow list strings read data from another table

    Allow 'list strings' in tables to read data from another table
    (instead import data).

    In many cases the list is incomplete after some hours. Because users have entered new data.

    For example:
    I need a the selection of multiple products, which is continuously extended.

    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 →
  12. Freeze first column in a TABLE (not a datapage table)

    I'd like to be able to "freeze" the first column in a table, so that as I scroll across the table, I can always see the first column (which indicates the name of the record).

    Sometimes we have a lot of editing to do, and it's easiest to do it in the table. And sometimes, we want to copy the same info into a field for several records. But since we can't see the "Names" of the records (that are in the first column) as we scroll across, we can't accurately past info into the fields. If we could freeze…

    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 →
  13. SQL distinct for views

    Add a distinct records option to views. I'm aware of the requests at the report level, some / most of that need could be resolved if we could base that report on a view that has a "SELECT DISTINCT" enabled. Should be easy to implement?

    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 →
  14. 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 →
  15. Caspio supported digital signature capture

    It would be great if there was a datatype for signatures so that you could capture signatures natively in the Caspio application.

    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 →
  16. Style Preview Links to Style Elements

    Create links in the Style Preview that take you directly to the Style Element you would like to modify.

    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 →
  17. enable copy paste of fields between two tables AND capture the incompatible fields for correction during copy paste to avoid incompatibility

    enable copy paste of fields between two tables AND capture the incompatible fields for correction during copy paste to avoid incompatibility.
    Also, you can add "Insert Field" in grid edit and link that with table to enable addition of new fields with formulas in report mode.
    Note that your AGE formula doesn't work when DOB is selected as Text 255 with calendar pop up. This is due to difference how date is input by user but there should be a fix to deal with user input errors instead of reentry of all data using another datatype.

    Thank you.

    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. 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 →
  19. arabic localization

    Can we have arabic localization

    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. Make text comparison in triggers case sensitive.

    Make text comparison in triggers case sensitive.

    Our app tracks various activities and currently we are unable to track activity that involves changing lower case text to upper text and vice versa.

    For instance, we want to have
    A = a should be false
    A = A should be true

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

Feedback and Knowledge Base