1149 results found

1. 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

   30 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

   Submit Rating

2. 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

   Submit Rating

3. Enable setting OnLoad value to Cascading Dropdown Form Element

   I am developing an inventory application. In it I came across a requirement to allot part of the material required to be procured and part to be fulfilled from our stock. To lessen the steps that the end user will have to take selecting the item twice, once for each transaction I intended to reload the previously inserted item upon submittal of the record. Because my selection fields are cascading dropdowns I can't setup an On Load value to it. Other than that I think it will be a good idea cuz it will allow us to setup default values to the cascading dropdowns as well.

   I am developing an inventory application. In it I came across a requirement to allot part of the material required to be procured and part to be fulfilled from our stock. To lessen the steps that the end user will have to take selecting the item twice, once for each transaction I intended to reload the previously inserted item upon submittal of the record. Because my selection fields are cascading dropdowns I can't setup an On Load value to it. Other than that I think it will be a good idea cuz it will allow us to setup default values… more

   38 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  ·  DataPages  ·  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

   Submit Rating

4. Make it possible to edit formulas that are referenced

   Right now, if I want to edit a formula, Caspio won't let me, because there are references to the formula in tasks and triggers. I understand that this is an attempt to keep me from breaking the application. But as a consequence, to edit my formula, I now have to remove all the references to my formula across the application, change the formula, and then put those references back, praying I don't forget one or break something else in the process. That's a terrible way to accomplish this task.

   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

   Submit Rating

5. Drag and drop and position buttons such as the submission button

   The positioning of Buttons shouldn't require extra coding. One should be able to drag a button and align it to whatever field of the datapage they want. Right now buttons look out of space when creating a datapage and it doesnt look nice at all.

   16 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  ·  DataPages  ·  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

   Submit Rating

6. App Parameters

   When a duplicate of an app is made, the App Parameters still reference all details and links of the original app and not the new duplicate.

   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  ·  DataPages  ·  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

   Submit Rating

7. Email log for emails sent with triggered actions

   It would be very helpful if we could see a historical log of emails sent out from our account using triggered actions or even scheduled tasks. Ideally, there would just be one email log and would be filterable based on source (i.e. Triggered Action, Task, Scheduled Task, or DataPage -- I may be missing others) and other related fields like date sent, recipient, reply-to address, from, etc.

   17 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  ·  1 comment  ·  Admin Console  ·  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

   Submit Rating

8. Scheduled Exports Date Formatting

   Allow for the formatting of the date that can be appended to a scheduled export. Now the date is Aug-1-2020, it should allow for the date to be 08-01-2020.

   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  ·  Admin Console  ·  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

   Submit Rating

9. Suggestion for flexibility/consistency and ease of use

   Increasing flexibility/consistency and ease of use by
   1) Adding 'form element' (as in data page), to results page (instead of just calculation) the system would also look & feel more consistent
   2) Most important enable 'hidden' option in 'form elements' to be in ADDITION to other choices e.g. so you could choose 'calculate' and 'hidden' together (really helpful for avoiding the Html to hide the column)

   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  ·  DataPages  ·  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

   Submit Rating

10. Customizable date/time popup

    It would be great if I could select the precision required for a date/time popup field so that the user either has to
    - select a date (current only option)
    - select a time
    - select a date and time
    - select a month and year (e.g as https://www.jqueryscript.net/demo/Simple-Clean-Date-Picker-Plugin-with-jQuery-Air-Datepicker/)
    - select a quarter and year (Q1/Q2....)

    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  ·  DataPages  ·  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

    Submit Rating

11. Add a Folder capability to Task pane

    Need to be able to add folders to better organize the tasks

    6 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  ·  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

    Submit Rating

12. White Label the logout link

    For security and for marketing purposes, would be much nicer to be able to whitelabel the link

    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  ·  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

    Submit Rating

13. Make it possible to open a PDF instead of saving from a datapage in a website.

    When clicking on a LINK to a PDF, make it possible to OPEN the PDF in the webpage instead of SAVING the file. Most other PDF links open in the browser. Caspio only will allow saving the file.

    26 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  ·  2 comments  ·  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

    Submit Rating

14. I would suggest an undo button in the trigger development. It is easy to lose all work with one change.

    When developing a trigger you may want to add a select or then realize you need to make a change. I would like the capability to undo to my last point. I can do that in sql server

    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  ·  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

    Submit Rating

15. Ability to view user logs by DataPage so a user activity can be tracked.

    Once a user logs in, I would like to see DataPages he/she visited, and time he/she spent on each page. Currently there is no option to search user logs by DataPages or activity.

    19 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  ·  1 comment  ·  Admin Console  ·  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

    Submit Rating

16. Provide Users with a standard option for working with List-String data elements.

    In my case, I have designed a table with one of the fields defined as a List-String element. The List-String element is filled with Work Codes from production. A manager is provided a datapage where they can set to TRUE specific workcodes that an individual employee is certified to complete. In another datapage, I wish to fill a dropdown box with the names of those employees that are certified to complete TaskA.

    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…)
    1 comment  ·  DataPages  ·  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

    Submit Rating

17. Allow using App parameters in Triggers

    Currently in triggers , it s not possible to use App parameter so if you send an email through the trigger , you have to type the email instead of using the parameter and if the email is changed , you have to go through all the triggers and change it one by one which is exactly the reason why we have app parameters

    6 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  ·  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

    Submit Rating

18. Labels for Sections, HTML Blocks, and Virtual Fields in Wizard to Configure Details Page

    I have a DataPage with a lot of HTML Blocks and Sections. The names of these in the Wizard, on the "Configure Details Page Fields" are just "Section 1, Section 2... and "HTML Block 1, HTML Block 2..." you get the idea. So, I never know what the section is or the HTML block is, until I open it and look at it. It makes it hard to quickly navigate and do other activities. I would like to be able to add a custom label that shows in the wizard, like "Section 2 - Landscaping", or HTML Block 44 - Save Button" Something like that so that I know where I am in the page.

    I have a DataPage with a lot of HTML Blocks and Sections. The names of these in the Wizard, on the "Configure Details Page Fields" are just "Section 1, Section 2... and "HTML Block 1, HTML Block 2..." you get the idea. So, I never know what the section is or the HTML block is, until I open it and look at it. It makes it hard to quickly navigate and do other activities. I would like to be able to add a custom label that shows in the wizard, like "Section 2 - Landscaping", or HTML Block 44 -… more

    13 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  ·  DataPages  ·  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

    Submit Rating

19. Reduce empty space in caspio datapage editor

    Creating and editing caspio datapages can be made a lot more user friendly by making use of the freely available empty space.

    Instead of cramming the editor and having to add scroll bars (both vertical and horizontal) I kindly suggest increasing the size of the editor instead.

    Image attached for clarification.

    •  

    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  ·  DataPages  ·  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

    Submit Rating

20. exporting data from caspio - tables - does not indicate which application they are in. this would be helpful

    When exporting data on tables from caspio - I am not able to determine which application that table is in. We have a production and a test application and the names are the same. It would be nice to have the app next to the 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  ·  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

    Submit Rating