Write AppScript for Google Sheets
There is a sheet of applications for the transportation of goods (hereinafter - Applications).
It is necessary to organize the following functionality:
1. On the Applications sheet, implement 2 actions: “Create batch” and “Add to batch”:
1.1. When the “Create batch” button is pressed, the selected rows checked by the checkbox are moved to the next sheet (hereinafter - Batches) and a separate header is added to the list of these rows, while in the current sheet the row is highlighted in color and the checkbox is removed.
1.2. When the “Add to batch” button is pressed, the selected rows checked by the checkbox are prompted to select an already existing batch and are added to it, while in the current sheet the row is highlighted in color and the checkbox is removed.
2. On the “Batches” sheet, implement 3 actions: “Remove from batch”, “Send to manager” and “Confirm readiness”
2.1. When the “Remove from batch” button is pressed, the selected rows checked by the checkbox are removed from the current Batches sheet, and on the previous Applications sheet, the corresponding row loses its color and the checkbox appears.
2.2. When the “Send to manager” button is pressed, the selected batches checked by the checkbox are copied to a Google document template, this document is saved on the disk and sent to the corresponding email address (the dependency of the email address on the direction is indicated on a separate sheet), while the batch is highlighted in color and assigned the status “Packing”.
2.3. When the “Confirm readiness” button is pressed, the selected Batches checked by the checkbox (only certain columns and already without additional rows) are copied to the next sheet (hereinafter - Flights) and prompted to select a carrier from a dropdown list, while in the current sheet the row is highlighted in color, assigned the status “Ready for shipment”, the application moves down under “Unready batches” and the checkbox is removed.
3. On the “Flights” sheet, implement 2 actions: “Add carrier” and “Monitor”
3.1. When the “Add carrier” button is pressed (preferably, it should be implemented in all rows of flights), a row is added below the selected flight checked by the checkbox with the option to choose a second carrier from the list.
3.2. When the “Monitor” button is pressed, the row is copied to another table, highlighted in color and moves down under “Active flights” and the checkbox is removed.
Client's review of cooperation with Tetyana Shumeyko
Write AppScript for Google SheetsTetiana approached the project responsibly.
Everything is in accordance with the agreed terms (specifications and deadlines).
The code is of high quality!
Freelancer's review of cooperation with Artem Lopatin
Write AppScript for Google SheetsThank you for the collaboration! Clearly defined task, quick review and payment! I recommend the client!
-
536 9 0 Good day, I am interested in your order, we will discuss the details in private messages. Here is my portfolio:
Google Drive
10 $/ hour
-
3012 73 4 2 Good day! I have a lot of experience working with ET, especially with Google Sheets, so I will write the script quickly, and most importantly - with quality!!! Feel free to reach out!!
-
551 33 0 Good afternoon, can it be done on node.js or desktop (electron.js)
-
358 Hello! Do you want this system to be developed within Google Sheets, or are you open to other platforms?
I will be able to determine the timeline and budget more accurately after a personal conversation.
I plan to execute your project as follows:
1. First, I will develop the logic for the "Applications" sheet, including the "Create Batch" and "Add to Batch" buttons that you described.
2. Then, I will move on to the "Batches" sheet and implement the necessary buttons and functions ("Remove from Batch," "Send to Manager," "Confirm Readiness").
3. Finally, I will create the "Flights" sheet with the required buttons ("Add Carrier," "Monitor").
…
Thank you for considering my proposal. I am looking forward to the opportunity to work with you!
-
957 19 0 Good day.
I have completed similar projects. I understand the logic of data transfer. Questions may arise during the project execution.
If you are interested, I am ready to complete a test task. Write to me.
-
93973 1266 1 10 Hello. I have extensive experience with JavaScript. I am ready for collaboration.
-
421 13 0 Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
631 5 0 Good afternoon
I can complete the task
--------------------------
Current freelance projects in the category Javascript and Typescript
Consultation and audit of the current project on Odoo 19 Community EditionWe are looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition, including using Claude Code. We need a specialist who has successfully implemented projects in Odoo and practical experience in development using Claude Code. Important: we only… C & C++, Javascript and Typescript ∙ 27 minutes back ∙ 2 proposals |
Online clothing storeNeed a developer for an online clothing store Looking for an experienced developer to create a full-fledged online clothing store with a drop model of sales. What needs to be done: 6 pages: home, product, cart, checkout, account, admin panel Login via Google account Cart and… HTML & CSS, Javascript and Typescript ∙ 1 day 21 hours back ∙ 85 proposals |
Full-stack development — Amazon PPC Dashboard (Stage 1)Need a full-stack developer with experience working with Amazon API to implement Stage 1 of the internal PPC dashboard. The project is real, the data is live, everything is ready to start. Frontend prototype (5 pages, React + TypeScript): WHAT IS ALREADY READY — Frontend… Javascript and Typescript, Web Programming ∙ 4 days 8 hours back ∙ 31 proposals |
Development of a photo book and photo frame constructor websiteProject Goal A modern website needs to be developed for ordering photo books, photo frames, and other personalized photo products. The main task of the project is to provide the client with the ability to independently create a ready-made layout of the product directly on the… Javascript and Typescript, Web Programming ∙ 6 days back ∙ 98 proposals |
Team for a custom marketplace of funeral services.We are looking for a team to launch and develop a custom national marketplace for funeral services. Right away: we are not looking for solo freelancers, juniors, or "website builders." We need a strong product team at the middle+/senior level with real cases in… Javascript and Typescript, Web Programming ∙ 6 days 19 hours back ∙ 27 proposals |