-
Is the data you need in promoted properties in the library in SharePoint B? I'm afraid I'm having a little trouble understanding the question....
-
You could set a rule on the repeating table group itself to populate field5 - that would handle for any new rows added by the user. Then you'd just either have to change the default data to not include a row by default, or have a rule on form load to set the initial value.... Or is there some other field in the repeating table the user enters ...
-
Wonderful - I like to be able to see what I'm working with, so I make a real mess of my forms during design, making sure I can see all the data. Then when everything is working correctly, I clean stuff up. :)
-
It's just perfect! Thank you for your help.
-
Dear All,
I have a "field5" in repeating table with following default value: concat(now(), "-", LoggedOnUser) (it's set to refresh after recalculate )
Each time I save the form and open it it's updating the dates.
I tried to disable "refresh after recalculate" but it ...
-
Thank you Hilary. Like you suggested, I dragged the repeating table to the Form and found that my Query worked fine. The issue was with my rules to set the field values. Fixed it now. :)
-
Oh, will this be used in the browser? You'll have to use translate instead (sorry, it's icky): count(xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ListSiteNames[translate(current(),'ABCDEFHIJKLMNOPQRSTUVWXYZ', 'abcdefhijklmnopqrstuvwxyz') = ...
-
In InfoPath Filler, this expression works -> count(xdXDocument:GetDOM("CNSS")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ListSiteNames[msxsl:string-compare(current(), ., "", "i") = 0]) > 0
but when I publish, I've got an error : "an invalid expression has been detected : ...
-
You are great!
It works!
Many many thanks.
-
Yup, I see the issue - see the attached sample form. Save it locally, right click and select design and you can see in the validation on field1, I'm using a count of matches. The XPath I gave you returns a value from a field if it matches, so instead of true / false, you'd be getting the value of the field. I added a calc'd value to my ...