Solved

Split row data into separate files using Infopath 2010 rules or custom code

Posted on 2010-09-13
5
320 Views
Last Modified: 2012-05-10
I've been evaluating InfoPath 2010 using sharepoint recently, and I want to see what the level effort would be to accomplish the following

1. Users would input field data in a repeating table
2. Click a button and have it take all records matching 'field1' and put that in a new infopath form file, then the values matching a different value in 'field1' and put that in a 2nd InfoPath form file
3. user could then submit each file individually

Is this difficult?  
Can it be done using rules (doesn't look like it...)  Is the custom code option too time consuming?
Can it be accomplished easily or should I focus on processing the file from the forms library once it's uploaded?

If anyone has done similar, or has some code examples, let me know, thanks!
0
Comment
Question by:rmicone
  • 3
  • 2
5 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 33668255
a lot of this depends on form design and keeping it simple.

To sum up.
You want user to enter data for type field1 and for type field2 and you want a common starting place (form)

I would have one form.
The user selects the type (Field1 or Field2)
They enter one record and submit.
The submit rules look at the type and submit to a different form library based on the value of type.
They enter another records and submit, etc.

So the user enters the same amount of data they just file each record rather than at the end and you have to sort through the whole batch.

An analogy would be a paper form and filing each one as you filled them out rather than stacking them up and then having a seperate process to access the stack and file each one.

This solution would be real simple and straightforward out of the default features without any complex code or hocus pocus.

0
 
LVL 2

Author Comment

by:rmicone
ID: 33669261
well let me give a little more data, basically it's a repeating table which represent line items, but my users want to be able to enter 50 lines, with different ship dates.  So the field that will distinguish the grouping is the 'ship date' field.  

So you are saying the submit rules can query by that field which in this case is date, and send those line items and corresponding field data in the line items to a separate form?  

and is this available in ip2007 and ip2010?  
0
 
LVL 28

Expert Comment

by:clayfox
ID: 33681325
Yah.

So as they enter a shipment.  They submit after each one and is submits the data to SharePoint. Which can be conditional based on the date.

Why do they want the data seperated by date? You can have all of the data in one list and then allow them to use filtered views to see just one date at a time later.

Have you looked in 2010 of just making a list and customizing the entry form?

0
 
LVL 2

Accepted Solution

by:
rmicone earned 0 total points
ID: 33706705
They are orders, which ship on different dates, so as lazy sales people they go to trade shows and want a form that they can list out 3 key fields, which are item, ship date, and the customer name.  When they get back to the office they have to separate all that out (I know right... huge deal ... not) but we have to make their lives ever-easier so i'm just seeing what is possible.  It seems like the solution is not simple, so I may bag it.

I know you can setup views,  but in this case i need to separate items into new forms based on customer and ship date.

i really like sp2010 and the forms services, i have convinced our COO to get it, we just have to budget it for q1 2011... to solve this problem alone would pay for itself
0
 
LVL 2

Author Closing Comment

by:rmicone
ID: 36110418
scope
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question