Google Spreadsheets: How to html publish pages based on current day Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar Manara Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!How to tell if a DOM element is visible in the current viewport?How do I modify the URL without reloading the page?How do I get the current date in JavaScript?How to create an HTML button that acts like a link?Get the size of the screen, current web page and browser windowHow can I set the default value for an HTML <select> element?How can I refresh a page with jQuery?Redirect from an HTML pageHow do I reformat HTML code using Sublime Text 2?Pure JavaScript equivalent of jQuery's $.ready() - how to call a function when the page/DOM is ready for it
What is a 'Key' in computer science?
Check if a string is entirely made of the same substring
Arriving in Atlanta after US Preclearance in Dublin. Will I go through TSA security in Atlanta to transfer to a connecting flight?
Split coins into combinations of different denominations
Why is this method for solving linear equations systems using determinants works?
Visa-free travel to the US using refugee travel document from Spain?
Do I need to protect SFP ports and optics from dust/contaminants? If so, how?
How to get even lighting when using flash for group photos near wall?
Is a 5 watt UHF/VHF handheld considered QRP?
"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?
Co-worker works way more than he should
Are these square matrices always diagonalisable?
How can I wire a 9-position switch so that each position turns on one more LED than the one before?
"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?
How to keep bees out of canned beverages?
Protagonist's race is hidden - should I reveal it?
Book with legacy programming code on a space ship that the main character hacks to escape
Additive group of local rings
Is accepting an invalid credit card number a security issue?
How do I check if a string is entirely made of the same substring?
A strange hotel
Is it acceptable to use working hours to read general interest books?
What's the difference between using dependency injection with a container and using a service locator?
Trumpet valves, lengths, and pitch
Google Spreadsheets: How to html publish pages based on current day
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar Manara
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!How to tell if a DOM element is visible in the current viewport?How do I modify the URL without reloading the page?How do I get the current date in JavaScript?How to create an HTML button that acts like a link?Get the size of the screen, current web page and browser windowHow can I set the default value for an HTML <select> element?How can I refresh a page with jQuery?Redirect from an HTML pageHow do I reformat HTML code using Sublime Text 2?Pure JavaScript equivalent of jQuery's $.ready() - how to call a function when the page/DOM is ready for it
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
intro : I'm using a published google spreadsheet with a day schedule, each day is on a page.
Currently I'm just embedding the sheet with html/css in a webpage, this webpage is being reloaded every half hour so the sheet is pulled again and newly added data is shown.
Problem 1: Every time the page reloads the embedded sheet shows the first page. And it because very annoying for the staff that looks at that sheet.
Question :Isn't it possible to link the day in the page to the current day of the month?
Motivation question : I've been looking and trying with timers and manually adding all the sheet pages links into the code, but thats a lot of waste time every month, when my boss duplicates the sheet and alters everything for that current month.
So every month the pages in the sheets get new links.
I'm searching for somebody that has tackled this issue in de past and succeeded or didn't succeed and can give me alternative ways of solving this (like awesome table?)
javascript html google-sheets
asked Mar 22 at 15:53
SauvageSauvage
276
add a comment |
intro : I'm using a published google spreadsheet with a day schedule, each day is on a page.
Currently I'm just embedding the sheet with html/css in a webpage, this webpage is being reloaded every half hour so the sheet is pulled again and newly added data is shown.
Problem 1: Every time the page reloads the embedded sheet shows the first page. And it because very annoying for the staff that looks at that sheet.
Question :Isn't it possible to link the day in the page to the current day of the month?
Motivation question : I've been looking and trying with timers and manually adding all the sheet pages links into the code, but thats a lot of waste time every month, when my boss duplicates the sheet and alters everything for that current month.
So every month the pages in the sheets get new links.
I'm searching for somebody that has tackled this issue in de past and succeeded or didn't succeed and can give me alternative ways of solving this (like awesome table?)
javascript html google-sheets
asked Mar 22 at 15:53
SauvageSauvage
276
add a comment |
intro : I'm using a published google spreadsheet with a day schedule, each day is on a page.
Currently I'm just embedding the sheet with html/css in a webpage, this webpage is being reloaded every half hour so the sheet is pulled again and newly added data is shown.
Problem 1: Every time the page reloads the embedded sheet shows the first page. And it because very annoying for the staff that looks at that sheet.
Question :Isn't it possible to link the day in the page to the current day of the month?
Motivation question : I've been looking and trying with timers and manually adding all the sheet pages links into the code, but thats a lot of waste time every month, when my boss duplicates the sheet and alters everything for that current month.
So every month the pages in the sheets get new links.
I'm searching for somebody that has tackled this issue in de past and succeeded or didn't succeed and can give me alternative ways of solving this (like awesome table?)
javascript html google-sheets
asked Mar 22 at 15:53
SauvageSauvage
276
intro : I'm using a published google spreadsheet with a day schedule, each day is on a page.
Currently I'm just embedding the sheet with html/css in a webpage, this webpage is being reloaded every half hour so the sheet is pulled again and newly added data is shown.
Problem 1: Every time the page reloads the embedded sheet shows the first page. And it because very annoying for the staff that looks at that sheet.
Question :Isn't it possible to link the day in the page to the current day of the month?
Motivation question : I've been looking and trying with timers and manually adding all the sheet pages links into the code, but thats a lot of waste time every month, when my boss duplicates the sheet and alters everything for that current month.
So every month the pages in the sheets get new links.
I'm searching for somebody that has tackled this issue in de past and succeeded or didn't succeed and can give me alternative ways of solving this (like awesome table?)
javascript html google-sheets
javascript html google-sheets
asked Mar 22 at 15:53
SauvageSauvage
276
asked Mar 22 at 15:53
SauvageSauvage
276
asked Mar 22 at 15:53
SauvageSauvage
276
asked Mar 22 at 15:53
SauvageSauvage
276
asked Mar 22 at 15:53
SauvageSauvage
276
276
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
If you have editing (and file-restructuring-decision-making) privileges for the Sheets file itself, perhaps consider making a new first sheet, named something like "Today", which uses a formula to automatically always just show today's schedule, which in turn still just lives where it always has. The published page will accordingly then just show today's schedule, since it's the first sheet.
Say your Sheets file's "tabs" for each day are just named the number of the day, so: "23", or "24", or "25"… A formula in the "Today" sheet might pull in the day's schedule with something like this:=INDIRECT(DAY(TODAY())&"!A1:Z")
In English, from the inside out, that formula means: take TODAY's date and time, extract just the DAY number of it, put that day as text next to the hard-coded text !A1:Z, and now that we're done assembling it, use that text instead as an INDIRECT reference to the actual cells we want shown here.
Demo sheet here. Note that the demo only works on the 23rd - 25th of a given month because those are the only day schedule sheets I created. You can find the above formula in sheet Today, cell A2. If your file's other Sheets are named something different, edit your question and we can assist with a formula to suit.
An important note if you choose an approach like this. The result of the formula is to display the other day's schedule in however-many cells it takes, starting where the formula is entered. The data then shown cannot be edited in place, and if data is entered say… next to the schedule, it will not be reflected back on the actual sheet for that day.
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55303425%2fgoogle-spreadsheets-how-to-html-publish-pages-based-on-current-day%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you have editing (and file-restructuring-decision-making) privileges for the Sheets file itself, perhaps consider making a new first sheet, named something like "Today", which uses a formula to automatically always just show today's schedule, which in turn still just lives where it always has. The published page will accordingly then just show today's schedule, since it's the first sheet.
Say your Sheets file's "tabs" for each day are just named the number of the day, so: "23", or "24", or "25"… A formula in the "Today" sheet might pull in the day's schedule with something like this:=INDIRECT(DAY(TODAY())&"!A1:Z")
In English, from the inside out, that formula means: take TODAY's date and time, extract just the DAY number of it, put that day as text next to the hard-coded text !A1:Z, and now that we're done assembling it, use that text instead as an INDIRECT reference to the actual cells we want shown here.
Demo sheet here. Note that the demo only works on the 23rd - 25th of a given month because those are the only day schedule sheets I created. You can find the above formula in sheet Today, cell A2. If your file's other Sheets are named something different, edit your question and we can assist with a formula to suit.
An important note if you choose an approach like this. The result of the formula is to display the other day's schedule in however-many cells it takes, starting where the formula is entered. The data then shown cannot be edited in place, and if data is entered say… next to the schedule, it will not be reflected back on the actual sheet for that day.
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
add a comment |
If you have editing (and file-restructuring-decision-making) privileges for the Sheets file itself, perhaps consider making a new first sheet, named something like "Today", which uses a formula to automatically always just show today's schedule, which in turn still just lives where it always has. The published page will accordingly then just show today's schedule, since it's the first sheet.
Say your Sheets file's "tabs" for each day are just named the number of the day, so: "23", or "24", or "25"… A formula in the "Today" sheet might pull in the day's schedule with something like this:=INDIRECT(DAY(TODAY())&"!A1:Z")
In English, from the inside out, that formula means: take TODAY's date and time, extract just the DAY number of it, put that day as text next to the hard-coded text !A1:Z, and now that we're done assembling it, use that text instead as an INDIRECT reference to the actual cells we want shown here.
Demo sheet here. Note that the demo only works on the 23rd - 25th of a given month because those are the only day schedule sheets I created. You can find the above formula in sheet Today, cell A2. If your file's other Sheets are named something different, edit your question and we can assist with a formula to suit.
An important note if you choose an approach like this. The result of the formula is to display the other day's schedule in however-many cells it takes, starting where the formula is entered. The data then shown cannot be edited in place, and if data is entered say… next to the schedule, it will not be reflected back on the actual sheet for that day.
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
add a comment |
If you have editing (and file-restructuring-decision-making) privileges for the Sheets file itself, perhaps consider making a new first sheet, named something like "Today", which uses a formula to automatically always just show today's schedule, which in turn still just lives where it always has. The published page will accordingly then just show today's schedule, since it's the first sheet.
Say your Sheets file's "tabs" for each day are just named the number of the day, so: "23", or "24", or "25"… A formula in the "Today" sheet might pull in the day's schedule with something like this:=INDIRECT(DAY(TODAY())&"!A1:Z")
In English, from the inside out, that formula means: take TODAY's date and time, extract just the DAY number of it, put that day as text next to the hard-coded text !A1:Z, and now that we're done assembling it, use that text instead as an INDIRECT reference to the actual cells we want shown here.
Demo sheet here. Note that the demo only works on the 23rd - 25th of a given month because those are the only day schedule sheets I created. You can find the above formula in sheet Today, cell A2. If your file's other Sheets are named something different, edit your question and we can assist with a formula to suit.
An important note if you choose an approach like this. The result of the formula is to display the other day's schedule in however-many cells it takes, starting where the formula is entered. The data then shown cannot be edited in place, and if data is entered say… next to the schedule, it will not be reflected back on the actual sheet for that day.
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
If you have editing (and file-restructuring-decision-making) privileges for the Sheets file itself, perhaps consider making a new first sheet, named something like "Today", which uses a formula to automatically always just show today's schedule, which in turn still just lives where it always has. The published page will accordingly then just show today's schedule, since it's the first sheet.
Say your Sheets file's "tabs" for each day are just named the number of the day, so: "23", or "24", or "25"… A formula in the "Today" sheet might pull in the day's schedule with something like this:=INDIRECT(DAY(TODAY())&"!A1:Z")
In English, from the inside out, that formula means: take TODAY's date and time, extract just the DAY number of it, put that day as text next to the hard-coded text !A1:Z, and now that we're done assembling it, use that text instead as an INDIRECT reference to the actual cells we want shown here.
Demo sheet here. Note that the demo only works on the 23rd - 25th of a given month because those are the only day schedule sheets I created. You can find the above formula in sheet Today, cell A2. If your file's other Sheets are named something different, edit your question and we can assist with a formula to suit.
An important note if you choose an approach like this. The result of the formula is to display the other day's schedule in however-many cells it takes, starting where the formula is entered. The data then shown cannot be edited in place, and if data is entered say… next to the schedule, it will not be reflected back on the actual sheet for that day.
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
answered Mar 23 at 14:31
Joel ReidJoel Reid
6351510
6351510
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
add a comment |
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
Thanks! That worked for me!
– Sauvage
Mar 28 at 11:12
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55303425%2fgoogle-spreadsheets-how-to-html-publish-pages-based-on-current-day%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
