Newbie Questions

Re: Force Rule Execution

Hilary Stoupa — Mon, 26 Nov 2012 23:16:33 GMT

So the start & end date are just date, and the repeating table is date time from a SharePoint list data connection to a calendar?

Re: Force Rule Execution

BlackBirdJourney — Mon, 26 Nov 2012 23:10:39 GMT

Thank you for your reply. I was looking at your form and realized I did not provide enough details.

The repeating table contains fields from a calendar so the EventDate fields are DateTime. If I was able to use only Date fields it would be fantastic. But I cannot.

I am using something very similar to this but I am not completely thrilled with it.

http://www.manjuke.com/2011/01/how-to-filter-data-correctly-on.html

Re: Force Rule Execution

Hilary Stoupa — Wed, 21 Nov 2012 22:09:01 GMT

I'm just wondering - when you set the start date in your load rule, are you using yyyy-MM-dd format? Because I just tried to reproduce this and could not - I've attached a sample form, save it locally, right click, select design, from there you can take a look at the logic, preview, etc. My table has 3 rows included by default, and is set to hide rows with a date less than the start, but I think the general idea is the same....

Force Rule Execution

BlackBirdJourney — Wed, 21 Nov 2012 21:26:25 GMT

I have three controls on my form.

StartDate <date field>

EndDate <date field>

Repeating Table

The repeating table has a rule/condition on it to hide rows that do not meet a certain criteria (StartDate). If I manually change the StartDate the repeating table is updated. If I have a form load rule set the StartDate the Repeating Table is not updated until I manually set the StartDate again and exit the field.

Is it possible to force the Repeating Table to update through configuration or code (possibly through changed event)?