Caspio Bridge

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

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Option to create Formulas inside Views.

    For example:
    I have Users and Roles tables. One to may relationship from Roles to Users but I would like to have a dropdown that reads Username (Role) but that is not possible unless we could have the ability to create Formulas in our views.

    I think this will increase usability a lot.

    7 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      planned  ·  0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
    • Ability to sort View on specific field

      When using a single table to store all my drop down values, it would be great to be able to sort on a custom column. There are times where sorting alphabetically is not the correct choice.

      Also, if you could sort on a view it would be one less step to configure in the data page. It would help with reusability.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
      • 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
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
        • 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
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
          • 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
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
            • 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
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
              • 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…

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                • 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.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                  • should have option to concatenate table columns into one colum like in sql c= (A+B) for string and number

                    many times we need to add two columns value into one let's say
                    there are two fields on which we need to apply unique which we need to do manually by javascript code on sumbmit event.

                    2 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                    • Union Views/Queries

                      It would be valuable to be able to use a union query to combine multiple queries into a single result. For example, suppose your database has two unrelated tables where one stores customer data and another stores data about suppliers – and both tables have a contact information field. You’d like to see the contact information from both tables in one view. We cannot do this today in Capsio like we can in SQL Server or even MS Access. To do this, we would need to create a view for each table to retrieve the contact information, and then combine…

                      12 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                      • 1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                        • servant

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

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                              • Apply SQL 'AND' clause when creating a view

                                This would be helpful for restricting tables before doing the join when creating a view. A possible workaround would be giving the option to link a view with a view. This is very valuable for historical type tables.

                                For example:

                                I have 2 tables, I need to filter table 1 before joining with table 2.

                                Customer table:

                                Customer | State
                                -------------------------
                                A | S
                                B | V
                                C | L

                                Entry table

                                Customer | Entry | Category
                                -------------------------------------
                                A | 123 | D
                                A | 325 | C
                                A | 496 | D
                                A | 3874 | M
                                B |…

                                3 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                • Password protected table from deletion that can maximize security

                                  I would like to see if the table that can be protected from deletion without putting passcode or password of the author or admin for maximum table security. Because if the table deleted all things are gone.

                                  4 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow Folders/Organization in Views

                                    Allow Views to be arranged/organized into Folders of View. This should be a simple fix.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Move Up / Move Down option in Tables datasheet view

                                      There needs to be a Move Up / Move Down option in Tables datasheet view. I created a lookup table called in from a Form field multiple choice. The only sort options are alphabetical. Tech support said thats my only option except delete all the table datasheet entries and redo them in the order you want. Not ideal if I have 50 entries and/or add to it occasionally. With each new option I have to rebuild the table? An Insert Here or Move Up/Down option would be fantastic here.

                                      2 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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 : Due_Amount
                                        Field 2: Paid_Amount
                                        My criteria is Due_Amount > Paid_Amount

                                        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

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                        • We should be able to develop app with dynamic search bar displayed with results without using another data page

                                          At the moment, through viewing your ready-made apps and tutorials, we need to use up a DataView from our limited (5) dataviews when you create a search display simply to be able to have the search and results on the same page. This seems very restrictive.
                                          You should be able to have a setting to display search and results on the same page without this extra data page.

                                          8 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base