# Scripts, scripts, scripts! **URL:** \ **Category:** Ask for Help\ **Created:** [November 26, 2020, 6:15pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965 "2020-11-26T18:15:21Z")\ **Posts on this page:** 20\ **Page:** 6
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 17, 2021, 4:49pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/102 "2021-01-17T16:49:40Z")
Gotcha! Thanks for the clarification! šŸ™šŸ» ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 17, 2021, 7:25pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/103 "2021-01-17T19:25:44Z")
This might just unlock something to do with Glide countdown timer. Hmmmm,need to test. Thank you for this. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 17, 2021, 10:23pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/104 "2021-01-17T22:23:03Z")
I got it to work with one Inline list and it works great so thanks again! However, I have multiple Inline Lists that have conditional visibility setup based on time/datesā€¦thus multiple inline list components per tab - my question is how would I add them all to the script so as to process ALL/EACH time/date column, in each Sheet? Sorry - this is somewhat a new arena for meā€¦ ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 17, 2021, 11:19pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/105 "2021-01-17T23:19:49Z")
> [@ehdubya](#): > > However, I have multiple Inline Lists that have conditional visibility setup based on time/datesā€¦thus multiple inline list components per tab - my question is how would I add them all to the script so as to process ALL/EACH time/date column, in each Sheet? Two optionsā€¦ - Option 1: to use it as it is, just call it once for each sheet, giving it the list of column numbers for each - Option 2: modify it so that it will accept an array of sheetnames, then you could just call it once Option 1 would look something like: ``` fix_timestamps('Sheet1', [2,7,11]); fix_timestamps('Sheet2', [1,2]); fix_timestamps('Sheet3', [3]); ... ``` Option 2 is left as an exercise for the reader šŸ˜ ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 17, 2021, 11:22pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/106 "2021-01-17T23:22:53Z")
> [@ehdubya](#): > > However, I have multiple Inline Lists that have conditional visibility setup based on time/datesā€¦thus multiple inline list components per tab - my question is how would I add them all to the script so as to process ALL/EACH time/date column, in each Sheet? hmmā€¦ in theory, this wouldnā€™t affect that at all. As I said earlierā€¦ > [@Darren\_Murphy](#): > > It ignores timezones, and wonā€™t affect what you see in Glide in any way. > The purpose of it is to allow you to apply your desired formatting to date/times within your Google Sheet. The dates & times that you see in Glide (both data editor & UI) shouldnā€™t look any different after using this. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 17, 2021, 11:39pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/107 "2021-01-17T23:39:37Z")
Ok - time to get crackinā€™ then! Thanks again for your help! ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 8:28pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/108 "2021-01-18T20:28:16Z")
@Wiz.Wazeer, be mindful I used to use scripts as timers and I can provide you with some scripts that do this but google sheets only allows up to 6 hrs of scripts per day. If you exceed they just stop all together until the next day. I was running into this problem often. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 18, 2021, 8:41pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/109 "2021-01-18T20:41:01Z")
Thank you @Drearystate . I am not using the timer function for now. The one @Darren_Murphy created doesnā€™t require the timer function and probably because i was under wrong impression that it did. But, if I run into issues I know I have two script masters now to take care of things! ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 8:42pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/110 "2021-01-18T20:42:03Z")
Well itā€™s not necessarily a timer function but any script ran under your name in google sheets. If the script runtimes exceed 6 hours. So timed triggers, onedits, onchange, all of them across all google sheets scripts. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 18, 2021, 8:45pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/111 "2021-01-18T20:45:45Z")
You know what I am thinking ,.we need tutorials from you guys on all the script terminologies like ā€œvarā€ etcā€¦simple scripts no issues but anything beyond that and I am scratching my head and banging it against a wall šŸ¤£ šŸ¤£ ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 8:47pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/112 "2021-01-18T20:47:29Z")
var stands for variable you use it to declare a variable. šŸ˜€ ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 18, 2021, 8:48pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/113 "2021-01-18T20:48:06Z")
Yes but what is a variable in this context? See what I mean and how dumb I am lol ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 8:52pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/114 "2021-01-18T20:52:14Z")
I have something for you sir. I found this yesterday while looking to see if I could help people better with this and it just so happens you caught me before I did a tutorial on it. So now you can almost use Java directly in google scripts with google updating to Chrome V8 JavaScript Engine. Heres the link to explain this below. > **[Write Google Scripts using Modern JavaScript ES6 - Digital Inspiration](https://www.labnol.org/es6-google-apps-script-v8-200206/)** > > Google Apps Script has made the switch to Chrome V8 JavaScript Engine. You can now write your Google Scripts and GSuite addons directly in ES6 but with a few caveats. Now you might ask, ā€œhow does that help me?ā€ Well my good friend Google also created this thing called Blockly. You can use this to put together logic like a puzzle and it will write out the code in Java, Python and a few other languages for you šŸ™‚ That link is here. > **[Blockly Ā |Ā  Google Developers](https://developers.google.com/blockly)** > > A JavaScript library for building visual programming editors. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8d30b3e4e406bcf05d3663010eb2add7fb26df1.png) ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 8:55pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/115 "2021-01-18T20:55:52Z")
The window it brings you to is the window you work in. You do not have to login just delete the hello world commands and your good to go. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 18, 2021, 8:56pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/116 "2021-01-18T20:56:55Z")
Wow thank you for this boss! Iā€™m going to explore . I hate scripts but they are so indispensable. I actually would not need them if only glide could find a way to remove the rowID footprints left behind on clearing of columns. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [January 18, 2021, 8:57pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/117 "2021-01-18T20:57:25Z")
Wow looks promising ! ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 8:58pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/118 "2021-01-18T20:58:59Z")
I fiddled with it yesterday but have yet to write an entire program (complex program) in it. I think in the next few weeks I will write a full blown program using their logic and seeing how well it interprets into scripts. There will have to be some changes made on occasion but it can also teach you how java or python or even php is structured and works. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 18, 2021, 9:02pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/119 "2021-01-18T21:02:27Z")
I do honestly beleive that visual scripting in this manner will replace the majority of coding requirements. They are building these for the majority of software languages. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 18, 2021, 9:15pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/120 "2021-01-18T21:15:47Z")
We use ā€œDocument Studioā€ (Digital Inspiration product) for creating custom, printable PDF invoices for clients, among other things. This is great resource! Thanks! \*Edit: Also a good tool for creating personalized print materials. šŸ‘šŸ» ---
**Author:** ![ThatGuyInArizona](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thatguyinarizona/32/12472_2.png) [@ThatGuyInArizona](https://community.glideapps.com/u/ThatGuyInArizona)\ **Post date:** [January 18, 2021, 9:18pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/121 "2021-01-18T21:18:20Z")
> [@Drearystate](#): > > Blockly | Google Developers This is fabulous ! thank you for sharing this one. [Previous page](https://community.glideapps.com/t/scripts-scripts-scripts/18965.md?page=5) [Next page](https://community.glideapps.com/t/scripts-scripts-scripts/18965.md?page=7)