Filter repeating table for a date range or last 5 records

[John S.]

Hello,

I want to know if it is possible to filter a repeating table to show only
records between a specific date range and also to show only 5 of the latest
records. Any help is appreciated.

Thanks

 

[Bojana Marjanovic [MSFT]]

Hi John,

You can filter a repeating table to show only certain records by setting
some conditional formatting on the table itself (not one of the fields
within the table). You should be able to easily set the conditions for the
specific date range and then enable the 'Hide this control' checkbox.

As for showing only the five latest records, that will require some code.
You'll have to make sure that the XML is sorted by date and then show the
last five instances.

-Bojana

 

[Albator]

Hi,

For complete the answer of Bojana:

If your repeating table is a main dataource you can in properties of
the section (display tab) filter data.

this feature is only possible for a main datasource. So if you use a
secondary datasource you need to make a filter before that enter in
infopath or by code like say Bojana

Thierry

 

[John S.]

Thanks for the quick replies, but I cannot filter the records for a date
range (e.g today() - 10 does not work).