InfoPath Dev

What I am attempting to do is write jscript to determine if there is a blank row in one of my repeating tables. I removed the ability for users to delete rows but I need to remove blank ones just before I submit to sharepoint and the database. Any hints in regards to how I could do this, would be great.

 

Hi

 Welcome to the forums.

First off this would have to be done in code run before the submit but it is altogether easier to allow users to delete lines and use valuidation to prevent submission until the line is deleted.

You could also have a rule that sets another field called CHECK on the end of your row that is invisible to the user that says if the frist row and first column is not blank then set the CHECK field to OK, then use conditional formatting to prevent users from adding to or deleting the control unless all instances of CHECK are not equal to OK.

I hope this helps

Adam

Hi,

You need to remove the empry rows before submitting the sharepoint or database then you need to write the following code to remove those empty rows.

//This statement gives the whichever you have all empty rows in repeating section.  

IXMLDOMSelection emptyRows = (IXMLDOMSelection)thisXDocument.DOM.selectNodes("..\..\my:RepeatingSectionNodeName[my:field1 = '' and my:field2 = '']");

//This statement removes the all rows which are empty ones 

emptyRows.removeAll();

Great..

var objXMLNode;

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees");

objXMLNode.removeAll();

Thanks for the code. I've started adapting it to my form. I can delete all records in the Employees section using the code above. But when I modify the selectNodes line to select records with no employees (code below) nothing happens. Not sure what exactly im doing wrong with it.

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[empID = '']");

Hi

i think prefix is missing for an 'empID'. If the 'EmpID is an element then you should add 'd:' ,if it is an attribute then you should add ' @ ' .

if empID is an element then the code should be 

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[d:empID = '']");

if the empID is an attribute then the code should be

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[@empID = '']");

Hi Tome,

You are using // to starting of your XPath may be that is one thing it goes to wrong. You can use only / to the starting of your XPath. You need to verify if d prefix is required or not for 'Service_Receipts' and 'SR_Employees' node. Check once again your XPath.

Done!!

Thanks for all the help guys. I thought I had tried it already, but the code below worked like a champ.

var objXMLNode;

objXMLNode = XDocument.DOM.selectNodes("//dfs:myFields/dfs:dataFields/d:Service_Receipts/d:SR_Employees[@empID = '']");

objXMLNode.removeAll(); 

I've tried to use the code above but am still getting many errrors.   Can you help through this?     I want this as a validating code to essentially delete any records where my repeating table brandcode and brandalloc fields are empty.

' Write your code here.

End Sub