-
Maybe try this one. I added a form load rule so that if the employee name is not blank, the query field in your secondary data source is set and the query is executed. I added the same rules on the employee name field. I changed the display area for the prior leave requests to a repeating table. I think the one thing that may need to be modified ...
-
It sounds like the form was not published correctly. Have the form designer publish the template either to SharePoint or a network location. When you say it was sent to you, do you mean in an email?
-
Yeah - you could always add another translate to the rule that sets test comment - translate out the space character as well. I think on the comment field you should add similar rules to those on submit so that the same logic is applied when the comment field changes.
-
So - I made a handful of changes here. First, I made sure that your helper "highlight" field gets set to blank at the beginning of the submit rules (I think I left your submit rule disabled in this copy, so check that too). I also set it blank on form load - of course, if you are setting to blank as part of submit, you won't ...
-
Wonderful! Glad we could come up with a work-around!
-
I haven't figured out anything yet - but I'll take a look in the morning.
-
Yup, Comments is not blank - it has HTML tags in it. :) I'll see if can come up with a work-around for you later today.
-
My guess would be that because comments is a rich text field it may not actually be blank. Can you attach one of the XML files you've saved in your library that reproduces this issue?
-
Here is a copy saved as 2010 compatible.
-
Thanks for the sample - that makes it super easy to help you! See attached - this can be done with validation rules.