General

Re: Trouble with filter conditions on a repeating table

kammy — Thu, 25 Oct 2007 16:30:40 GMT

I changed my form to use conditional formatting, as you suggested instead of filtering and it works great! I thought the whole repeating table would be hidden if I used the conditional formatting, but now I see it only hides the records that don't meet the criteria. Perfect. It also eliminates another issue I was having - if the Start and End Date fields were blank and I tried to insert an new record in the table, as soon as I would enter the date the new record would disappear (the filter ran). I had entered default dates in the Start/End fields to work around that, but by using the conditional formatting, I don't need to use defaults. Double-bonus!

Thanks again for the help - truly appreciated!

kammy

Re: Trouble with filter conditions on a repeating table

kammy — Thu, 25 Oct 2007 15:58:00 GMT

I am not using conditional formatting, I am filtering the data based on values in the form. Hmmm... maybe I'll try the conditional formatting instead. I'll let you know how that goes.

I attached my form which won't work since you don't have access to the db, but maybe if you open it in design format, you can see what I've done.

Thanks for the assistance - I appreciate it!

Re: Trouble with filter conditions on a repeating table

Shiraz Cupala — Tue, 23 Oct 2007 20:24:29 GMT

Interesting. I was not able to repro your issue. Your conditional formatting on the repeating table should be a single condition which is:

if rowDateField is less than startDate OR

if rowDateField is greater than endDate

then hide.

I hope this helps.

Trouble with filter conditions on a repeating table

kammy — Mon, 22 Oct 2007 17:55:46 GMT

I have a form with a repeating table. I have a "Start Date" field and an "End Date" field. In the repeating table properties I have a display filter which has two conditions that show the records that are "greater than or equal to the Start Date" and "less than or equal to the End Date". When I enter dates and the filter is run, I do not get the records between and including the dates entered in the "Start Date" and "End Date" fields. It appears that the "greater than or equal to the Start Date" works, but the "less than or equal to the End Date" does not. If I enter tomorrow's date in the "End Date" field the correct records are returned - it seems that the 'equal to' part is not working. Anyone else ever encounter this? Thanks for the help. Kammy