OIR
My feedback
18 results found
-
18 votes
An error occurred while saving the comment OIR
supported this idea
·
-
41 votesOIR
supported this idea
·
-
14 votesOIR
shared this idea
·
-
12 votes
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.
-
13 votes
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 typesIn 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
·
-
192 votesOIR
supported this idea
·
-
10 votesOIR
supported this idea
·
-
36 votesOIR
supported this idea
·
-
164 votesOIR
supported this idea
·
-
139 votes
Thank you for this idea. We are looking into adding this feature in future product updates.
OIR
supported this idea
·
-
28 votesOIR
supported this idea
·
-
41 votesOIR
supported this idea
·
-
46 votesOIR
supported this idea
·
-
54 votesOIR
supported this idea
·
-
12 votesOIR
supported this idea
·
-
16 votesOIR
supported this idea
·
-
87 votesOIR
supported this idea
·
-
62 votesOIR
supported this idea
·
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.