So I'm created a number of different lists and libraries with workflows attached.
When someone creates a new job, the document is uploaded to the Job directory (library).
If it classified as a specification document it is copied into the Spec library. Likewise for quote and an enquiry documents.
What would be the best method for ensuring the "Job Name" field (which is featured in every list and library) remains consistent throughout the site?

1 Answer
1

I'm assuming by consistent, you want to ensure as docs are moved around the job name remains the same?

You could use a lookup field to a Job list, which will narrow down the possibilities and remove some human error by way of someone typing in something incorrectly. Also, by using a master list, you can create a dashboard view for your jobs, letting you see all of the related content in one page. Let me know if you want some more info on creating an easy dashboard.

Yes thats what I mean. Currently in each library the Job Name field is single line of text - not what we want. Most of the time the column is automatically filled in because the document is often just copied from the "drop box" library. Can I still have a workflow auto populating it if it is a lookup field? And yes please an easy dashboard would be fantastic!
– Charles BakerDec 14 '12 at 14:54

I'm gonna give that a go on monday! Thanks very much. Perhaps you'd be able to tell how to populate the "job name" (lookup field) from my workflow. I have no issues when its single line of text, but now that its a lookup im not having any luck...
– Charles BakerDec 14 '12 at 15:43

I'd have to give it a whirl myself to remember how to do it. I think you can create a variable object that performs the lookup to get the item ID? Sorry, I forget. However, I'm assuming the user specifies the value when they upload the doc the first time, you should be able to just copy the field value from list to list, if not, try a lookup in the WF.
– David LozziDec 14 '12 at 15:45

Saw your comments on my blog davidlozzi.com/how-can-i-help. This place might be better for the conversation ;). Can you start off with the lookup field in your Drop Box? If you're going to allow users to enter a job name, there's no guarantee it'll match the jobs directory every time.
– David LozziDec 17 '12 at 15:54