General

Re: Question about repeating tables

Hilary Stoupa — Mon, 26 Mar 2018 15:07:55 GMT

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?

Re: Question about repeating tables

Arthur.Avanesyan — Thu, 22 Mar 2018 10:39:23 GMT

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.

Re: Question about repeating tables

Hilary Stoupa — Tue, 20 Mar 2018 14:47:09 GMT

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 ,"]")

Re: Question about repeating tables

Arthur.Avanesyan — Tue, 20 Mar 2018 08:23:34 GMT

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?

Re: Question about repeating tables

Hilary Stoupa — Wed, 14 Mar 2018 21:31:17 GMT

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.

Re: Question about repeating tables

Arthur.Avanesyan — Wed, 14 Mar 2018 19:16:50 GMT

Thanks, I'll wait for sample.

Re: Question about repeating tables

Hilary Stoupa — Wed, 14 Mar 2018 19:00:31 GMT

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

Re: Question about repeating tables

Hilary Stoupa — Mon, 12 Mar 2018 14:53:07 GMT

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

Re: Question about repeating tables

Arthur.Avanesyan — Fri, 09 Mar 2018 18:28:07 GMT

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?

Re: Question about repeating tables

Hilary Stoupa — Thu, 01 Mar 2018 16:15:58 GMT

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.

Re: Question about repeating tables

Arthur.Avanesyan — Thu, 01 Mar 2018 15:57:55 GMT

How can I do this by qRules?

Re: Question about repeating tables

Hilary Stoupa — Thu, 01 Mar 2018 15:23:25 GMT

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

Question about repeating tables

Arthur.Avanesyan — Wed, 28 Feb 2018 18:55:15 GMT

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?