I am trying to create a web query parameter for this url but am having great deal of difficult please help i will give both urls as 1 is decoded
and
I trying to change the 36 so if i have a cellA1 if i change that value to 35 the url will change to 35 or could even do the whole "Week 35"
HTML:
https://docs.google.com/spreadsheets/d/1IJI83Lu-KDzIJigb6DDHrRiuo0jngpsBG9yyMHefSJ4/gviz/tq?tqx=out:html&gid=343315703&tq=select%20A%2CB%2CC%2CD%2CE%20WHERE%20C%3D%22Week%2036%22
and
HTML:
https://docs.google.com/spreadsheets/d/1IJI83Lu-KDzIJigb6DDHrRiuo0jngpsBG9yyMHefSJ4/gviz/tq?tqx=out:html&gid=343315703&tq=select A,B,C,D,E WHERE C="Week 36"
I trying to change the 36 so if i have a cellA1 if i change that value to 35 the url will change to 35 or could even do the whole "Week 35"