yogia_Recreating Form from Form Responses Sheet For Select Fields Per Specified Condition

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user ggamauf said:

with your help i created the following -> 

=arrayformula(if(row(A:A)=1,"Click on Link in corresponding row to recreate Form as was originally submitted",if(len(A:A),hyperlink("https://spreadsheets.google.com/spreadsheet/viewform?formkey=dF9MaXlkV2RQS1F5NFcxWDFBZmZwM3c6MQ&entry_0="&b1:b&"&entry_1="&c1:c&"&entry_2="&d1:d&"&entry_3="&e1:e&"&entry_4="&f1:f&"&entry_5="&g1:g&"&entry_6="&h1:h&"","recreate form"),iferror(1/0))))

now i need to say (eg): 

only if field b is filled display fields c and d

or only if field d is filled display fields a, b and c (always WITH contents)

what's the formaility for doing this?

can i read this somewhere?

i don't even know: is this javascript?

-------------------------------------------

we are using Google spreasheet formulas
following is the solution to the problem for the first part of user's question ... solution to the second part can be adapted from the solution to the first part of the question

Please note:
1) that per the specified condition only those records in which the field for Question 1 is not blank have been prepped for recreating the Form as originally submitted
2) and for select records per 1) answers only for Questions 1,2, and 3 will be filled in the Form

here is the Form that will be seen if the hyperlink recreate form for record 3 is clicked:

yogi_Create An On-Line Calculator To Sum Up Fractions In Fractional Notation

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
In my following blog post:
yogi_Sum Up Fractions And Present The Result In Fractional Notation
http://yogi--anand-consulting.blogspot.com/2011/12/yogisum-up-fractions-and-present-result.html
I had presented a solution for Sum Up Fractions And Present The Result In Fractional Notation.

In this post I present an on-line calculator where a user may submit the fractions to be summed up via a Form and then read the resulting sum of fraction on-line.

fill the following Form:

Submit it and your resulting sum of fractions will be presented in the On-line Calculator

here is the On-Line Calculator

you will need to refresh the browser to see your sum of fractions presented in the On-Line Calculator

this is a test
embedding a chat



next to text let us keep typing and see what happens
paragraph and
let us see how
it affects presentation
of the chart
on the web site

yogi_Plot Line Chart For hh:mm Values

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user jiri.blazek said:
(How to) Plot line chart for hh:mm values

I need to plot a chart from a column filled with hh:mm data. Google Spreasheets says data not valid. Works fine with plain numbers. Works ok in Excel, see desired outcome here:

http://screencast.com/t/tcwzDDzUvuw

Is it doable in Google Spreadsheet?

thanks,

Jirka

-----------------------------------

What I have noticed is that even though it complains about the data being in hh:mm, if you continue, it does plot the data anyway -- however for the minimum and maximum values on the vertical scale, it did not honor the minimum and maximum values specified in hh:mm

yogi_Publish A Spreadsheet Interactive Chart In A Web Site

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user normfisher said:
I'm attempting to embed charts created on a spreadsheet on a page in my Wordpress site using the publish chart function.
I'm attempting to embed charts created on a spreadsheet on a page in my Wordpress site using the publish chart function. The chart displayed on the webpage after pasting the code is pretty messed up. Most of the data is missing. What does displayed is mixed up. 
Here's my spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AoW4uvn3aibIdDEwMjRCVjQ2MUFzSHp5OEgwME5HVVE
Here's the page it's displaying on: http://teamfisher.com/test-page/
I'm using mac osx and see the same result in safari and firefox. Would appreciate any suggestions.
Thanks.
--------------------------------------------
I checked it out in my blog post by publishing an Interactive Chart ... and the published chart is fine. I think what you need to do in your web site is to make sure that you adjust the values of the width and height parameters to suit the space you allocate to the chart in your website.

here is the script for the interactive chart without the opening angle bracket before script, and without the closing angle bracket after javascript"
script src="//ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js" type="text/javascript"
{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AkHBcyclu11AdFRsXzRpaUVTR0lxbm9GRG1CaTU5aGc&transpose=1&headers=1&range=A1%3AG3&gid=0&pub=1","options":{"reverseCategories":false,"series":{"0":{"color":"#000000"}},"title":"Five year history of residential sales and listings - Saskatoon MLS\u00ae","backgroundColor":"#FFFFFF","legend":"bottom","logScale":false,"hAxis":{"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},"hasLabelsColumn":true,"reverseAxis":false,"isStacked":false,"width":600,"height":371},"state":{},"view":"{\"columns\":[0,1,2]}","chartType":"BarChart","chartName":"Chart2"}
/script
and finally without the opening and closing angle brackets for /script

and


here is the script for the interactive chart without the opening angle bracket before script, and without the closing angle bracket after javascript"
script src="//ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js" type="text/javascript"
{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0AkHBcyclu11AdFRsXzRpaUVTR0lxbm9GRG1CaTU5aGc&transpose=1&headers=1&range=A1%3AG3&gid=0&pub=1","options":{"reverseCategories":false,"series":{"0":{"color":"#000000"}},"title":"Five year history of residential sales and listings - Saskatoon MLS\u00ae","backgroundColor":"#FFFFFF","legend":"bottom","logScale":false,"hAxis":{"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},"hasLabelsColumn":true,"reverseAxis":false,"isStacked":false,"width":800,"height":371},"state":{},"view":"{\"columns\":[0,1,2]}","chartType":"BarChart","chartName":"Chart2"}
/script
and finally without the opening and closing angle brackets for /script

yogi_Permit Viewers To Sort Pubished Spreadsheet On The Web

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user celawson said:
Allowing others to 'sort sheet A-Z' without giving them full editing permission
Hi, I want to share a spreadsheet with readers of my blog.
The spreadsheet shows the price increases a company has made, and I have several fields: Product Series (ie. the Ikea Malm series), Product Name, Product Type (ie. sofa, bed, desk), Price before increase, Price after increase, Percentage change.
Ideally, I'd like my readers to be able to sort the spreadsheet, ie. sort by 'percentage change' to see which prices have hardly changed at all, and which prices have changed a lot. But that would require giving them permission to edit (I think). I don't want to do that because that means that someone could technically delete all of it, or change the prices etc. and other readers wouldn't be getting the right information.
Is there any way to either
a) allow them to sort the columns without allowing them to edit actual cells; or
b) allow them to edit the spreadsheet however they like, but any changes they make are not saved (or saved as a copy) and the original spreadsheet remains intact and unchanged.
I know I could just put the sheet up available for download and then people could do option b), but I think the file would be more accessible if it was available to sort within the browser. (I know that in my case, if I was linked to a download from a blog - even one I trusted - I would see downloading, opening, and sorting as much more of a bother than viewing and sorting in browser, so I might be turned off the idea).
Thanks in advance
-------------------------------
following is a solution to the problem ... I have created a sample spreadsheet and published it in List View ... the viewers can see the spreadsheet, play with it by sorting it by an y column but the viewers can neither edit nor save the spreadsheet.

Happy New Year!

Yogi Anand, D.Eng, P.E.                                                           Google Spreadsheet                      www.energyefficientbuild.com

Cheers!

Yogi

Cloud Computing -- Google Docs Way

yogi--anand-consulting.blogspot.com