Filter an Access Webform based on current SharePoint User -
building issues log ms access 2010 database linked organization's sharepoint 2010 site. want in organization able submit issue database via webform have created. building submitter's log webform people can see status of issues have submitted. language filter form based on current user? thought below didn't work.
filter| sharepointauthor = [me]
i figured out on own. web form taking info normal (non-web) query , created web query , set "currentwebuser(1)" in criteria under sharepointauthor field. "1" returns display name. "0" gives current user’s fellow member id, "2" gives current user’s login name, , "3" gives current user’s e-mail address.
i learned latter part site: http://accesshosting.com/demystifying-currentwebuserx
ms-access sharepoint webforms filtering
No comments:
Post a Comment