Make administrators see all records in a repeating group

Need help
1

Another frustrating issue with Bubble. I KNOW this is a relatively easy thing but there just isnt an easy way to find an answer. I have a page with visits for when our managers visit a customer. Theres a database called visits and for each visit a manager files a report. What I want in the repeating groups if for managers to be able to see their previous visit reports and for the president and CIO to see ALL the visit reports in that repeating group. I cannot get the administrators to see all reports, just ones they submit. There is a field in the user database (administrator y/n). The Data Source is search for visits. Then there is a constraint manager = current user. How the hell do I allow the administrators to see ALL records tho

2

You can solve this by adding a conditional to the repeating group that changes the data source based on the user’s role. Something like,

  • *Default data source: Search for Visits with the constraint Manager = Current User
  • Conditional data source: When Current User's administrator is "yes", set the data source to Search for Visits without any constraints

Although I recommend complementing this with the appropriate privacy rules, you wouldn’t need to add any extra frontend constraints.

3

Its still not showing anything. I already had your step one. On step two I did the conditional with Current Users Administrator is yes. I checked “this element is visible”. What can I possibly be missing?

4

can you show your implementation?

6

I figured it out. I needed to use :filtered and did not understand how to implement that. Thank you for your help tho

7

This topic was automatically closed after 70 days. New replies are no longer allowed.