Sunday, October 21, 2012

yogi_Extract Info For A Specified File Number From Database Into Client Viewer

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #818  Oct 21, 2012    www.energyefficientbuild.com.

user Eli noob said: (http://productforums.google.com/forum/?zx=9jrp4o21m1am#!search/Eli$20noob/docs/eohWDpuxeJ8/5m9U9NKgT20J
Make all the cells in Sheet B all shift there reference to Sheet A at the same time. 

I just want Sheet B to show me the data from one row at a time of Sheet A (Sheet B will be formatted to make the data more accessible visually).  Is there a way to make all the cells in Sheet B retainer the column values but simultaneously change to the same row value?  Sort of liek a customized "List View" I guess.  Is this possible for a noob?
Eli
---
https://docs.google.com/spreadsheet/ccc?key=0AoAR32tQ8wVydDJPRFVibW5MNS1KZG1sbENCR3B6NWc

So if the database page is just the dumping ground for data, the client viewer page is where I can view one client at a time.  I would like to be able to change the File Number cell on the viewer sheet and have all of the info in the other cells shift with it.  SO if the file number is 1234, the other cells should be populated with Joe Blow's data.  But if the file number cell shows 1235, then the data in all the other cells should reflect information about Jane Crane.

Does this explain it?
----------------------------------------------------------------------------------------
following is a solution to the problem


5 comments:

  1. How to create a monthly report?

    Please help



    https://docs.google.com/spreadsheet/ccc?key=0Am5GTjwDOT49dC03M24xeDVQUUlZTDhnVUZ0d3FaRWc

    ReplyDelete
  2. Hi Mohamed Hanafy:

    try
    =query(index(A:E),"select month(Col1)+1+year(Col1)/10000,count(Col3) where upper(Col2)='N' group by month(Col1)+1+year(Col1)/10000 pivot Col5 label month(Col1)+1+year(Col1)/10000 'month.year' ")

    I will illustrate this in a blog post and provide the link to that here for you.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  3. Hi Mohamed Hanafy:

    I have created an illustration for you in my following blog post:

    yogi_Compute Number Of Done Hot Open And Total Jobs For Specified Employee By YearAndMonth
    http://yogi--anand-consulting.blogspot.com/2012/10/yogicompute-number-of-done-hot-open-and.html

    please note I have changed the solution a bit from the formula I gave you in my preceding response to your comment.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com


    ReplyDelete
  4. Excellent post, I will be checking back regularly to look for updates.

    Hosted IP

    ReplyDelete
  5. Great Irene_J ... Now Let Us Keep Googling.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete