0

per-user fields

It would be helpful to be able to create fields with per-user values. 

For example, I have a playlist that needs to be reviewed by multiple people.  I'd like to create a field per playlist that the user can set that marks it as "reviewed?"  This can be a simple checkbox, but the value should only apply to the current user - for them to keep track of what they've done (similar to how a note can have the status "read" after a user looks at it) without affecting another user's "reviewed" status.

3 comments

  • 0
    Avatar
    Tony Aiello

    You can do that now.  Start by adding a multi-entity field called "Reviewers" to the Playlist entity, OR a multi-entity "Playlists" field to the HumanUser (People) entity.  Either approach will then create a new Connection entity table.  (The name of the Connection entity will depend on which table you started from i.e. Playlist <> Reviewers or Person <> Playlists, respectively.)  Like PlaylistVersionConnections where you can store a different Sort Order per-Version-per-Playlist, that new table is where you can store per-Reviewer-per-Playlist instance data.  You'd add your 'Reviewed?' checkbox (or a Status field, etc) to that new Connection entity table, and there you go.  You'll probably want to go to the Site Preferences > Advanced > Enable List Pages for Connection Entity Types option and add the name of the created _Connection entity to that list.

  • 0
    Avatar
    Steven Tavernia

    Thanks Tony.

    Can you let me know how to find / get to the connection page that was created?

  • 0
    Avatar
    Tony Aiello

    There's a bunch of ways, but here are two good ones.  The second option definitely requires that you added that Connection entity name to the Site Preferences option I mentioned above.  Again, if you started from a list of Playlists and added a 'Reviewers' field, the name of the connection entity that got created ought to be called "Playlist_sg_reviewers_Connection".  The first option might not require it, but I've found it a good idea to do anyway.

    1.  On the detail page for any Playlist, do a 'Design Page' and add a tab of People.  The default Page Filter condition for that tab should automagically become "Show People which match all of the following conditions: Playlist <-> Reviewers -includes- Current Playlist".  Right-click to insert a column but scroll way down to a section named "PLAYLIST-SPECIFIC FIELDS" under which you should find and click "Add New Person-in-Playlist Field..." to add your checkbox or status field.

    2.  Goto the "global" page for the entity, like this:  http://yourshotgunsite.yourdomain.com/page/global_page?entity_type=Playlist_sg_reviewers_Connection".  Right-click to insert a column but choose "Manage Playlist_sg_reviewers_Connection Fields" to add your checkbox or status field.

    Beware... I don't actually work for Shotgun, I'm just a long-time user.  You may want to follow-up with the Shotgun support folks directly by filing a ticket, they might have an even better way than I've outlined.  Particularly re finding out the name of the connection entity if you're having any trouble with that.  Good luck!

Please sign in to leave a comment.