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);
});
functionloadIframe(iframeName, url) {
if ( $iframe.length ) {
$iframe.attr('src',url);
returnfalse;
}
returntrue;
}
CopySolution 2:
You can do this using javascript. First you need to add id to the selectSo change your list to<select id="myID"> <====== heres the change
<option value="volvo">Volvo</option>
<optionvalue="saab">Saab</option><optionvalue="mercedes">Mercedes</option><optionvalue="audi">Audi</option>
</select>
var value = document.getElementById("myID");
var selectedString = value.options[value.selectedIndex].value;
Copyhere 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"Copyor use innerHTML
Share
Post a Comment
for "Change Link With Html Dropdown"
Top Question
How To Do Multiple Hover On List
Alright so i wanted to know how i can select multiple items…
WebRTC Video Constraints Not Working
I'm trying to get a lower resolution from the webcam na…
PHP Email & Hyperlinks
I'm trying to include a hyperlink in my email but it is…
How To Get Some Part Of A Html Body In Php
I want to get only some lines of an HTML body and I am usin…
HTML Table With Fixed Header And Fixed Leading Columns With Knockout Controls In The Header And First Column
I have a HTML table which can be customized by the user: E…
JQuery Change Div Background-image With FadeIn/Out
I'm trying to create a fadeIn/Out effect on a site I cr…
Dropdown Menu On Refresh Changes Javascript
I have implemented a navbar uisng bootstrap 4,in which I ha…
SEO Friendly 301 Redirect .htm To .aspx
I currently have a small-midsize website with .htm extensio…
Error On Chartjs And Angular 5 - "can't Acquire Context From The Given Item"
I need to display a graph in my Angular project. A simple d…
How To Merge And Clean 2 Css Files With Overlapping Selectors/properties?
Here I am, trying to do a decent job at maintaining a site …
December 2024
(1)
November 2024
(40)
October 2024
(60)
September 2024
(23)
August 2024
(378)
July 2024
(343)
June 2024
(695)
May 2024
(1290)
April 2024
(800)
March 2024
(1583)
February 2024
(1720)
January 2024
(1400)
December 2023
(1429)
November 2023
(438)
October 2023
(595)
September 2023
(308)
August 2023
(332)
July 2023
(275)
June 2023
(349)
May 2023
(215)
April 2023
(143)
March 2023
(129)
February 2023
(173)
January 2023
(272)
December 2022
(120)
November 2022
(239)
October 2022
(811)
September 2022
(163)
August 2022
(295)
July 2022
(94)
Menu Halaman Statis
Beranda
© 2022 - Html5 Library