Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I want to create an application form which would allow the user to make multiple entries for the same set of columns (like a table) e.g.
Name: XYZ
Emp ID: nnnnnnnn
"Shift Worked" "Date" "No. of Hours"
Entry1 ----> '7 AM' '8/23/10' '8'
Entry2 ----> '7 AM' '9/1/10 '4'
Entry3 ----> '4 PM' '9/2/10 '8'

How do I incorporate this? I tried researching on the net - but haven't been able to find the answer. Appreciate any help!!

share|improve this question
    
James, Thank you for answering. I am fairly new at the designer - I have just used it for workflows. So please excuse my ignorance. My requirement is to allow the employee to enter the data on a form (List?) for approval by the manager. I am not planning to use the data any further after approval. Ofcourse, the manager should be able to see what has been entered in the form. Would the subform idea wor for this? I am trying to read up the topics you mentioned. Thanks! –  Anonymous Sep 3 '10 at 9:37
    
You could indeed use a Data form view for editing/updating fields as the Subform in the dataviewwebpart. If you have SharePoint Server, you could equally use InfoPath which may make it easier to implement. –  James Love Sep 3 '10 at 13:54

2 Answers 2

up vote 0 down vote accepted

Sounds like you're wanting the equivalent of subforms within a form, like you would get in Access.

What I would do first is focus on how the information is stored.

Assuming you have your employees details stored in a list, which contains Name and ID, and have a separate list to store the shifts, with columns EmpID, Shift Worked, Date, Total Hours.

To display this, you can use DataViewWebParts in SharePoint Designer 2007 to link the two tables, and display the Shift data per Employee (this is done using a kind of "manual group-by", may require some XSLT hacking, though should be possible without touching any code).

Basically create a DataView of all the employees, and create a cell (either in a new column or in a row below the name) which displays a subtable to your shift data list.

The topics I mention here to read up on are "Linked Sources" and "Inserting Data As Subforms" in SharePoint Designer 2007, in case you want to read up elsewhere what I'm mentioning here.

share|improve this answer

If you have InfoPath Services, take a look at InfoPath's repeating sections.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.