How to Create Table which Holds User Settings for App

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I've created a User Options table in which each user can have a (single) record in which they can add the icon URL or color hexcode that they will see for certain project status-categories in the Projects table.


So: Projects would have a "My Projects" report that only displays Projects records that the user owns--and I'd want this report to colorize rows as defined in fields in the User Options table--but how could Projects know which User Options record to look at?

When users a new Project record I don't think it'll makes sense for them to always choose the User Options as the parent record, or can their User Options records be the default record chosen for any Project they create?

Likewise, I don't want users to have add all Projects through a button in a User Options form.

Is there a way for any Projects created by the user to point to the User Option record that the user owns?

Thank you!
Photo of Amber

Amber

  • 588 Points 500 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
re:  Is there a way for any Projects created by the user to point to the User Option record that the user owns?  The answer is "Yes".

.

.

.

. but I suppose you want to know how.



An exceptionally useful general QuickBase technique is to set up a table of Users (which it sounds like you already have), and set the Key field of the table to be the User's userid.

Then on any details table, like Projects, make a field called [Current User] with a  formula of User().

Then make a relationship back to the Users table based on that [Current User] field as the reference field on the right side of the relationship. Then lookup to your hearts content.