General

Re: Can we have a fitler in a repeating table?

Jhoanna — Wed, 19 Sep 2018 03:55:27 GMT

.xsn attached

Re: Can we have a fitler in a repeating table?

Jhoanna — Wed, 19 Sep 2018 03:53:55 GMT

on browser error

Re: Can we have a fitler in a repeating table?

Jhoanna — Wed, 19 Sep 2018 03:52:37 GMT

Hello, was able to use another workaround, now what I needed is just a filter for Sub discipline (multiple line) based on Discipline being selected. I used xml document data connection which I converted.

Weird part, it was working offline but on browser it gives an error. I'll attach the error screenshot on my reply here - thanks

Re: Can we have a fitler in a repeating table?

Hilary Stoupa — Mon, 10 Sep 2018 22:48:44 GMT

Oh - I see, you are setting query fields then executing the query. I hadn't realized that - I thought you just were using conditional formatting. You may want a rule to clear the query fields after the query executes so that you don't have a stray value confusing things. I think you also may want to have your rules just set the query fields, then add another rule on your search button to run the query, in case the user has made selections from more than one of the dropdowns. Some list field types aren't query-able, like the multi-select. For those, you will need to use conditional formatting on the repeating table to hide the rows you don't want the user to see.

Re: Can we have a fitler in a repeating table?

Jhoanna — Thu, 06 Sep 2018 22:39:58 GMT

screenshot

Re: Can we have a fitler in a repeating table?

Jhoanna — Thu, 06 Sep 2018 22:37:25 GMT

Attached. Basically the search result is the one I wanted to filter, based on its result values. Example, given the search returns a long table of values, I can use then the filter to select or trim from the repeating table.

I think it would only work if I selected to search for all, no sense if I searched under Discipline dropdown, perhaps the subdiscipline can be filtered and the employee display name - cascading.

Also for the subdiscipline column, it is a multi text column, how come it is not returning a value in data connection queryFields.

Thank you.

Re: Can we have a fitler in a repeating table?

Hilary Stoupa — Thu, 06 Sep 2018 15:05:02 GMT

It is really just a matter of setting the conditional formatting on the repeating table based on your criteria. Feel free to attach a copy of your form under the Options tab in a reply - It is hard to give you specific information without knowing your form schema.

Re: Can we have a fitler in a repeating table?

Jhoanna — Thu, 06 Sep 2018 02:02:25 GMT

Thank you – how about this scenario – I have a search engine on top, and on result I can use the filter?

Also another thing, for the CV Status field, can I get this value from another source passing the Employee Display Name as parameter?

Re: Can we have a fitler in a repeating table?

Hilary Stoupa — Wed, 05 Sep 2018 15:13:35 GMT

I've attached a simple sample of one approach. Save the file locally & preview to try it out.

Can we have a fitler in a repeating table?

Jhoanna — Wed, 05 Sep 2018 05:41:19 GMT

Hello, it is me again.

This is just to seek help if there's a way we can put a repeating table filter?

Thanks in advance!

Jhoanna