Caspio Bridge
Welcome to Caspio Bridge Ideabox. We love to hear your improvement ideas.
19 results found
-
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 votesThank you for your idea. With Document Generation feature, you now can generate a PDF for each row in a report based on a predefined template.
-
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 votesThank you again for this idea. The feature is now available in all accounts. More information can be found at http://howto.caspio.com/datapages/reports/fixed-rows-and-columns/
-
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 votesIn recent 9.8 release, unique attribute is now available for Formula Field which can be used as a composite key. More information can be found at http://howto.caspio.com/release-notes/caspio-bridge-9-8/
Thank you again for your idea. This idea is now closed. -
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 votesWith the introduction of Triggered Actions, it is possible to perform complex calculations and logic at table level. More information can be found at https://howto.caspio.com/tables-and-views/triggered-actions/.
-
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/record1 voteHi,
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 -
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: PaidAmount
My criteria is DueAmount > PaidAmountCurrently 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 votesThank you again for your idea. The feature is now available in Caspio Bridge 12.0
-
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 votesThank you for the idea. This feature is now available in all accounts.
-
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 votesThank you again for this idea. The feature is now available.
-
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 votesWe are happy to let you know that the feature has been available since September of 2015. Sorry for the late notification. More details at http://howto.caspio.com/release-notes/caspio-bridge-8-8/
-
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 voteThank you again for this idea. Radar Chart is now available in all accounts. More information about the Chart DataPages can be found at http://howto.caspio.com/datapages/charts/.
-
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 voteWe are happy to let you know that the feature has been available since September of 2015. Sorry for the late notification. More details at http://howto.caspio.com/release-notes/caspio-bridge-8-8/
-
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 votesIn relationship dialog window, you can pick a field in the “Value for display in Related field” dropdown to enable the lookup dropdown in child tables.
-
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 RiverBut These two entries can be added,
Remote Diagnostics, USA, New Jersey, and Toms River
Remote Diagnostics, USA, Georgia, and Toms River11 votesThis can be achieved with unique attribute in Formula Field. More information can be found at https://howto.caspio.com/tables-and-views/data-types/formula-fields/
-
to be able to make a table join with itself.
...so that we don't need to upload two table for hierarchies...
6 votesThank you again for this idea. Self-joins is now implemented and available in all accounts. Look for the feature in Views.
-
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 voteSince 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.
-
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/mcp1 voteIram, this feature is already available in Caspio. Our support will follow up with you directly. Thanks.
-
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 votesThe feature is now available in Bridge 8.3 version released in September of 2014.
-
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 votesThank you again for this idea. The feature is now available in all accounts. Look for new Formula Field data type in Table Design. More information can be found at http://howto.caspio.com/tables-and-views/data-types/formula-fields/
-
6 votes
Thank you again for this idea. The feature is now implemented and available in all accounts
- Don't see your idea?