Hi

I'm creating a custom list to store exam documents for courses.  Each course will have 4 exam documents - which will be uploaded into the site by a number of people.  For reporting purposes I need to create view which shows courses where the 4 exam docs are incomplete e.g. there are only 3 not 4.

I'm configuring this out of the box - I do have SharePoint Designer but have little experience in using it.  Any help or nudges in the right direction would be appreciated.

Thanks in advance.

Fiona

Without any coding at all, this wouldn't give you a view of only courses missing exams but if you don't have lots of courses it might work.

Instead of a list start with a document library. Add in a field for the course id or name, or a lookup to a course master list. When people add in their documents that course id will need to be entered.

Create a view of all documents, and group it by course, and have it default to 'collapsed'. That will give you a list of courses with a count of the number of documents. You'd still see all the courses that have 4 exams but it would get you close.

Otherwise if you have a list, one item per course, with documents as attachments, you'd have to have a field that held the count of the number of exams attached, but you'd need code if you wanted it to automatically be generated - no out of the box way to count # of attachments that I know of - you'd need some javascript or other code for that.

Hi Fiona- Robin has some good suggestions, but it would be nice to have more information on how you're setting this up/how documents will be added/attached. Do users upload them separately at different times or all at once? You say "List," but are you actually talking about a list or a library?

Hi Fiona,

Try creating a All Items view with out any filters for debugging. You can see all the items added to the list/library. 

Regards,

Rajesh

http://sharepointr.blogspot.sg/

• Proposed as answer by Ganesan Rajesh Kumar 13 hours 50 minutes ago

Rajesh- please don't mark your own reply as a proposed answer. Your reply is not a good answer as you didn't understand Fiona's question. She doesn't need debugging, she's asking how to create a view or find a way to determine if all of the docs were uploaded by users per her requirements.