# 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:** 12
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [July 23, 2021, 3:34pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/223 "2021-07-23T15:34:31Z")
same for me 😉 if i can i recommend using a function test\_fix … and doing a run on that function. Otherwise the editor will execute the fix\_timestamps procedure twice, including once with undefined parameters, therefore with errors to be expected. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/8613317b5fa5caf5cae072c2d2c7ea9212950314.png) Here is an example : ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 23, 2021, 3:39pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/224 "2021-07-23T15:39:28Z")
Hola gente!!! Does anybody have a script that deletes rows that meet a condition from a workbook, then add them to another one? @Darren_Murphy @Manu.n @gvalero @ThinhDinh Thanks guys! ---
**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:** [July 23, 2021, 3:47pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/225 "2021-07-23T15:47:20Z")
Yes, I have several. But I’d bet lots of money that none of them would be any use to you 😝 I can help you write what you need though. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 23, 2021, 3:50pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/226 "2021-07-23T15:50:07Z")
That’s will be pretty much 5 lines of code 😉 ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [July 23, 2021, 3:51pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/227 "2021-07-23T15:51:35Z")
That is a great idea. Let’s do it. ---
**Author:** ![Rosha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosha/32/26447_2.png) [@Rosha](https://community.glideapps.com/u/Rosha)\ **Post date:** [July 23, 2021, 3:53pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/228 "2021-07-23T15:53:03Z")
Okay, I’ve got the go ahead. I’ll send it to you in a private message. ---
**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:** [July 23, 2021, 3:54pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/229 "2021-07-23T15:54:06Z")
Not necessary - @ThinhDinh already spotted the error… > [@ThinhDinh](#): > > Maybe try getActiveSpreadsheet (not SpreadSheet) to see if the capitalized character is the problem. ---
**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:** [August 20, 2021, 3:58pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/230 "2021-08-20T15:58:12Z")
It’s good to see my threads are active long after I’ve gone 🙂 ---
**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:** [August 20, 2021, 4:00pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/231 "2021-08-20T16:00:45Z")
who are you? 😛 ---
**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:** [August 20, 2021, 4:02pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/232 "2021-08-20T16:02:35Z")
lol, i wandering soul sir ---
**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:** [August 20, 2021, 4:03pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/233 "2021-08-20T16:03:16Z")
I keep get notifications about 3 or 4 of my threads so I figured I would see what’s going on. I’ve been using [nullkode.io](http://nullkode.io) and adalo so much I don’t really build with glide anymore. I still have some proapps here but I will eventually move them over to [nullkode.io](http://nullkode.io) ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [September 5, 2021, 11:58am UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/234 "2021-09-05T11:58:26Z")
> [@Drearystate](#): > > [nullkode.io](http://nullkode.io) If so, is it possible to have alarm and push functions in [nullkode.io](http://nullkode.io)? ---
**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:** [September 6, 2021, 12:28am UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/235 "2021-09-06T00:28:38Z")
Yes ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [September 6, 2021, 5:52am UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/236 "2021-09-06T05:52:59Z")
I believe in a simple answer. And I looked. It looks like it was made recently. Glide also works with Google Spread, but Nullkode does not yet know what data interlocking is. It seems like no coding, but it feels like coding input. Is that right? ---
**Author:** ![adiboo\_adib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adiboo_adib/32/24714_2.png) [@adiboo\_adib](https://community.glideapps.com/u/adiboo_adib)\ **Post date:** [November 8, 2021, 12:57pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/237 "2021-11-08T12:57:45Z")
Hi the code work great , can you tell me if it possible to delete all row on source sheet after moving the data? thanks ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [November 8, 2021, 1:06pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/238 "2021-11-08T13:06:04Z")
I use this script now to move the values. It’s orders of magnitude faster… RE: deleting the values once moved, I could share another script later. > [@Scripts, scripts, scripts!](https://community.glideapps.com/t/scripts-scripts-scripts/18965/92): > > Hello good sir, I found myself in a similar situation and with the help of @Darren_Murphy we came up with this script. It will copy the values only from a source sheet to a target sheet while skipping the ones you don’t want to copy yet. Hopefully this could point you in the right direction. With a little tweaking it could delete the values from the source sheet that have already been processed. Then it would satisfy both your needs in one execution. > > > **Summary** > > > > function copy\_new\_rows\_to\_database… ---
**Author:** ![adiboo\_adib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adiboo_adib/32/24714_2.png) [@adiboo\_adib](https://community.glideapps.com/u/adiboo_adib)\ **Post date:** [November 8, 2021, 1:19pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/239 "2021-11-08T13:19:07Z")
Ok thanks i’m waiting the code for removing data after moving. ---
**Author:** ![adiboo\_adib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adiboo_adib/32/24714_2.png) [@adiboo\_adib](https://community.glideapps.com/u/adiboo_adib)\ **Post date:** [November 9, 2021, 7:49pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/240 "2021-11-09T19:49:12Z")
Hi any news for code delting range after copy ? Thanks ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [November 19, 2021, 1:24pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/241 "2021-11-19T13:24:41Z")
I think this script from @Uzo could help you. > [@Replace Add Rows by Set Columns to trace user clicks. Your Best Practices pls for the least nb of rows](https://community.glideapps.com/t/replace-add-rows-by-set-columns-to-trace-user-clicks-your-best-practices-pls-for-the-least-nb-of-rows/34460/17): > > I gave you a link to my script, just copy it and paste it onto the script editor in google sheets… don’t forget to add on change trigger by clicking the clock icon or in the old version … edit tab… current projects triggers ---
**Author:** ![Yevhen\_Lopukhin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yevhen_lopukhin/32/1410_2.png) [@Yevhen\_Lopukhin](https://community.glideapps.com/u/Yevhen_Lopukhin)\ **Post date:** [November 22, 2021, 6:48am UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/242 "2021-11-22T06:48:46Z")
Никак. Или храните все значения, которые ввел пользователь, или скрипт, который их куда-то девает, типа копирует в другое место, либо просто обнуляет. При введении пользователем значений всегда можно цеплять кто ввел и когда, и потом сортировать по дате и пользователю. [Previous page](https://community.glideapps.com/t/scripts-scripts-scripts/18965.md?page=11) [Next page](https://community.glideapps.com/t/scripts-scripts-scripts/18965.md?page=13)