Hello! I have some issues with correctly showcassing the Rollup function as a progress bar and showcassing an individual rollup for exporting to CSV.
To paint the picture of my application. It’s a portal where a rental community with beach houeses can communicate when there properties will be used by other people. For this, I have 2 types of accounts. Admins, people who can see everything, and users, people uploading their rentals. The users can rent out their property a maximum of 30 days. The admins, next to having an additional admin portal where they can see the rental availability from the users perspective, also have their own calendar since they have a property listed aswell.
The problem I’m facing is as follows. I have a rollup function which works properly from the users perspective since I’ve set row owners to user e-mail. To fix the admin dashboard, I’ve included a row which always includes Admin for when a user submits a form. The Admin’s can then always check the users rental periods when seeing their user profile in the admin dashboard.
However, the problem I have now is that the rollup function on the admins personal page includes the rollup of everybody, since they’re owner of their rollups through the Admin row owner function. When selecting the Rollup function, I can only set visibility and not filter data function.
The next problem I’m facing is the fact that in the Admins tab where they can view all posted rentals, the Rollup is the user specific to their account, not to the accounts of the people listing the rental as shown below:
The above tab also includes an export CSV function and then also showcases the rollup of the Admin’s personal account, and not a rollup of rental days per user.
Above the data table as shown
(the if then query amount of days counted is for when a renter rents their property commercially for 1,2 or 3 days which then gets counted as 4) The math for rollup is to convert the if/then/else query to a math column to connect the rollup to)
Below the rollup view from admin accounts perspective, which is broken and should only show their personally added rentals.
And below the view from individual which is good and functions properly, or the view from admins perspective when viewing a user account.
In short, I’m really breaking my head on how this rollup functions should function properly. The row owner fixes it for users, but breaks it for admins. Also the showing of the rollup in the table as a total of everything instead of a total per user breaks the function to export in a CSV properly. Would really appreciate some links to existing sources that can solve my specific use case. I’ve watched a lot of tutorials already but none can fix this problem.
