General

Re: Filtering Repeating Table based on Multiple IDs

2kranthi — Wed, 17 Aug 2011 12:50:36 GMT

Thanks Patrick... i will try this out

Re: Filtering Repeating Table based on Multiple IDs

Patrick Halstead — Tue, 16 Aug 2011 00:47:01 GMT

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.

Filtering Repeating Table based on Multiple IDs

2kranthi — Thu, 11 Aug 2011 14:33:23 GMT

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.