InfoPath Dev

I need to achieve the following:

1. Someone creates a purchase request and fills information in a repeating table.

For example:

Type	Model	Quantity	Received
Monitor	LG	3	No
Laptop	HP	2	No

 2. After making purchase and receiving items they change "Received" field to Yes.

3. When field is changed to Yes, a new table must be created, but based on quantity appropriate number of rows must be created and prefilled with values from previous table.

For above example it will be like this:

Type	Model
Monitor	LG
Monitor	LG
Monitor	LG
Laptop	HP
Laptop	HP

 

Is this somehow achievable in InfoPath? 

 

 Unfortunately, not out of the box. You'll need to use code or qRules. Here's a link to some sample code. http://www.bizsupportonline.net/infopath2007/4-way-programmatically-add-row-repeating-table.htm

 How can I do this by qRules?

I might use an XSLT and the transform command. You could also use Insert to insert the rows to your table based on the quantities, then add rules to the repeating group to set it's values... you'd probably need some logic around counting how many preceding siblings are in place vs. how many of the particular item were requested, or you could set up a counter field that you can use with rules to help determine the correct values.

 Hi Hilary,

 I was able to insert correct number of rows by qRules, but I don't understand how can I copy the same row to destination table multiple times based on quantity field. Can you help me with some example?

Sure. I'll put together a sample for you in the next day or two.

Sorry, I haven't had a chance to do this yet! Hopefully today. :)

 Thanks, I'll wait for sample.

So, this sample uses the Insert command & rules on the repeating group that I'm inserting to (group4 in this case). If you are dealing with a great deal of data, XSLT will be more performant & you can use the Transform command with that. Save the file locally, right click & select design. Then you can preview & try it out.

Hi Hilary, thank you for sample. It helped me to do what I wanted. Now I need to Submit data from created repeating table to existing SharePoint list. I know, that I can use qRules SubmitToSharePointList command to do this, but my task is a little bit different. I need to have button on each row, that will submit only corresponding row data when clicked. Is this achievable via qRules?

Sure - you can use a rule to set the the RepeatingGroup node in your qRules mapping for your submit to include an XPath filter with the index of the row you want. So - the field is /myFields/Mappings/RepeatingGroup, and your rule could use (for example) count of preceding sibling + 1 to set it. Like: concat("my:myFields/my:group1/my:group2[", count(preceding-sibling::my:group2) + 1 ,"]")

Hi Hilary. Can a user submit data to a list via SubmitToSharePointList command without having any access permissions on that list? Like impersonation or app step in SharePoint workflows.

There is an undocumented parameter you could use - ssappid. The description is: "Secure store application id to use if user is logged in anonymously" - so I think you'd be able to use a secure store app id?