Hello,
I have an interesting problem. A have a browser-enabled form with code but it doesn't seem to work as it should. The code runs correctly in the client, but in the browser, it doesn't work.
The purpose of the form is to allow users the ability to update information based on their sales region. The form references two SharePoint lists in the form of XML files.
The first SP list matches a user with their respective sales regions. Thus, a user should only have access to their sales regions. The second SP list associates the sales items to the region.
Basically, the user should be able to do the following:
- Select their region from a dropdown list
- Select the sales product from another dropdown list (this list is filtered based on the selection from the first list)
Ideally, the form performs the following functions:
- Captures the user ID (via a rule). The user ID is used to filter the first SP list.
- Filters a dropdown menu for the sales regions associated to the user ID (loading event code)
- User selects their region from the dropdown list
- The second SP list is filtered based on the user's selection (code)
- The user selects the sales product from the second dropdown
I'm using the form's loading event to capture the user's ID and then filtering the first SP list. Again, for some reason this only works in the client and not in the browser enabled form. Any help would be much appreciated.
Thanks,
David