Filtering Repeating Table based on Multiple IDs - InfoPath Dev
in

InfoPath Dev

Filtering Repeating Table based on Multiple IDs

Last post 08-17-2011 05:50 AM by 2kranthi. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-11-2011 07:33 AM

    Filtering Repeating Table based on Multiple IDs

    Hi, This is in InfoPath 2007. I have a repeating table with columns ( ID, Question, Response). I need to display only relevent questions to users based on some pre-defined conditions. For example. 1, 2, 3 to UserA; 1, 4, 5 to userB; 1, 3, 4, 6 to userC; 1,12,13 to UserD; I have a hidden text box with value "1, 2, 3". Conditional formatting in Repeating table is set to "Textbox Contains @ID". This is displaying 1,2,3,12,13 to userA in Repeating table. I understand it is because I use "Contains". But couldnt find other way to do this. Please Suggest.
  • 08-15-2011 05:47 PM In reply to

    Re: Filtering Repeating Table based on Multiple IDs

    As long as the pre-defined condition data is in the secondary data source you can use the default filter button with multiple conditions to filter it and ORs. Set a condition on the table that compares the values. This is not hard but you have to have the data and you need to use current() etc. to get the value of the current row.

    Patrick Halstead
    Project Manager at Qdabra
  • 08-17-2011 05:50 AM In reply to

    Re: Filtering Repeating Table based on Multiple IDs

    Thanks Patrick... i will try this out
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.