InfoPath Dev

So this is a default value in a field in the main data source in the form? I'd guess this might work: count(xdXDocument:GetDOM("RDT List Count Status")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Area[. = current()/../my:Title and ../d:Status = "In Service"])

Hi Hilary, The Xpath is as follows: count(xdXDocument:GetDOM("RDT List Count Status")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Area[. = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title and ../d:Status = "In Service"]) Thanks!!!!

The thing is - trying this out is low stakes. It is pretty quick to create a template from a list, and then create a new list from that template. Or create a site template and create a new site from that template. It shouldn't hurt your original list / lists / site to do this, and gives you a place to experiment a bit.

awesome, thanks!

If you create a template from the list, and then create a new list on the same site, I think it will use the same data connections / look ups.

if I leave the lookup lists as is, will the copied list bring the DCs and look-ups in the form? or will a new DC and filter/queries be required?

In the formula editor, can you check the Edit XPath option and paste the XPath into a reply?

I think if you save the current list as template and create a new list from it, you'll be ok. If you are talking about changes to the lists you are using for lookups, of course - those will impact your current form as well.... You may want to consider creating a template with content from the site to give yourself a safe play to try changes ...

Sure - check the submit options to make sure the form isn't set to close on submit....

I have a few lists that are connected by look-ups and data connections and I'm debating on a radical change. If I make a copy of this list will all the formulas/filters/queries that are in the InfoPath form break on this new "test list"? Thanks