-
So - yes, I added that, and I also modified the formula for setting the Manager field - you were setting it using the Get Manager query, when I think you already had that data from the user profile query. For setting query fields, we always set them BEFORE we execute the query, because they impact what data is returned. We are saying: ...
-
Ah - I hadn't looked very closely & didn't realize you were running additional rules on the Manager field. Try this copy. Save it locally, right click & select Design to open in Design mode.
-
So - looking at this, a couple things I would try right off - for your rules on EmployeeName, only run those if EmployeeName is not blank. Then, instead of using defaults for Manager / Manager Name, set the fields via rules on the EmployeeName field after you run the query.... Does that make sense? You could also add rules to EmployeeName to clear ...
-
Thanks, I'll take a look later today or tomorrow AM and see if I can figure out what's up (or a work around!)
-
Any chance I could see your template? That would help me set up a repro.... You can attach it under the Options tab in a reply.
-
In my sample form, I was able to just copy / paste my highlighting rule onto my datetime field and change it to a validation rule - maybe try that?
-
Awesome, glad you have it working. :)
-
Is this a customized list form? Or is it a regular form? When do you run the data connections and set the fields?
-
-
You could use the translate function to replace the period with a space (if you have a space between FIRST LAST above). You can use substring-after to get rid of AD\ - substring-after(field, "AD\")