Monday, December 3, 2012

yogi_Publish Results For Self Serve On Line Review By Candidates

                                          Google Spreadsheet   Post  #908
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Dec 3, 2012

user Tl1 said:(!mydiscussions/docs/A0Eyp5BJyfI)
Publish Spreadsheet as simple data module

I run a competitive fishing league.  My League Data is in a spreadsheet.  

What I'd like to do is create a simple online module so competitors could see a list of their individual scores. And do this without publishing the entire 300x300 cell spreadsheet.  

What I'd like is a really simple search window that might auto-complete the competitors name and then return a list style Card with their comps listed vertically.

My data is arranged very simply:. Rank Column A, Competitor Name Column B, Pt Total Column C... then Columns D through XX are Individual Comps.  Would be nice to omit empty cells and/or Zero cells in the search result.

I'm not even sure what to call this! Is it a form, or a widget, or a function, or a script, or a web app?  

Many thanx for any help or direction to look in.

Here is the spreadsheet:

in the following I present a solution where a FORM is published on a website to capture the name of the candidate who want to read the results on-line -- behind the scenes the candidate's name is used to pull the candidate's result and the result is published on the website

and here is how the candidate's results are presented:
and here is an image of the dataBase where the candidate's data is stored