InfoPath Dev

Hi, Im so sorry but I think I've been here before with this - Just cant seem to get this working? Please help! Repeating Table: Copying data down into next row - Where should the current() statement be used in the xpath shown below if the next row needs to be blank. Advanced xpath: xdXDocument:GetDOM("For Gasils Products List")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Surface_x0020_Area[../d:Title = xdXDocument:get-DOM()/my:myFields/my:gRingDrier/my:gRingDrierQuality2/my:group67/my:cmbRingDrierDailyProductTarget] Unadvanced xpath: Surface_x0020_Area[Title = cmbRingDrierDailyProductTarget] Where does the current() go? Thanks in advance. Mike

What's the XPath to the repeating table?

Hello Hilary, Sorry I don't quite understand your question? is it a question? "What's the XPath to the repeating table?" If asking, yes this is a repeating table - I have 2nd connection which populates txtbox - problem comes when I click to insert new line, it copies what's in the line above. I just thought somewhere in this string I would need the use of current() GetDOM("For Gasils Products List")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Surface_x0020_Area[../d:Title = xdXDocument:get-DOM()/my:myFields/my:gRingDrier/my:gRingDrierQuality2/my:group67/my:cmbRingDrierDailyProductTarget] Mike

It is a question. Can you attach a copy of your form?

My guess would be that group67 repeats? If so: xdXDocument:GetDOM("For Gasils Products List")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Surface_x0020_Area[../d:Title = current()/../my:cmbRingDrierDailyProductTarget]

 Hilary,

Sorry for my long time reply - I was so tired... I needed sleep. AND guess what, got up this morning and did exactly the same as I did yesterday and now it works.

xdXDocument:GetDOM("For Gasils Products List")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Surface_x0020_Area[../d:Title = current()/../my:cmbRingDrierDailyProductTarget] 

Compare this line with what you wrote and you were spot on (as I would expect)

Sometime its best to just walk away for a while!. 

Thanks Hilary, as always, take care.

Mike 

 

 

Ah, glad you got it. :) Sometimes InfoPath helps us and adds current and sometimes it doesn't, and I don't really know why it is such a curmudgeon. Take care - H.