Skip to content

Caspio Bridge

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

149 results found

  1. Add Weekday function

    It would be helpful to have a Weekday function (like in Excel and Access) that assigns a numeric value to the day of the week on which a date occurs (1 = Sunday, 2 = Monday, etc).

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Add Nil As A Boolean Option

    This is a pretty boring change but it will clean up Datapages. A Boolean is the Yes/No Datatype. In most databases a Boolean has three options TRUE, FALSE, and NIL (blank). Adding NIL would be important as we could then hide empty Yes/No values on Datapages and empty Yes/No's wouldn't count against our Data Records.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. make a read-only view of data tables

    The data sheet UI is automatically editable, making it far too easy to accidentally make a change.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Allow unequal joins

    Unequal joins are not common, but when you need them, there are no good workarounds. They can do some magical things very efficiently.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. compatible matching blocks when coding.

    When you are creating triggers if the blocks that you can use after selecting the block you want to use are highlighted.

    In the UI, all of the available blocks seem usable until you try and get an error. It's like when you have "assist" mode on when playing chess. It shows you all of the moves you can make instead of the ones you shouldn't have made. That would change my life lol.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Make a filter to sort by latest entry in the datatable

    Like the title says, make it so we can sort by the items that were last added to the datatable. Its basically the reverse of "sort by: none".

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Add a better field type for arrays/lists/collections

    Right now the list data type can't be used as a true collection. For instance:

    What if you have a collection of orders, and each order is for a number of products?

    I'd like there to be a field called 'products' in the orders table which would be either a list of strings, or better yet a list of references to a products table.
    Instead, you can't add strings unless they were added in Caspio Bridge in advance. Worse, the only way to edit a string list is to check them off from a complete dropdown/listbox of all possible products,…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Tasks to run yearly

    Currently tasks can only be automated to run, daily, weekly and monthly but not yearly...

    We need tasks to run yearly, some applications need this and you cant automate manually at the beginning of each year. it defeats the point and purpose of automation

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Color Code Table Relationships

    Color coding table relationships would make visualizing much easier to follow

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Organize tables via Folders

    I think it will be a good idea to have an option to create folder in tables.
    In this way it will be easier to manage, sort, find and organize tables inside Caspio.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. SysDateTime in Formula fields

    I understand that currently the SysDateTime function is not available in formula fields. It would be great if this could be supported for calculating time differences at the table level between start dates and now.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. differentiate unused fields

    We would like to be able to differentiate in a table which fields are not used anywhere, neither views, nor Datapages, nor Triggers, nor Tasks.
    Many times the tables get fat and there are fields that are ultimately useless.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. Table Variable Headers

    I would like to be able to create table variables for use in Triggers/Tasks that allow for changing the column headers. Currently table variable column headers use the field name in the table and this is usually not a readable, intuitive label to someone who might be sent a notification email.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Make it so Scheduled Import task can trigger Triggered Actions

    Would love to have my triggered action being triggered whenever I update the table thru Scheduled import task. For example, I have table with my inventory report and is being updated via scheduled import task daily. It would be nice to add a "Updated as of (date/time the scheduled task was run).

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. "Deselect all" button for tables in Relationship view

    You can select "All relationships" in the view but then to undo that selection to deselect all of them and clear the canvas is a very time-consuming proccess.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Allow data type change from Text (64000) to GUID

    Currently, when importing data from a CSV the GUID fields are auto-classified as Text (64000). When updating the table design one has to change the field to Text (255) first, then to GUID. Changing the data type on the import configuration doesn't help this either as the GUID specification import is overridden.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Eliminate duplicate fields

    I have several tables that reference each other. I really should not have a CourseNames field in more than one table, but because of the way the formula fields, views, lookups, etc. don't work well with other tables, I have to list those names in more than one table. This is not proper database protocol....and a Caspio expert told me that this is the only way to accomplish what I have to do.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Multiple fields for unique ID

    Allow a combination of fields to be a composite key
    In some cases we want a combination of values to be unique. A sample scenario is to ensure that there is one student, attending a particular class on a particular date. This can be achieved if the combination of StudentID, CourseID, and AttendanceDate are designated as key and hence they have to be unique. This is a valid Database concept and it will be great if Caspio implements it.

    I understand that the formula field is a work-around, but it is not proper database protocol. Rather than bogging down a…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Allow Bulk Editing of Records within Tables Datasheet View

    Allow bulk editing of records within the Datasheet view of Tables. The ability to Filter records is there, but no way to update multiple fields of the filtered records.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 1-to-Many Relationship in the Table Design tool

    When creating a 1-to-many relationship in the Table Design tool, it would be more efficient if I could drag the Primary key from the Parent table, place it in the Child table, automatically change the Type to Text (255), and show the relationship connector with the appropriate "infinity" label at the Child end fo the connector.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

Feedback and Knowledge Base