Compare fields from a repeater table to a non-repeating table field - InfoPath Dev Sign in | Join | Help in Code InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Code » Compare fields from a repeater table to a non-repeating table field Compare fields from a repeater table to a non-repeating table field Last post 03-14-2012 08:14 AM by Hilary Stoupa. 3 replies. Page 1 of 1 (4 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 03-13-2012 10:17 AM smitman34 Joined on 03-13-2012 Posts 11 Compare fields from a repeater table to a non-repeating table field Reply Contact How do I evaluate the first field of a repeating table to another field not in the Repeating Table when the data in the first field of the repeating table changes? If they are not equal I want to set another field (status) to say they are not equal. 03-13-2012 02:55 PM In reply to Anson Hidajat Joined on 11-28-2011 Posts 619 Re: Compare fields from a repeater table to a non-repeating table field Mark as Not AnswerMark as Answer... Reply Contact You need to set an action rule on the repeating field that says:Condition - if repeating field is not equal to other fieldAction - set a field's value status = newstatusHope this helps! Anson HidajatQdabra® Software/ InfoPathDev.comThe InfoPath Experts – Streamline data gathering to turn process into knowledge.™ 03-13-2012 06:12 PM In reply to smitman34 Joined on 03-13-2012 Posts 11 Re: Compare fields from a repeater table to a non-repeating table field Mark as Not AnswerMark as Answer... Reply Contact But how do I limit the action rule to only be run when the first field in the repeater changes? 03-14-2012 08:14 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Compare fields from a repeater table to a non-repeating table field Sample.xsn Mark as Not AnswerMark as Answer... Reply Contact You can do this with a condition that a count of the preceding-sibling nodes = 0. See attached sample - right click the link in the heading of this post, save the file locally. Right click the saved file and select design to open in design mode. From there, preview. Hilary Stoupa Page 1 of 1 (4 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
How do I evaluate the first field of a repeating table to another field not in the Repeating Table when the data in the first field of the repeating table changes? If they are not equal I want to set another field (status) to say they are not equal.
You need to set an action rule on the repeating field that says:
Condition - if repeating field is not equal to other field
Action - set a field's value status = newstatus
Hope this helps!
You can do this with a condition that a count of the preceding-sibling nodes = 0. See attached sample - right click the link in the heading of this post, save the file locally. Right click the saved file and select design to open in design mode. From there, preview.