1158 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. Enable multi-field record-level-security

   I have an application where multiple data pages need to be viewed by 4-5 different types of users. I would like to use record-level security to restrict what data that page displays based on the logged-in user. I cannot use OpenID as an authentication method for this application.

   Since Caspio's current authentication scheme only allows you to filter based on one field in the authentication, I would have to duplicate the page for each role that needs access to that page's content.

   Could the authentication scheme allow for multiple fields to be used to determine whether a user has access to something. For example,

   (
   dataSource.field == authenticationSource.field1 OR
   dataSource.field == authenticationSource.field2 OR
   dataSource.field == authenticationSource.field3 OR
   dataSource.field == authenticationSource.field4
   )

   The application will take ~50 data pages. Without this feature, that quickly scales up to ~180 pages

   For more context, see my comment in this other thread: http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/16251463-record-level-security

   I have an application where multiple data pages need to be viewed by 4-5 different types of users. I would like to use record-level security to restrict what data that page displays based on the logged-in user. I cannot use OpenID as an authentication method for this application.

   Since Caspio's current authentication scheme only allows you to filter based on one field in the authentication, I would have to duplicate the page for each role that needs access to that page's content.

   Could the authentication scheme allow for multiple fields to be used to determine whether a user has access… more

   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  ·  Authentication  ·  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. Hi, Would suggest when getting logged out due to either inactivity or another login, all pending changes to objects should be saved as draft

   Hi, Would suggest when getting logged out due to either inactivity or another login, all pending changes to objects should be saved as draft

   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

4. An easier way to move fields up and down on the DataPage Wizard.

   I realize there is a post on here to make the workspace for the DataPage Wizard bigger. That is great. However, I hope they add functionality for an easier way to set where the fields go.

   If you have a big form/report with a lot of fields, and you add a new field to it, the new field starts at the bottom. It can take a really long time and a lot of 'up' button pushes to get the field in the location you want it.

   Maybe a drag and drop feature would help.

   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  ·  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. MFA / 2FA for End Users

   My end users are, nearly, demanding 2FA/MFA for their apps.
   I understand that 2FA exists for logging into Caspio bridge, I have done that.
   I need 2FA/MFA for my apps. SMS, Google Authenticator, etc.

   49 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  ·  Authentication  ·  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. Concatenate Filename for download of Search Results

   I would like to construct the Excel File Name as a concatenation of field values (and text).
   One idea is to concatenate the desired filename in a hidden calculated field on the DataPage,
   and then submit this field in the File name textbox on the Advanced tab of the Result Page options
   https://howto.caspio.com/faq/reports-datapages/how-to-make-the-search-results-downloadable-for-my-users/
   (by default I can add a date value to the file name).
   NB. The search result will be a single record.

   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

7. Combined Chart and Report, more than one chart

   allow to have more that one chart in a data page of type Combined Chart and Report?

   5 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

8. add a custom font in style
   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…)
   1 comment  ·  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. Export data in DataPage to a normal xls file, not xml or csv with quotation marks.

   Hello,
   In Caspio there is an option to export data from DataPage to an xml and csv file.
   But such export is of little use, because if I would like to make nicer data prints using mail merge, MS Word does not read data from an XML file only from xls. The csv file is also not read because the data is in quotation marks ("data"). For mail merge, both xml and csv files are useless.
   Can you think of exporting data to a regular xls file?
   Greetings,
   Mirosław RUS
   Poland

   12 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…)
   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

10. Additional Fields in DataTip

    The datatip and labelling of data within a chart only allows for Categories, Series and Values within the charts. Is it possible to look at adding more fields for display only?

    For example, having 3 sets of data for one individual, however cannot add the date so it is very hard to distinguish if there has been improvement as it can't be identified when each dataset was collected.

    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. how to get the cascading dropdown values without refreshing page if i add new one in the table

    how to get the cascading dropdown values without refreshing page if i add new one in the table. I add a new entry in a pop-up and my workflow does not allow you to refresh the page after new entry submission.

    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

12. Make all fields customizable in styles section like you have made the dropdown list

    The same way you made this customizable in styles, please make all types of fields.

    "New sections are added in the Styles Wizard for the following elements: multi-select dropdown and list box, inline edit and add, and missing required form elements."

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

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

14. add a feature for user specific folders.

    So at Authentication, it creates a folder for User A and all their uploaded files direct there

    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. Add the option to count words, rather than characters, in a text area.

    I have users that want to be able to count the number of words in a text area. Having the option to choose characters or words for the count would be helpful.

    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

16. Ability to use Calculated Fields in a Chart Datapage

    I would like to use a calculated value as the basis for a Chart Datapage. The only current option is to use a calculated field in my table and that could hurt performance. The other option is to somehow suppress the report in a report/chart datapage. Neither of those options is viable at present. Ideally the calculations would be in a Datapage. I don't want to risk performance on my site.

    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

17. On datapage, 'Configure the filtering criteria for each selected field', add option "In" to the Comparison Type dropdown.

    Adding the "In" option will allow for searching data that match the "OR" condition. This will be very useful for text search.

    •  

    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

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

19. Enable Forms To Expire

    It would be nice to have the ability to set a form to 'expire' or become unusable after a set amount of time. This would allow us to do things such as have trial accounts and offers, prevent unwanted submissions, and give additional security to our forms.

    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

20. Adding signature field to Caspio form....

    I hope Caspio can add on the digital signature field in Caspio form in the near future. Thanks.

    5 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