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. Trigger generated SQL

    Hi,

    can we have a way to see what SQL gets generated when we setup a trigger? this will help figure out logic issues and other small trigger issues for people who are familiar with SQL.

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
      • Recently my computer broke so I've been had to use Caspio on my phone and I found it really hard constantly having to zoom in to tap a b

        So I was thinking for like your phones tablets or computers it would auto fit your screen like it will automatically zoom in and size it based on the size of your screen for an example if you have a smaller screen the text will zoomed in a bit bigger instead of zoomed out where you have to zoom in

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

          9 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
          • 1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
            • Need to access password field in triggered action to filter if blank/not blank

              You make it impossible for us to determine if a customer activates his/her registration. Cannot filter on unblank password fields in triggered actions. Can't set a yes/no hidden field in password reset datapage (see other suggestion just added). Need these fields opened up!

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
              • Ability to add SQL to the table formula field for cross table calculations (like you can in a DataPage formula)

                Triggered actions are a great feature on their own and work well for new projects. However, they do not replace an SQL statement and only work for new records/actions.

                Someone else already commented this on a previous request (http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/16414099-can-we-add-sql-to-the-table-formula-field-for-cros) that was marked "complete".

                17 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                • Copy/Move Triggered Actions

                  the ability to copy or move the Triggered Actions from testing table to live table, since Caspio team advise to run the Triggered Actions on a testing table first and sometimes the Triggered Actions is complicated and there is a possibility to rebuild the Triggered Actions with missing pieces or rule.

                  9 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    3 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                  • 8 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      3 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                    • Provide a way to compact Tables to minimum size

                      Large Tables frequently take up more space than they should because some datapages, views, and relationships may have been deleted. Please provide a compaction feature

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                      • triggered actions "on update" fired on bulk edit/update.

                        triggered actions seems to be great idea.
                        but worthless if it is fired only on single update /for example through details page/

                        2 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                        • Add an new Triggered Action selector

                          It would be nice to have the ability to run a Triggered Action on only a single field being Updated. In this case I have a table which has a field which can contain the ID number for another user. This field might start out blank and can later be edited. None of the current selectors (less than, blank, exists, etc..) can accommodate a random value that you don't have any idea in advance what it might be. Might it be possible to have "Changed, or Unchanged" meaning compare the new value to the old value or lack of and…

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                          • drop and recreate the triggers

                            Triggers in database should be dropped and recreated while performing migration from one instance to another, right now it is creating duplicate trigger each time we migrate schema

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                            • Table relationships layouts that are saved should be specific to the current App chosen and not sun across all apps

                              Then you select "Relationships" and display the visual relationship map of the tables, that layout should be specific to the current App being worked on and not run across all apps.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                              • Allow editing across multiple Tables in View

                                Currently only one Table per View can be edited. This forces designers to create more DataPages then necessary to work around this shortfall. By allowing multiple Tables to be edited, designers could reduce the overall DataPage count.

                                20 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add file type to email triggers

                                  It would be beneficial to also have the "file" type field be sent as an attachment in the email triggers. This way, a user can essentially submit emails with an attachment.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow importing values into List datatype fields

                                    Currently, there is no way to bulk upload into this datatype via the Import feature in the bridge, even if the data is formatted right. Such table fields are simply invisible upon import, which makes it cumbersome to convert existing tables built before this feature was rolled out to utilize this leaner option.

                                    24 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                    • include a text field which can support 64000k plus text

                                      currently having a trigger for concatinating two fields but gives error of incompatible ntext.

                                      my trigger is like this

                                      SET a(64000) = concatenate a(64000) ';' b(255)

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Make it easier to reorder View fields

                                        For Views with many fields from many tables, it is very helpful to arrange the fields in a logical order, especially when adding a new column which by default goes to the end. At the moment, one has to use up and down arrows for this, which is very clunky and time-consuming for large Views. Please could you consider replacing the current fields control with one that allows the selected item to be dragged to a new position in the list.

                                        5 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 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.

                                          26 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            planned  ·  1 comment  ·  Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5
                                          • Don't see your idea?

                                          Feedback and Knowledge Base