Scripts, scripts, scripts!

[Manu.n]

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.

Here is an example :

[SantiagoPerez]

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!

[Darren_Murphy]

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.

[Uzo]

That’s will be pretty much 5 lines of code

[SantiagoPerez]

That is a great idea. Let’s do it.

[Rosha]

Okay, I’ve got the go ahead. I’ll send it to you in a private message.

[Darren_Murphy]

Not necessary - @ThinhDinh already spotted the error…

@ThinhDinh

Maybe try getActiveSpreadsheet (not SpreadSheet) to see if the capitalized character is the problem.

[Drearystate]

It’s good to see my threads are active long after I’ve gone

[Darren_Murphy]

who are you?

[Drearystate]

lol, i wandering soul sir

[Drearystate]

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 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

[_ffwpu]

@Drearystate

nullkode.io

If so, is it possible to have alarm and push functions in nullkode.io?

[Drearystate]

Yes

[_ffwpu]

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?

[adiboo_adib]

Hi
the code work great , can you tell me if it possible to delete all row on source sheet after moving the data?

thanks

[Eric_Penn]

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!

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…

[adiboo_adib]

Ok thanks i’m waiting the code for removing data after moving.

[adiboo_adib]

Hi any news for code delting range after copy ? Thanks

[Eric_Penn]

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

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

[Yevhen_Lopukhin]

Никак. Или храните все значения, которые ввел пользователь, или скрипт, который их куда-то девает, типа копирует в другое место, либо просто обнуляет. При введении пользователем значений всегда можно цеплять кто ввел и когда, и потом сортировать по дате и пользователю.