Move rows on 2 sheets older than 24 hours to archive

I have been trying to figure this one out for a while now and would really appreciate some assistance.

I have a Google Sheet that is being updated by a Google Form. Due to this I needed to mirror the data onto another tab to be able to format it. Unfortunately, this makes this auto-archiving process a bit more tricky.

demo

The information comes in on the ‘request form’-tab, and then with a Query is shown on to the ‘Today’-tab. Both these sheets have red columns which will be hidden from the users with times to assist with the conditional formatting. What I would like to happen is that when a request is more than 24 hours old it copies to a new line on the ‘archive’-tab and then remove the line from both the ‘request form’ and ‘today’-tab.

I am not a programmer by any means and usually get snippets of code and manipulate them and put them together and that usually seems to work, but this one is beyond my copy+paste skills. 😉

The below code seems to work, but what needs to be added is the removal of the same line on the ‘Today’-tab.

function onOpen() { SpreadsheetApp.getUi()     .createMenu('EDITION')     .addItem('Archive', 'archiveRows')     .addToUi(); }  function archiveRows() { var ss = SpreadsheetApp.getActive(); var s = ss.getSheetByName("Request Form"); var target = ss.getSheetByName("Archive");      s.getRange("J:J").setNumberFormat('dd MM yyyy hh:mm:ss');  var today = new Date().getTime() var val = filterArray(s.getDataRange()     .getValues()); for (var len = val.length - 1, i = len; i >= 0; i--) {     if (val[i][9].getTime() < today) {         target.appendRow(val[i])         s.deleteRow(i + 2)         }     } }  function filterArray(array) { var filteredArray = []; array.forEach(function (r) {     if (r[8] !== '') {         filteredArray.push(r);     } }); return filteredArray; } 

draw your picture as cartoonist with in 24 hours for $5

I will draw your image as animation picture for any event. benefits you will get: 100% quality work 100% high goals Full animation representation in just $ 5 Full Body representation. I will make any image as visual artist Much thanks, anticipating got notification from you and draw your animation picture. High Quality Professional Service For My Clients

by: Malave
Created: —
Category: Art & Design
Viewed: 115


500 Directory submissions in just 5 hours for $5

Hi, I am Sagar Dinesh s. I am SEO expert. I have 1 year experience. I will improve link quality of your website by HIGH PR Directory submission. Great service from smart seo done only with MANUAL work. After work done I will send you complete excel-sheet report with screenshots and submitted link.

by: REALSAGA
Created: —
Category: Directory Submission
Viewed: 196


1000 directory submission within 48 hours for $10

Directory submission is very important in SEO. It is very essential for business or website. Any directory can be a treasure trove for your business or website providing you with high converting traffic. I will do submission for your business or site to the most popular directory. Once the work is done I will send you the complete report with screenshots of the submitted links. BENEFITS OF MY SERVICE 100% Real and active link 100% Satisfaction guarantee Get more traffic or customers Increase your search engine visibility Boosts your site ranking in search engine

by: ameenzada
Created: —
Category: Directory Submission
Viewed: 189


Guest Post On Tech Blog With Dofollow Backlink In 24 Hours for $100

Best guest posting service with Keepthetech Guest Post SEO and High Authority top guest posting sites With Permanent Dofollow Backlinks. Post INDEXED in google Guaranteed! Just send me a unique piece of content (700+ Words) and I will be publishing it within 24 Hours. What’s included in the gig? Article publishing with a permanent DoFollow backlink. The post will be listed on the homepage of our site for a limited time until new posts are published by our authors.You will get a trusted link from High Authority Sites. Website Stats [Keepthetech.Com] DA : 24 PA : 33 Alexa Rank : 55K Monthly Traffic : 71,000 Unique Visitors/Month

by: MritunjayJadon
Created: —
Category: Guest Posts
Viewed: 149


Are Luton Airport to London National Express transfer hours fixed according to my reservation?

Next week we’ll arrive in Luton by plane and need to get to London (somewhere in Brent).

We’d like to take the bus (since it is the cheapest as far as I can tell) from Luton to London (either Golders Green station or Finchley Road & Frognal) in order to get to our accommodation.

The problem is that when I try to make the reservation, there are concrete departure times noted in the summary. Will we be able to board a later bus if the landing in Luton is delayed? Will we be able to board an earlier bus (for the return trip) if we feel traffic is going to be a problem?

If the answer is no, then I saw that one can purchase tickets on the spot in the airport. Will they be more expensive? Where can I purchase them “on the spot” for the return trip, the driver, ticket machines in Golders Green/Finchley Road station)?

Later edit: Forgot to ask about Green Line, their tickets seem a bit more expensive, but do not have set departure times. What is inconvenient here is that the only timetable I found was a hot mess. Is there a Green Line bus every 30 minutes?

enter image description here

1000 directory submission with in 24 hours for $8

Directory submission is very important in SEO. It is very essential for business or website.any directory can be a treasure trove for your business or website providing you with high converting traffic. I will do manual submission for your business or site to most popular directory.you can also send me your preferred directory list or I will research list related to your website. After work done I will send you complete report with screenshots and submitted link. BENEFITS OF MY SERVICE 100% Real and active link 100% Satisfaction guarantee Get more traffic or costumers Increase your search engine visibility Boosts your site ranking in search engine

by: IGenGraphicsHub
Created: —
Category: Directory Submission
Viewed: 275


1000 Unique Directory Submission within 24 hours for $10

Directory submissions are extremely vital in SEO. It’s nearly very impossible to get approval in some directories. Few directories can take up to few months or years to list our website. All submissions will be done manually and after the work completion, i will provide you with the submitted link and screenshot of the report. Advantages are : I can complete the work in lesser time.I am 100% Genuine.I am fully dedicated to my work.

by: 5001
Created: —
Category: Directory Submission
Viewed: 245