yogi_Display Commission Earned By Viewing Team Member Only Without Giving Team Members The Right To EDIT Spreadsheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #604   Jul 1, 2012     www.energyefficientbuild.com.

I created this illustration in response to a comment by use KECSS in my following blog post

http://yogi--anand-consulting.blogspot.com/2012/06/yogidisplay-commission-earned-by_25.html

the idea is to display the viewing Team Member's Commission history in a web page without having to give the viewing Team Members the right to EDIT the spreadsheet.

here is an image of the Commission Data1

.

and in the following I show the setup of the Form for SUBMITting Passcode by the Viewing Team Member and then viewing upto 10 rows of Commission for the SUBMITted Passcode
  here is the Form via which Team member SUBMITs her/his Passcode and then after SUBMITting the Form refreshes the browser to view upto 10 rows of Commission data

or you may make the spreadsheet available only for View by hiding all the other sheets except the sheet CommissionLookupByPasscode(TextOrNumeric)1