-
Probably easiest to just use query fields for this. Set the Reporting Manager query field in the list data connection to the account id of the reporting manager. Set the dropdown (whatever field in your list that is) query field to Yes. Then run the query. That way, if you get a row back you don't have to add XPath filters. That may be a ...
-
See if the attached sample is helpful. Right click the linked file, and save it locally. Right click the saved file and select design to open in design mode - then you can preview.
-
I added a few things to this copy that might help you figure it out. I added a form load rule that may help get the reporting manager - you'll see I'm setting the query field prior to running the query. I put the backup manager list data on the form for you so you can see it. I added an expression box that gets the Backup manager if the ...
-
When you test your form as is, what is displayed in field26? Please remember that XPath is case sensitive, so "Yes" and "yes" are not the same thing.
-
Do you get the value you anticipate in field26? I don't see any rules on field26 that would set any other fields.
I'm having a very hard time trying to understand the goal here (or really, the point?) So - if the user's reporting manager is in the Backup Manger list, in the Reporting Manager column, and ...
-
Can you direct me to where these rules are? You mention "Option field = Y" but I'm not sure if that is in the main data source or in the secondary. When should this backup logic be running? In the Form Load rules where you set the requester and manager?
-
Can I see a copy of your form? You can attach it under the Options tab in a reply.
-
Can I see your form? You can attach it under the options tab in a reply.
-
Not to my knowledge. I suppose if you were displaying the form in a web part you might be able to use jQuery or JavaScript for this.
-
Good deal. Hopefully you can download from Hightail without an issue.