150 results found

1. Allow filtering on List string fields

   When you want to filter a table, the List string fields don't appear in the "select field" dropdown list

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Add Function to display a message in Triggered actions

   It would be useful to be able to display a message when a triggered action runs and meets a certain condition.I could then inform the user of confirmation, actions required to rectify or warn them the other table did not update and why.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. I was getting duplicate name for the column header in table design view

   I think It was because I was swapping column headers with the same name and did not save in between each. the issue was that the first row for the first column would be the one highlighted in red. I nice feature would be to highlight the actual one.
   Also for it not to dumb all your work and just not let you save it....because when you do, all the work goes away, as another suggestion.. I should be good now thank you!

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Please allow incremental update of imported tables

   Once a large table is imported from Excel, please allow at least APPENDING to the table easily with only updated rows. For example, I have daily data and already imported historical data of 1M rows, I need just this month's rows.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Option to update record after email is sent

   There are a few instances where I have to send an email then update the record with a time stamp to show the email was sent so that we are not sending multiple emails.

   Caspio is pushing us to not use if statements but right now I have to for these. It would be great if we had an option to update a field after the email is sent successfully. If we could have that included in the email action then I could eliminate the If statements and hopefully increase the performance of my triggered action. An example of what I do now is attached.

   There are a few instances where I have to send an email then update the record with a time stamp to show the email was sent so that we are not sending multiple emails.

   Caspio is pushing us to not use if statements but right now I have to for these. It would be great if we had an option to update a field after the email is sent successfully. If we could have that included in the email action then I could eliminate the If statements and hopefully increase the performance of my triggered action. An example of what… more

   •  

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Provide a parameter for when a table was last updated.

   I update a certain table 1 time per week manually via import. After the import I need to enter 1, (or many) datapages that reference the table, and manually update HTML text field for "last updated MM-DD-YYYY).
   It would be nice to have system parameters for the tables that can give for example
   "last added record date"
   "last deleted record date"
   "last added or deleted record"
   or
   "last modified" (Any change to the data table)

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. The Ability To Stop A Trigger If No Conditions Are Met

   The use of CASE and IF/THEN statements in Triggers are very helpful - however, it would be nice if there was a logic block or something where we can STOP the trigger from executing.

   In example, if you have an email trigger with a conditional CASE statement in the body, and none of the conditions meet the CASE statement, a blank email will still be sent out. If I could use the ELSE part of the statement will a STOP function, there would be no problem.

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Image file as URL

   Instead of uploading image files to each file field, the ability to pass an image url only as file parameter is easier and space saving.

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Many-to-Many Relationship

   Caspio can only handle a "one-to-one" or a "one-to-many" relationship in a table field. As a result, creating a "many-to-many" relationship requires creating a third table.

   Competing database programs (even those that are less developed than Caspio) allow a table field to easily hold references to multiple other entries in another table -- i.e. a native many-to-many field. (Webflow, Knack, Bubble are other ones I've looked at, and they all had it).

   Increasingly, the world works in a "many-to-many" way. For example...
   - A blog post will have many categories
   - An article may have multiple authors
   - An event may have multiple locations
   - An individual may work for multiple employers

   If someone wanted to create these many-to-many relationships in Caspio, they currently have two options.

   Option 1: create a third table that sits in the middle of the two tables that need to have a many-to-many relationship. Limitations are:
   - Cumbersome and complex to set up and manage
   - Creating the many-to-many relationships during data entry requires establishing a separate entry form away from the main table entry form (since an entry form only applies to one table). This slows and complicates the data entry process.
   - Searching functionality on the many-to-many table requires workarounds. Let's say you have a search datapage for a table. That search datapage cannot refer to the many-to-many table since it will produce duplicates of results. So, you have to build multiple search pages.
   - To display the many-to-many relationship in a list or details datapage, you have to insert it as a iframe list datapage within the embedded list/details datapage. The iframe html formatting is very hard to get to match to the Caspio datapage formatting, so you need to therefore build the entire details page using html blocks.
   
   - If you have a dataset that needs multiple types of many-to-many relationships, the problems above compound in a very significant way.

   Option 2: use Caspio's List datatype. This datatype has some elements of a many-to-many relationship, and has been a lifesaver as otherwise I couldn't have gotten a basic version of my application to work. However it's an incomplete buildout, which Caspio itself noted in the release information 2 years ago. The limitations are:
   - There is no way to bulk replace or update the list fields in the table. The "search and replace" function does not work on this field. Nor do Tasks. So if you have a database with thousands of entries, and need to change a blog tag for example, you need to either:
   a) Go into each entry individually and change it; or b) Convert the datatype into text, do the search and replace, and then convert it back to list. This however is very tricky. When you convert the datatype it deletes any datapage reference, so all those need to be rebuilt. (I suppose you could duplicate the table, convert the list field to text, search and replace, convert back, then trade out the tables and hope nothing got screwed up.) Also, you can't use a comma in the list field, because that's what Caspio uses to recognize the separate elements of the list field. If you have a category called "Cats, Dogs, and Mice" when you convert it to text and back to list, you now have three separate categories: "Cats" "Dogs" "and Mice". Additionally, the search and replace functionality is very tricky, even with text, since it will replace fragments of words within entries. For example if you have "Big Green Building" and "Green Building" as two categories, and you do a global search and replace of "Green Building" only, it will impact both "Big Green Building" and "Green Building" even though you only want it to apply to the latter.
   - The list datatype can't be used in "Tasks" so you can't build a task to do something. For example, if in all the blogs with a tag of "Cats" you also later decide to have it also say "Animals"... again you have to go into each entry and manually add it.
   - In a search and report datapage, it forces you to list all of the list category options in the dropdown or listbox field -- you can't go in and set custom search options if you only want to show a selection of the categories, or order them a certain way. Again this is an issue in case you don't want to show every single option in the list field, in case you are developing some. To get around this you need to separate the search and report datapages using parameters (where the first is a submission form with virtual fields, and the second a report datapage that catches the search entries via parameters). This gets around it but then opens up another list of limitations and headaches.

   Caspio can only handle a "one-to-one" or a "one-to-many" relationship in a table field. As a result, creating a "many-to-many" relationship requires creating a third table.

   Competing database programs (even those that are less developed than Caspio) allow a table field to easily hold references to multiple other entries in another table -- i.e. a native many-to-many field. (Webflow, Knack, Bubble are other ones I've looked at, and they all had it).

   Increasingly, the world works in a "many-to-many" way. For example...
   - A blog post will have many categories
   - An article may have multiple authors
   - An event… more

   27 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. We would like to have the possibility of including a File field from a table in an email from a Trigger
    9 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Add new formula fields in views with more than one table

    It would be great I could create formula fields in views (with more than one table). This could make it possible to use, combine or calculate data from multiple tables in a formula.

    14 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Convert View to Table

    There have been a few instances I've ran into where it would be helpful to be able to convert a view to a table directly in Caspio rather than having to download the view and re-import it as a table.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Formula Field Width

    Increase the size of formula fields from 255 characters to at minimum 1,000 or greater. Some applications require generating a unique id from concatenated fields that exceed the current 255 characters limit.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Allow list strings read data from another table

    Allow 'list strings' in tables to read data from another table
    (instead import data).

    In many cases the list is incomplete after some hours. Because users have entered new data.

    For example:
    I need a the selection of multiple products, which is continuously extended.

    7 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Tables and Views  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Freeze first column in a TABLE (not a datapage 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 the first column, it would be tremendously easier.

    I posted this idea a long time ago and it is marked as completed, but it has not been done; I think you misunderstood my suggestion. I am referring to TABLES, not datapages or search results, but tables that hold the raw data.

    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… more

    7 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. SQL distinct for views

    Add a distinct records option to views. I'm aware of the requests at the report level, some / most of that need could be resolved if we could base that report on a view that has a "SELECT DISTINCT" enabled. Should be easy to implement?

    54 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    planned  ·  6 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. enable copy paste of fields between two tables AND capture the incompatible fields for correction during copy paste to avoid incompatibility

    enable copy paste of fields between two tables AND capture the incompatible fields for correction during copy paste to avoid incompatibility.
    Also, you can add "Insert Field" in grid edit and link that with table to enable addition of new fields with formulas in report mode.
    Note that your AGE formula doesn't work when DOB is selected as Text 255 with calendar pop up. This is due to difference how date is input by user but there should be a fix to deal with user input errors instead of reentry of all data using another datatype.

    Thank you.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. arabic localization

    Can we have arabic localization

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Make text comparison in triggers case sensitive.

    Make text comparison in triggers case sensitive.

    Our app tracks various activities and currently we are unable to track activity that involves changing lower case text to upper text and vice versa.

    For instance, we want to have
    A = a should be false
    A = A should be true

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Set default View for field lookups in datapages

    I know that you can use relationships to have a default dropdown for lookup fields, but it would be really useful to be able to actually have the field default to a View (not a table) and also be able to specify parent field, lookup values, and fields for display/saving.

    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Tables and Views  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close