Hi: I am fairly new to InfoPath development, and have run into an issue, was wondering if someone could guide me.
I have an InfoPath 2013 form that is filled out initially by a user. It is an Audit form. Other users are assigned tasks from this. Each task is in a row, with the users email, and a date of completion. The number of users can change from one month to the next, so the rows are dynamically created.
The first user (who is the Auditor) then reopens the form when the other users have supposedly filled in their data including the date. The Auditor checks the entries and fills in the Audited Complete Date. I have been asked to disable the submit button for the Auditor, if not all of the task completion dates have been filled in. So if even one of the dates is blank, then disable the submit button.
I have a rule for each of the task rows on the taskDateCompleted field. (numbered 1 to 20)
Condition: If AuditChampionReviewDate != "" and TaskDateCompleted1 !="" then
Action: Set the field value TaskDateFilledCount = TaskDateFilledCount + 1
So this gives me a count of all of the rows that have the DateofCompletion filled in
When that AuditChampionReviewDate is filled in, I check the TaskDateFilledCount and if it is less than the total number of Task Rows, then I enable the submit button for the Auditor. If not, then that means that there is one or more TaskDateCompleted fields that are blank.
My problem is that the AuditChampionReviewDate change from blank to filledin, does not trigger the TaskDateCompleted Rule.
Is there a way to trigger/refresh these rules for the TaskDateCompleted when the AuditChampionReviewDate changes from blank to Filledin?
Thanks,