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
Can't Get Text Highlighted When Multiple Tags Are Present
So I am trying to highlight text by selecting it and clicki…
JQuery Val Is Undefined?
I have this code: But when i write $('#editorT Sol…
Can You Relativlely Or Absolutely Position Items In A Display:table-cell?
I have a link that I want to always be at the bottom right …
How Do I Avoid A Page Break Immediately After A Heading
I have an HTML 4.01/CSS 2.1 document that includes an H3 he…
Positioning An Absolute Element In The Center Of It's Relative Parent Element
here is my code i want child element to be at bottom and c…
Output An Array Of Images In JavaScript
I'm new to JavaScript and I made this code. The purpose…
Get Selected Value Of Option With Multiple Dropdown Menus Using Javascript
I have multiple features that have multiple options that ne…
Align Text In Middle/center Of Page And Button On Bottom/center
I am trying to put a label in middle/center part of the pag…
Vertical Floating Div
I have vertical floating div: Solution 1: You…
Dropdown Menu On Refresh Changes Javascript
I have implemented a navbar uisng bootstrap 4,in which I ha…
December 2024
(1)
November 2024
(38)
October 2024
(62)
September 2024
(22)
August 2024
(376)
July 2024
(341)
June 2024
(706)
May 2024
(1294)
April 2024
(806)
March 2024
(1592)
February 2024
(1722)
January 2024
(1420)
December 2023
(1439)
November 2023
(490)
October 2023
(707)
September 2023
(312)
August 2023
(327)
July 2023
(293)
June 2023
(330)
May 2023
(224)
April 2023
(137)
March 2023
(132)
February 2023
(165)
January 2023
(259)
December 2022
(116)
November 2022
(214)
October 2022
(603)
September 2022
(163)
August 2022
(307)
July 2022
(93)
Menu Halaman Statis
Beranda
© 2022 - Html5 Log