InfoPath Dev

I have searched the forums and the Internet, but somehow the answers eludes me. How can i make a Rule that only deletes the current row in a repeating table? I can delete a specific line number, but how to retrieve that?

Assuming you have the delete button in each row of the repeating table, it would be something like:

concat("Delete /xpath=/my:path/my:to/my:repeatingGroup[", count(preceding-sibling::my:repeatingGroup) + 1, "]")

Got it! Only thing the example needed was a space before the final comma to pass the formula validation (apart from the correct XPath of course).

 Thanks!

That's odd.  I wouldn't expect it to need a space before the comma there.  At any rate, I'm glad it helped!

Would this work if I am popluating my repeating table with data from a SharePoint list? I have a repeating table that is bound to a data connection that pulls rows from a SharePoint list. I want my InfoPath form users to be able to delete rows in the SharePoint list from the form. I added a button with an on-click rule to run the following Qdabra command:

concat("Delete /xpath=/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[", count(preceding-sibling::SharePointListItem_RW) + 1, "]")

When I preview my form, the data from the SharePoint list is displayed in the repeating table with a delete button next to each record. When I click on the delete button ... well nothing happens. The data stays in the SharePoint List and no information is displayed in the Qdabra Results, Success, or Error controls I have placed at the bottom of the form to help me debug the issue.

Am I going about this the right way? Is there a different way I should be doing this?

 

 

Doing some reading and realize the Delete command will not remove the record from the SharePoint list, just from the XML node and that I need to work with RefreshSharePointListItem to do what I want.

 However, I am lost. I am not able get the a SharePoint list item to get removed and no error, result or success indicators are being generated. I don't know if the trouble is my xpath Delete call or in my use of RefreshSharePointList. How can I debug this? I don't know how to tell f the xpath delete is working or not ... or if the RefreshSharePointList call is working or not. What can I do to figure this out?

Hi Leinweber, According to an email from Hilary: "in general, use the refresh command on form open, the delete command to remove the list item from the form (or just delete the row) then the SubmitToSharePointList command to actually delete from the list. This user may not be submitting again. Refresh creates a list of all your current linked items so that Submit knows what to delete. " One of us should be able to respond in further detail (or give a demo) sometime next week. Thanks, P

Hi - just so you know, the SubmitToSharePointList and the companion refresh command are only for use on the Main data source. That means you'd need to copy the SharePoint items into your form's main data source.

So, you could add a repeating group to your main data source and use the CopyTable to copy in the information from the 2DS. Include the IDs, since the refresh command and the submit command will need them in order to know what item you want to delete or update.

Then, after you've copied your items in, running the Refresh command will generate the internal list that Patrick mentions. Allow users to delete, update or add items, and the SubmitToSharePointList command will replicate those changes in your SharePoint list. Hope that helps, please let me know where you could use more info.

Thank you Hilary and Patrick! I understand know and was able to get everything to work.  :)  I greatly appreciate your help with this.

That's great news - I'm glad you got it all working the way you want it to!

Hi

where i must insert this command ?

concat("Delete /xpath=/my:path/my:to/my:repeatingGroup[", count(preceding-sibling::my:repeatingGroup) + 1, "]")

for delete an item with infopath form 2010

Jimmy:

Assuming you have the delete button in each row of the repeating table, it would be something like:

concat("Delete /xpath=/my:path/my:to/my:repeatingGroup[", count(preceding-sibling::my:repeatingGroup) + 1, "]")

Is it possible to delete a given row from outside the repeating table using QRules?

I would like to delete all blank rows of a table using a button that is outside the table. I know the SetValue command can use a criterion filter, is it possible to do the same with the Delete command?

What I am trying is this:
Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display/my:DeleteRow[../my:PN_Display='']

The first time I press the Button the Success box is checked, but nothing seems to happen. On the second press I receive the error: Could not locate field to delete.

I can delete the entire table with:
Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display

Or a specific row with:
Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display[3]

But I can't figure out how to delete a row when it is blank from outside of the repeating table. Any help is greatly appreciated!

So - the repeating group is Prod_Info_Display? I'm not sure what your DeleteRow field is for, but if Prod_Info_Display is the repeating group, and you want to delete rows where PN_Display is blank, I'd try: Delete /xpath=/my:myFields/my:PopulatedData/my:Prod_Info_Display[my:PN_Display='']

Hi Hillary,

Thank you for help. That did the trick. I figured my xpath was off.

When I ran into trouble deleting the rows based on empty fields I tried setting the field DeleteRow to the word "DELETE" and then using a rule to delete the specific row. Which works sort of, but based on order of operations for rules and code it will only delete a single row with each button press.

Thanks again for all your help!

Happy New Year!

Dan