OIR

My feedback

  1. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  2 comments  ·  Caspio Bridge » Documentation  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    OIR commented  · 

    I was able to get a lot more documentation on a given Caspio app when I followed these steps:
    1. I made a backup of the entire application and downloaded it as an XML file
    2. I used Excel's PowerQuery to open the file and parse the XML data into a table format
    3. I produced a number of tables that made it very clear as to what each table, view, and authentication was doing. I only extracted a few things out of the data page stuff (e.g. Report Header/Footer, notification/acknowledge email info, etc.)

    Now, rather than clicking through Caspio to see that to which an Authentication's data source (a view)'s column name actually refers, I can open an Excel document that clearly displays that information for me.

    OIR supported this idea  · 
  2. 36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  3 comments  ·  Caspio Bridge » Admin Console  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  3. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » Authentication  ·  Flag idea as inappropriate…  ·  Admin →
    OIR shared this idea  · 
  4. 14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Caspio Bridge  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    OIR commented  · 

    You can use Excel's PowerQuery to extract the data out of the XML file. It's a bit tedious, but once it's been set up, it works pretty well.

  5. 13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Caspio Bridge  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    OIR commented  · 

    My employer wants to build an application with the following specifications.

    This application supports multi-role user accounts. Of the roles users can have, four must submit some sort of report:
    - Role A submits 7 report types
    - Role B submits 3 report types
    - Role C submits 3 report types
    - Role D submits 5 report types

    In total, 18 data pages.

    In addition to these roles, one role is also relevant (Role E).

    These are the privileges each should have to view each other's reports:
    - Roles B, C, and D can view Role A's reports (report types 1 - 6, but not 7)
    - Roles B, C, and D can view their own submitted reports
    - Role A can view all reports submitted by Roles B, C, and D
    - Role E can view all reports submitted by Roles A, B, C, and D.

    Since there's only one RLS choice, the current system would force me to duplicate each web page multiple times, one for each RLS.
    - View Role A reports [32 data pages total] (7 for Role A viewing, 6 for Role B viewing, 6 for Role C viewing, 6 for Role D viewing, 7 for Role E viewing)
    - View Role B reports [9 data pages total] (3 for Role A viewing, 3 for user B viewing, 3 for Role E viewing)
    - View Role C reports [9 data pages total] (3 for Role A viewing, 3 for user C viewing, 3 for Role E viewing)
    - View Role D reports [15 data pages total] (5 for Role A viewing, 5 for user D viewing, 5 for Role E viewing)

    To support this, I would need to create 65 data pages for what is effectively only 18 data pages.

    Besides this being horrible for me to create, some user account can have multiple roles. Thus, the resulting user interface is absolutely atrocious. A user who has Role A, Role B, and Role E would need to use different data pages to view the correct data depending on the RLS for that data.

    Please implement this feature.

    OIR supported this idea  · 
  6. 78 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Caspio Bridge » Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  7. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Caspio Bridge » Authentication  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  8. 28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » Authentication  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  9. 129 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  20 comments  ·  Caspio Bridge » DataPages  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  10. 120 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    15 comments  ·  Caspio Bridge » Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  11. 16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  1 comment  ·  Caspio Bridge » Admin Console  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  12. 26 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  0 comments  ·  Caspio Bridge » Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  13. 39 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  2 comments  ·  Caspio Bridge » Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  14. 10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » Tables and Views  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  15. 9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » DataPages  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  16. 12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » Authentication  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  17. 57 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » DataPages  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 
  18. 50 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Caspio Bridge » DataPages  ·  Flag idea as inappropriate…  ·  Admin →
    OIR supported this idea  · 

Feedback and Knowledge Base