Small Google Sheets Script to be written for finding and clearing rows
2014
£25(approx. $31)
- Posted:
- Proposals: 3
- Remote
- #2157704
- Archived
Description
Experience Level: Entry
I have a Google Sheet that I require a small piece of Script to be written for to enable a simple find and delete button click.
Below is the link to the spreadsheet, of which I've added comments to for clarity.
https://docs.google.com/spreadsheets/d/1e62srgwWtK1W0N5Rqt3Ko6cyqFtcqaUZHd_KQIUTKQ8/edit?usp=sharing
This is the process:
1) User types in the Order Id and Date they are searching for
2) A query pulls through any associated rows matching that criteria
3) User reviews which rows of data they want removed and places a 'Y' into column I (Adjuster sheet)
4) Once user has selected all rows they want removed they click the 'Delete' image button.
5) YOUR SCRIPT then finds all those rows indicated in the BookingData sheet and clears/deletes them.
On the spreadsheet you'll see that I have already added some dummy data so you can see what it is that I am looking for.
When you write the script please ensure you use good comments so that later on if I need to add more functions (such as update certain fields, etc.) that I or another person has a good place to start from.
This should be a 20 minute job for someone a little more familiar with Google Script.
Below is the link to the spreadsheet, of which I've added comments to for clarity.
https://docs.google.com/spreadsheets/d/1e62srgwWtK1W0N5Rqt3Ko6cyqFtcqaUZHd_KQIUTKQ8/edit?usp=sharing
This is the process:
1) User types in the Order Id and Date they are searching for
2) A query pulls through any associated rows matching that criteria
3) User reviews which rows of data they want removed and places a 'Y' into column I (Adjuster sheet)
4) Once user has selected all rows they want removed they click the 'Delete' image button.
5) YOUR SCRIPT then finds all those rows indicated in the BookingData sheet and clears/deletes them.
On the spreadsheet you'll see that I have already added some dummy data so you can see what it is that I am looking for.
When you write the script please ensure you use good comments so that later on if I need to add more functions (such as update certain fields, etc.) that I or another person has a good place to start from.
This should be a 20 minute job for someone a little more familiar with Google Script.
Jamie M.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
29%
Last project
13 Jan 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies