Data Connections

Re: Trying to populate a form field from another filtered list field

TOE_CHEESE — Fri, 22 Dec 2017 17:14:54 GMT

Following up my last post... Here is the route I eventually took.

I pushed the "Modified" into a calculated column as a contiguous string as =TEXT(Modified,"YYYYMMDDhhmm").

This allow me to bring the "strModified" in as a field filtered as xdMath:Max(xdXDocument:GetDOM("Receive")/dfs:myFields/dfs:dataFields/ns3:SharePointListItem_RW/ns3:strModified[../ns3:Group = "GOLD"]).

I then used this xPath to get the most recent (last modified) total into my target field: xdXDocument:GetDOM("Receive")/dfs:myFields/dfs:dataFields/ns3:SharePointListItem_RW/ns3:Target_x0020_Field[xdXDocument:get-DOM()/my:myFields/my:Totals/my:GOLDmax-modified = xdMath:Max(../ns3:strModified)]

Re: Trying to populate a form field from another filtered list field

TOE_CHEESE — Tue, 19 Dec 2017 18:48:13 GMT

Hi Hilary,

Sorry for not posting back sooner but I've been busy working through so many different combinations to achieve my goal. I just could not get max(Modified) to return a value even without any additional filters. I kept getting "NaN".

I went on to try concatenating the max(ID) with the Source Field which I could then successfully use max(concat_field) to get the most recent source total (concatenated). However getting the actual source field using the substring function becomes problematic after the ID increments from 1 to 2 then to 3 digits. This may still be an option with some conditional rules.

So now I am trying to use current() to get the source field where it equals max(ID).

Falalalala Lalalala Tis the season.

Re: Trying to populate a form field from another filtered list field

Hilary Stoupa — Fri, 15 Dec 2017 16:11:53 GMT

So you always need the most recent one? I think you are getting close with your XPath attempt - but the issue is your Max function uses a relative path to the modified field which is going to only compare to the current row.... This is just a guess, and my syntax may be wrong:

xdXDocument:GetDOM("Receive")/dfs:myFields/dfs:dataFields/ns3:SharePointListItem_RW/ns3:Source_x0020_Field[(../ns3:Group = "GOLD")][(../ns3:Modified = xdMath:Max(../../ns3:SharePointListItem_RW/ns3:Modified))]

Trying to populate a form field from another filtered list field

TOE_CHEESE — Wed, 13 Dec 2017 22:29:56 GMT

Hi, I am building an InfoPath 2010 browser form that has a "target field" that gets it's value from a "source field" in another list. I have a secondary data connection on the list and I can bring the source field value into the target field on my form. However the source field value will change over time and I need my target field to pull in the most recent source field value. I need some help to build a filter to retrieve the most recent source value where another field equals a group name. My thought is to use the modified date.

This is what I am using to get the source field value into the target field... xdXDocument:GetDOM("Receive")/dfs:myFields/dfs:dataFields/ns3:SharePointListItem_RW/ns3:Source_x0020_Field[../ns3:Group = "GOLD"]

Here is something I've tried... xdXDocument:GetDOM("Receive")/dfs:myFields/dfs:dataFields/ns3:SharePointListItem_RW/ns3:Source_x0020_Field[(../ns3:Group = "GOLD")][(../ns3:Modified = xdMath:Max(../ns3:Modified))]

Any help is appreciated.