Forum Discussion
PaulEaston
Qrew Assistant Captain
Thank you for clarifiying.
But is there any benefit of creating a new "users" table and editing that versus adding/removing the users to/from a custom of a user set in a user field?
It seems that the benefit of using a user field is it makes sending notifications easier. If the users are selected from another table, it gets more complicated to have the user notified. I would have to tie the notification to the intermediary users table. That would make it difficult to, for example, add a button in the e‑mail that will update the record in the table I want.
------------------------------
Paul Easton
------------------------------
But is there any benefit of creating a new "users" table and editing that versus adding/removing the users to/from a custom of a user set in a user field?
It seems that the benefit of using a user field is it makes sending notifications easier. If the users are selected from another table, it gets more complicated to have the user notified. I would have to tie the notification to the intermediary users table. That would make it difficult to, for example, add a button in the e‑mail that will update the record in the table I want.
------------------------------
Paul Easton
------------------------------
MarkShnier__You
2 years agoQrew Legend
One benefit to having a table of users is that you can control easily who is allowed to maintain the table and it is visible appropriately to your users. The custom user sent is only available to admin's. Also, you may want to use the same drop down list of users in several tables in the app and not have to adjust the custom user set multiple times and several tables.
There's absolutely no problem having the relationship pull in the user ID in fact I suggest for other purposes that the key field of that table be the user ID so there's absolutely no difference with notifications or subscriptions.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
There's absolutely no problem having the relationship pull in the user ID in fact I suggest for other purposes that the key field of that table be the user ID so there's absolutely no difference with notifications or subscriptions.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- PaulEaston2 years agoQrew Assistant CaptainOkay, makes sense. I'll try this approach.
------------------------------
Paul Easton
------------------------------