I need all my users to have access to an app...and not have to add/remove them every day.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have an application that has about 20 real users. When the user adds a record, they need to choose someone to assign the work to, and so they choose from a dropdown of users. However, the dropdown needs to show all 1800 of our quickbase account holders and not just the 20 who have real access to this application.

I am sure I could add all 1800 of our quickbase users to this application, but since new QB users are added daily, and removed daily, that would be horribly inefficient to have to manually add/remove them from this application daily.

I have tried adding @domain to the user list, and that is allowing the 1800 users to add records, but it does not allow them to be listed in the dropdown of users.

Photo of aimpulsive

aimpulsive

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
I suggest creating a Table of your 20 users. Set the Key field to be the User field, and have the User be selected off a relationship.
Photo of aimpulsive

aimpulsive

  • 0 Points
Sorry,but this does not help. My 20 users are not the problem. I need that application to be able to show a list of all 1800 of our users to pick from. And, I don't want to have to add/remove users from that list that is maintained within each application where I want to have those users available in a picklist -- I want it to use my master user list that is part of my Quickbase account.
Photo of aimpulsive

aimpulsive

  • 0 Points
Doesn't anyone know how to do this?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
When choosing a user, Can't you take advantage of that search box?  Why do you need a list of 1,800 users?
Photo of Douglas Vega

Douglas Vega

  • 0 Points
This is how I would do it.

1. Create a new table for your 1,800 users with the following fields: Email (Text type), Description (Text type) and Username (Formula-User).
2. Formula within Username field would be: ToUser([Email]), then save this field.
3. Make the Email field the key field for this table.
4. Go to Advanced Setting in this new table and go to the "Record Picker" section. Set column 1 to Email, column 2 to Username and column 3 to Description then save your changes.
5. Add records (user's emails) to this new table. You can use the Description field to store details about the user, something your 20 users can understand and obviously the Username field would turn the email into a username Quickbase recognizes.
6. Now, go to the table you need to show the 1800 users from and create a new field called "Account Holder Email" with data type "Text".
7. Create a 1 to many relationship between your users table and the table you open in step 6 where 1 user may have many records related.
8. From the Details Table (inside the relationship settings), select the text field you created in step 6 as the reference field and then lookup fields should be Description and Username.
9. Go to field settings (field created in step 6), this new field should be set as Text(reference) by now, mark the option "Use a record picker instead of a drop down menu" and save your changes.
10. Create a new field within the app you need to show the 1800 users called "Account Holder Username" with data type "Formula-User", Formula in this field should be: ToUser([Account Holder Email]).
11. Finally, the field you will use for assignation is the one created in step 10.

If you go and play with the Account Holder Email field, you will see it says <browse choices...>, click there and you will be displayed with a new pop up for your 20 users to search among the 1800 users.

I just tested it and it worked for me. If you need further help, you might contact me at the email on my profile, I am a web developer based in Central America with a couple of years working with Quickbase and cloud based databases.

I hope you find it useful.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
Douglas
Can you tell me how your solution deals with this issue raised by "aimpulsive"

"I am sure I could add all 1800 of our quickbase users to this application, but since new QB users are added daily, and removed daily, that would be horribly inefficient to have to manually add/remove them from this application daily."