I would like to be able to add a field that includes attributes of the collaborators entered within a "user" or "created by" or "last modified by" type of field. For example if George is entered as a collaborator in a field in table X of base Y and George belongs to a user admin group called "Sales" I would like to look up the user group George belongs to and automatically show it in another field of the same entry in table X of base Y.
You should be able to do this using linked records and lookups.
For example, here I have assigned a user to each project. The users are referenced from the Users table. In that table, you can link them to the groups in the Admin Group table. Note that when a user is assigned to a project in Table X, the admin group they are a part of will automatically be shown via the lookup field.
