I am trying to accomplish a task with Drupal and I'm kind of stuck in how to implement this, so I'm wondering if anyone has any ideas or can at least point me in the right direction.
My company has over 60 locations. I am using Views to dynamically create a single "profile" page for each location. What I want is a way for the manager of each location to be able to log in and create articles for a kind of "What's Happening" section for their respective pages.
When the "manager" user accounts are created, I assign them a location based on a "Location" field that I added to the "User" content type.
What I want to do is add a field to the "Article" content type that is automatically populated with the "Location" of the manager that is posting the article. From there I can filter in Views to complete the page generation.
I could easily just add a "location" field to the Article content type that the user could manually select, but I know my users, and people will be creating articles for other sites and cause big mess for me to clean up. I'd like to have the "Location" field in the article automatically populate depending on the users' login.
Possible? If so, how?