I'm trying to use the values from an HTML dropdown menu to change the 'where' of the Google Spreadsheet query HTML table. Here's the dropdown as I have it so far:
Solution 1:
$('option').click(function(e){
var $item = $(e.currentTarget).attr('value');
updateIframe($('iframe'), $item);
});
function loadIframe(iframeName, url) {
if ( $iframe.length ) {
$iframe.attr('src',url);
return false;
}
return true;
}
Copy
Solution 2:
You can do this using javascript. First you need to add id to the select
So change your list to
<select id="myID"> <====== heres the change
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="mercedes">Mercedes</option>
<option value="audi">Audi</option>
</select>
var value = document.getElementById("myID");
var selectedString = value.options[value.selectedIndex].value;
Copy
here selectedString contains the value to be added to the string in IFrame.
var Url="https://docs.google.com/spreadsheets/d/*spreadsheet key*/gviz/tq?tqx=out:html&tq=select+A,B,D,E,F,G+**where+D+contains+selectedString+&gid=2105149734"
Copy
or use innerHTML
Share
Post a Comment
for "Change Link With HTML Dropdown"
Top Question
Implementing Localstorage
Currently working on an e-commerce website, which is my fir…
HTML5 Image Drag Event - CtrlKey Remains False In Firefox 29
This works great in Chrome, but what do I need to change to…
How To Get Floated Divs Align To The Top?
The code below can be viewed in this fiddle: http://jsfiddl…
How To Get Text From Scrolling Off Bottom Of Container, Yet Keep Scroll Bar On Far Right Of Browser?
How can I get the following site to work so that if the tex…
Trying To Make A Div Appear When A Button Is Clicked
Here is the code , first of all why is the div showing up w…
Php Form - Undefined Constant ’php_self’
I have a contact form, it works fine when hosted on my serv…
Unable To Get Bootstrap Tooltip To Display Above Div When Inside Scroll Pane
Currently I have 2 panes/columns on my site page displayed …
Half Transparent Div Above Image
I have a PNG image of a character, and I want something lik…
Is An Editable Select Box The Right Way?
I have a scenario where a user is emailing another user in …
How To Limit The Html Table Records In Each Page
I am populating a table in my jsp which has more than 20 re…
December 2024
(1)
November 2024
(34)
October 2024
(58)
September 2024
(22)
August 2024
(361)
July 2024
(340)
June 2024
(695)
May 2024
(1294)
April 2024
(794)
March 2024
(1534)
February 2024
(1688)
January 2024
(1343)
December 2023
(1358)
November 2023
(464)
October 2023
(543)
September 2023
(305)
August 2023
(329)
July 2023
(256)
June 2023
(374)
May 2023
(214)
April 2023
(152)
March 2023
(141)
February 2023
(171)
January 2023
(177)
December 2022
(130)
November 2022
(206)
October 2022
(184)
September 2022
(156)
August 2022
(286)
July 2022
(96)
Menu Halaman Statis
Beranda
© 2022 - Code Html5