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

20 results found

  1. triggered action comments

    Triggered action logic can get quite long and complex. To make it easier to understand when another developer looks at it or I return a few weeks later it really needs a way of adding comments. At the moment I put comments next to sections using a text box disconnected from the build.

    This is not ideal as it needs to be manually moved around as you add extra sections before that location.

    Please add a way to comment on the code. Just a comment block that can be added into the logic that doesn't do anything would work.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    Thank you for your feedback. The comment feature is available for each Triggered Action block. Follow the steps below to add or remove a comment:

    To Add a Comment:

    1. Right-click on any Triggered Action block to display the action menu.
    2. Select "Add Comment" from the menu to add a comment to the block.
    3. Once a comment is added, click on the [i] icon in the top left corner of the block to view or edit the comment.

    To Remove a Comment:

    1. Right-click on any Triggered Action block to display the action menu.
    2. Select "Remove Comment" to delete the comment from the block.
  2. Option to parse each row of a table into it's own PDF.

    I'd like to be able to select multiple rows in a table and then have the ability to parse each row into a separate PDF file. Instead of all selected rows going into one PDF.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. Freeze first column in a 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…

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  4. 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 only one record per facility per year. This can be achieved if the combination of facility and year are designated as key and hence they have to be unique. This is a valid RDBMS concept and it will be great if Caspio implements it.

    111 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. Can we add SQL to the table formula field for cross table calculations?

    Now that we have a formula field which is great for in table calculations can we take the logic step and include SQL commands or soem form of macro that would allow cross table calculations to be stored in table.

    For example at present we can SUM a range of records from any table or view using the calculations field, but the performance is slow i'd say. But to be able to do the same in table, would make a significant improvement to performance and functionality.

    56 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. Improvided Search Capability

    Need ability to search data by selecting specific column, say if I look for 50 in ID column, I don't want 50 in any other columns or data fie;d
    Once it finds that 50 in say the ID column, I want it to take me to that row/record

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    Hi,

    This feature is already available in your account. To search for the data in a specific column, click on any cell in that column and select “Current column” in “Search range” drop down to search data for currently selected column.

    Thanks,
    Support Team

  7. In a View, criteria does not seem to allow the comparision of two records in the same row

    In the View setup, under the "Field Properties" window there is an option to create criteria using "and" or "or" conditions.

    My requirement is to compare two field values in the same record. For example:
    Field 1 : DueAmount
    Field 2: Paid
    Amount
    My criteria is DueAmount > PaidAmount

    Currently it seems that I can only do :
    Due_amount > " " Where " " could be a value (e.g. 600)

    This is badly needed to add more data flexibility to views

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  8. Would it be possible to have the option to make a formula field in a table a unique ID?

    I love the new Caspio Bridge 9.4 feature where one can have formula fields in tables, but here's something that would make it even better: the ability to make it a unique ID if at all possible

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. Ratio Calculation in Pivot Tables

    Pivot Tables should have the ability to divide two aggregations rather than dividing each individual record and then using a SUM function, which gives the wrong result.

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  10. Enable GUID creation natively in tables

    Have table autonumbers support GUID/UUID format natively, rather than doing this through a form submission. This protects parameter-based applications from malicious URL forming.

    I use GUIDs in all of my table constructs to prevent this - but it prevents me from importing data directly into Caspio tables.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  11. Radar or Spider Charts

    I'd like to have a chart similar to Excel's Radar Chart so that people could look at and compare results for survey data, customer satisfaction... across a few subjects where the rating is the same. E.g., a Likert scale question on customer satisfaction for subjects such as value, cost, quality... they could then see the percent of respondents who said "satisfied" for 5 or 6 questions/subjects simultaneously.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  12. Sequence generator needed for key data items.

    Using Autonumber is not desirable to use as a key-field in a table as a related field to another.
    First, Caspio allows the user to re-number, although with warnings, it could still corrupt your database with orphan links left behind. Also you can only create a join with another like "autonumber" (can't use a number field).

    Suggest a fix for above, or create a new sequence generator similar to what Oracle has.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  13. Dropdown menus for related fields in child tables

    We do some data entry directly into tables. For child tables, I just discovered the checkmark to "Enforce Referential Integrity", in order to ensure that related data gets connected. But it still requires that you know, or look up, the exact spelling, etc. of the data you want to put in that field. If, when Referential Integrity is Enforced, the child table displayed a dropdown menu instead of a text box, data entry would be faster and less error prone.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  14. Unique data table entries, not just unique fields

    Add an option to force Unique data table entries, not just unique fields.

    For example,
    These two entries can not be added
    Remote Diagnostics, USA, New Jersey, and Toms River
    Remote Diagnostics, USA, New Jersey, and Toms River

    But These two entries can be added,
    Remote Diagnostics, USA, New Jersey, and Toms River
    Remote Diagnostics, USA, Georgia, and Toms River

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. to be able to make a table join with itself.

    ...so that we don't need to upload two table for hierarchies...

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  16. Mass download and mass delete files

    We purge our applicant data each year. It would be great to have a function that allows you to mass download and mass delete files.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    Since 8.0 in November of 2013 mass download and upload of files is available. Mass delete is also available through deleting a folder in the file section or enabling Orphan File Cleanup by contacting support.

  17. Lookup Field

    Hello,
    When I create a relatioship between two tables I get a lookup field in child table, perfect. It would be nice if Caspio designers/engineers could allow us to filter the data being pulled in the lookup field. Currently all the data is coming in from the parent in the lookup, but what if I wanted certain data only.
    Let me know if this is already possible since I am buidling my first Caspio system and pretty new at this.

    Thanks.
    Iram/mcp

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. Import Update (Not Append or Replace)

    There should be an option when we import information from say Excel into a Caspio Table to Update current information, NOT have to Replace everything. For instance, if I have to add a field to a table, it is easier to export, make the changes in Excel and then would like the option import the information while only updating the selected information into a specified table.

    64 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  19. Calculated field to be stored in table

    Be able to store the calculated field in the table upon submission or update or basically to be able to define table level calculation and formula

    164 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  • Don't see your idea?

Feedback and Knowledge Base