-
Here is the XPath on the Count of Rec field: count(xdXDocument:GetDOM("RECList")/data-set/record/RECNum[../BUNum = xdXDocument:GetDOM("BUList")/data-set/record/BUNum])
The result:
Image of result: https://drive.google.com/file/d/0BxlPX1FIi-PDeFRPQWEwSzgtZXM/view
Here is the xsn file: ...
-
Wow, I really don't know. Everyone is using the same browser? This is a filler form, right? Everyone has signed into Office 365 and clicked "remember me"?
-
Use a REST data connection maybe? No qRules needed for that, but REST allows for more complex filters.
-
So - can you paste the full XPath of an attempt at the formula in a reply? Create the formula with the filter (selecting the repeating row in List 2, select filter data, select the BU # is equal to the BU # in List 1) then select the Edit XPath checkbox and paste the result in a reply & I can probably give you a hand. :)
-
Hi there,
If the field's data type is Date then you can use the format 14 March, 2001.
As far as why it's displaying then you have to check the 'calculating rules'. Your post didn't provide enough info for any further recommendation.
-
I have to SP lists
List 1: BU List
BU#1 BUName1
BU#2 BUName2
BU#3 BUName3
List 2: REC List
BU#1 REC#1 RECName1
BU#1 REC#2 RECName2
BU#3 REC#3 RECName3
BU#3 REC#4 RECName4
BU#3 REC#5 RECName5
I have an IP form with connections to BU List & REC List
I would like to have a repeating table to display BU List with 1 ...
-
Hi Rodman,
Let's call the text field that houses the Engineer's name is txtEName.
When GetUserProfileByName runs, we check txtEName field.
If txtEName is blank then place the FullName from Getuser to txtEName; otherwise, just don't do anything.
Logic behind: When Engineer creates the form, the txtEName must be blank so ...
-
Alan,
Again thank you for your quick response.
I will experiment with your solution on a test from and evaluate the results.
Again, Thank You!
- Rodman
-
Worst XPath EVER. Here's from a test form I set up:xdXDocument:GetDOM("UTA_HR_UTA20-BAD")/ns1:webRowSet/ns1:data/ns1:currentRow[ns1:columnValue[number(xdXDocument:GetDOM("UTA_HR_UTA20-BAD")/ns1:webRowSet/ns1:metadata/ns1:column-definition/ns1:column-index[../ns1:column-name = "A.EMPLID"])] = ...
-
Hi Rodman, thanks for the extra information and I see the problem.
Completing a step in a process and 'cheating; the system to act as someone else is particularly complicated I believe. The last person to work on the form will (should? ) always be the person whose name appears in the 'last modified' ...