"Automatically cut row range to another tab and delete, based off of data validation."

[Ryan Weaver]

I am working on my stock sheet for our company. What I would like to do is when a range in the MO# column is invalid on the data validation (has the red corner) I want that selection which would be the column A-H to be copy and pasted into the past checkouts tab at the bottom of the list, then then those empty cells to be deleted and shifted up, automatically. I do not even know if appscript can detect data invalidation, if it can't is there an other way around it?

https://docs.google.com/spreadsheets/d/1dUJvyH2PuXdIyMQ8clfhRITDN_x5khYs5RynJ2z9s2k/edit?usp=sharing

[Nikola Grujičić]

How often do you need this kind of a cleaning to be done? 

Maybe the time trigger (set for once a day execution) 

with validation done by the script itself (if you are not sure the script will catch non valid fields) 

and appropriate transfer of data from one tab into another 

can do the job...

On Thu, Sep 29, 2022 at 4:07 PM Ryan Weaver <weaver...@gmail.com> wrote:

I am working on my stock sheet for our company. What I would like to do is when a range in the MO# column is invalid on the data validation (has the red corner) I want that selection which would be the column A-H to be copy and pasted into the past checkouts tab at the bottom of the list, then then those empty cells to be deleted and shifted up, automatically. I do not even know if appscript can detect data invalidation, if it can't is there an other way around it?

https://docs.google.com/spreadsheets/d/1dUJvyH2PuXdIyMQ8clfhRITDN_x5khYs5RynJ2z9s2k/edit?usp=sharing

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/da5e146f-89e7-4693-989f-10f90b68997dn%40googlegroups.com.

[Keith Andersen]

Ryan,

Yes, it can be done. I will work on this this afternoon hopefully get back to you by tomorrow. 

Cheers,

Keith

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CALt-yJ5NnNAM7TmgHQL%3DQD7Ho%2B-%2Bb0ZYm2oWNS%2BAvFUPxGFBJQ%40mail.gmail.com.

[Dhanvir Singh]

Check The link for a solution. Does it work for you?

https://docs.google.com/spreadsheets/d/1GqPOIn8gyvqpBgXFc0uB1KQzX2_XvrovsIg6KzGOukI/edit?usp=sharing

On Thu, Sep 29, 2022 at 7:37 PM Ryan Weaver <weaver...@gmail.com> wrote:

I am working on my stock sheet for our company. What I would like to do is when a range in the MO# column is invalid on the data validation (has the red corner) I want that selection which would be the column A-H to be copy and pasted into the past checkouts tab at the bottom of the list, then then those empty cells to be deleted and shifted up, automatically. I do not even know if appscript can detect data invalidation, if it can't is there an other way around it?

https://docs.google.com/spreadsheets/d/1dUJvyH2PuXdIyMQ8clfhRITDN_x5khYs5RynJ2z9s2k/edit?usp=sharing

--

[Ryan Weaver]

I cannot tell without editor access can you please add me on it.

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/evyqEk_9WSY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CANNd6G85gx4OzShHbwrZZm5m12NBKp5NFWp9dfC0nM1wsY_VrQ%40mail.gmail.com.

--

Thank you,

Ryan Weaver

American Flooring Dewitt

13151 Schavey Rd 

517-246-0450

[Dhanvir Singh]

now Check

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABf%3D8RG79BcZagexKmhNBrfCkn5vSgZByrVJRMGeycOMhK5Mqg%40mail.gmail.com.

[Ryan Weaver]

Is the trigger time based?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CANNd6G-j8Cqz_WjcgtTJzoRxzKzaAXHF9m8mgABLborKRuizAw%40mail.gmail.com.

[Keith Andersen]

Ryan,

Been experimenting with this for a few days now. Yes- it is technically it is possible as I stated before but unfortunately the delete-cells and move data upward is server intensive. I wind up having to put a pause on the script at the beginning of the loop of 3 seconds in order for it to both remove the data after it copies the data in that row to an array. 

That being said... I'm searching for a better solution.

Keith

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABf%3D8RFpnvas5wArhf2n4J3z7xZXgDavo%2BrEKOZi9aA7JCHQjw%40mail.gmail.com.

[Ryan Weaver]

Thank you so much it could be time triggered instead like daily if that is better.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4zYzzv%2BuTg0c1Cx6W6FyHb-fp_UYUEOoJ%3DDx1cU%3DRwjjA%40mail.gmail.com.

[Keith Andersen]

Time trigger won't help it's the overall process of looping through and removing with the specificity of only taking the data and then moving the rows upward.

I'm going to try just deleting the entire row. That would mean that you would have to add one more sheet as a helper sheet with your drop-down validation and or other lists on that page.

I will work on that today and let you know.

Keith 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABf%3D8RGvMEZSpyoxeMA7BoLc_9CoekX02ZvNqnGFYhCHxvCUGw%40mail.gmail.com.

[Ryan Weaver]

That would not be a problem.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4zyKQaMAPbpr4Y95ueJHq_wj5wk4reWg46TvbmnBO_HJg%40mail.gmail.com.

[Dhanvir Singh]

it's just a formula based not have any trigger...

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABf%3D8RFpnvas5wArhf2n4J3z7xZXgDavo%2BrEKOZi9aA7JCHQjw%40mail.gmail.com.

[Dhanvir Singh]

its update automatically when any new entry entered

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABf%3D8RFpnvas5wArhf2n4J3z7xZXgDavo%2BrEKOZi9aA7JCHQjw%40mail.gmail.com.