-
You didn't have the namespace prefixes in your XPaths for your 2ds - easy mistake to make & my 2ds didn't have namespace prefixes. count(preceding-sibling::d:SharePointListItem_RW[d:Customer = current()/d:Customer and contains(d:Problem_x0020_Statement, xdXDocument:get-DOM()/my:myFields/my:Search/my:txt_ProblemStmnt)]) > 0
-
I'm attaching my xsn...
I'm sorry, but I just can't get the preceding sibling just right....the customer is repeating (yellow), but I think all the other parts are working. I also tried to build the calculated value, like you did, to test and I can't get that work either. So, I know it's ...
-
Try this one. EDIT - the attachment isn't showing so I'm editing to see if it uploads. :)
-
After installing FormsViewer on SharePoint 2016 on premises server, I'm not able to get any data from People Picker in forms.
To be sure, that this is not my existing forms issue, I just created a new form that contains only one People Picker field and nothing else. I've specified my server address in SharePoint Server tab ...
-
Hi Arthur,
It sounds like FormsViewer is successfully querying the database so I think your connection string is fine.
Since you are using Integrated Security, I believe that the only account that would need permissions is the FormsViewer site's app pool identity. It should have both read and write access to the DB.
-
I got it, sorry about that. I'll change it later today & upload it again.
-
Sorry, it does the opposite. If I pick A for the field1, I would expect values with an "a" to show, but instead they hide, and you get all values that don't have an "a". So, it's an "opposite key word search" :)
-
So - this doesn't work as it is currently set up? I thought when I previewed it that it did what you needed.
-
Just to clarify - on your field 1 drop down, this is the keyword search (I'm thinking). On the hide rule for the repeating section, you have value contains field1. I'm thinking you mean doesn't contain right? You want to hide it if the value is not found in the text. When I swap that to "does not contain", the ...
-
Thanks! I'll check it out :)