Domain Users and Subscriptions

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
Hello. I'm creating an app to manage the pipeline of thematic research across my firm - metadata tagging, monitoring timelines, sending out notifications, etc.

I don't want my ops team being a bottleneck for user management. So I envision doing the following, but I'd appreciate input as to whether it will actually work or not - I don't want to test for fear of pinging 10k+ users.

For the sake of this discussion, the simplified plan is as follows:
  • I create a table, Pipeline. Each record is a piece of research. Each record is assigned a content group, e.g. Policy Research, Behavioral Research, etc.
  • I add the domain @mycompany.com as a user to the app in the role Default_User - with rights to add, edit, etc.
  • I create a second table, Profiles. Each record represents an individual. Each record has a preferred content group multiple choice. 
  • I create a formula user field in the Pipeline app to return the current user.
  • I create a relationship between the Pipeline app and the Profile app via that current user field to return the "Current User's" preferred content group.
  • I create a report in the Pipeline app to return all records where the record's content group = the current user's preferred content group. 
  • I create a subscription to that report. The subscription is designed to be sent out to everyone in the role Default_User. The subscription will only be sent if the report contains any values,.
So the idea is that if someone wants to use the app, that someone can enter the app, create profile for her/himself and in so doing choose a preferred content group. I have a similar setup in another app, and it works perfectly; however, the recipient role's constituents are individually registered users - not a domain.

In this scenario, will everyone in my domain receive the subscription email or only those users who have created a profile and where their preferred content groups match up with the records in the Pipeline?

Thanks,
Patrick
Photo of Patrick Dunn

Patrick Dunn

  • 320 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Do you have a Quick Base account with 10,000 + paid user licences?  Only Users can receive automated Subscriptions reports.  There may be other solutions to automating emails, but that would be my initial question.
Photo of Patrick Dunn

Patrick Dunn

  • 320 Points 250 badge 2x thumb
There are 10,000+ registered users - granted, some may be on the deny list for lack of activity - our admins manage that. 
(Edited)
Photo of Patrick Dunn

Patrick Dunn

  • 320 Points 250 badge 2x thumb
Note: It appears there's a 2000 recipient limit to subscriptions. That 10,000+ user count is almost certainly the number of all @mycompany.com accounts that have been registered over time. Our realm admins routinely add departed personnel and inactive users (i.e. haven't accessed QB in x+ months) to the deny list. I expect that 10,000+ count includes denied users.

Is there a way (or something similar) to add all users of a given domain with status = registered (as opposed to denied) access to an app?
Photo of Patrick Dunn

Patrick Dunn

  • 320 Points 250 badge 2x thumb
I believe the solution to my problem lies with a related issue: https://community.quickbase.com/quickbase/topics/api-addusertorole. Any input would be greatly appreciated.