I’m really struggling with this one guys. Please, I only need a pointer in the right direction.
I have 2 forms and after a previous pointer in this forum, changed the forms to store the necessary information.
The one sends a survey to more than one person. The Survey Send form has the Reviewer Name and a Description of the survey sent. I aslo record the date it was sent. So, it has the multi-value Reviewer fields value, the Date Sent and the Description. (Cause the survey can be sent to more than 1 person at a time).
Then I have a Survey form, which receives the surveys sent back to the mail in database. It will have the Reviewer Name, the Description and holds the Date it was sent from the database, in other words, the date the Reviewer received the Survey.
So the 2 forms have 3 fields in common. The Reviewer (however the one is a multi-value field and the other one isn’t), the Date Sent/Received and the Description.
I now need to check, that if the Survey hasn’t been received back into the mail-in database, 9 days after it was sent, a Reminder should go out to the Reviewer.
I know how to get the 9 business day working, I just don’t know how to check the 2 forms to see if it is there or not, cause the one has a multi-value for Reviewer.
I only need a pointer.
Thanks