Google Sheets, Mini CRM
Hello, we have a table for order accounting.
The main task, briefly, is to create a sheet from this table that will be convenient for the packer to collect the orders. In the end, the packer should have a sheet that states the tracking number and the quantity of goods that need to be collected for this package. Tracking number 2 and the quantity of goods, tracking number 3 and the quantity of goods.
link to the table
https://docs.google.com/spreadsheets/d/1Q0K9ijiDSXpmDOaQw4KnMbPvwbtzkOtInVgHE-yeCec/edit?gid=633327784#gid=633327784

I will explain point by point how I see this and want it
1. There are several static positions of the product range
I manually enter the quantity in the cell titled "quantity". The product name and quantity should be displayed in the "Invoice" column
Example: the first client bought 1 piece of a barking dog, 2 pieces of jumping cats
in the invoice column we will get ![]()
With the next client, the same but different products.
IMPORTANT: product names that are not purchased in this order should not be displayed.
A column option where it shows Zero is not suitable

this is not suitable
2. Currently, the types of products are static, but there should be an option to add another column, a couple more products
3. Output of tracking numbers and order composition for printing on the printer

This is the final task; the sheet should be printed for the packer in this format
On the printed sheet, it should allow selecting the “number and name of the registry” and in this table, there should only be those cells that relate to this registry
That is: I select registry 1.
and the order number, composition, and tracking number are displayed on the page
When I select registry 2
I will accordingly see different data.
The link of the registry to the order occurs on the first page.
Read carefully and make your bids
Client's review of cooperation with Tetyana Shumeyko
Google Sheets, Mini CRMvery quickly, and clearly according to the specifications. just excellent
Freelancer's review of cooperation with Vitaly Streltsov
Google Sheets, Mini CRMThank you to the client! Everything went WONDERFULLY, as always! I recommend 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.
-
Вітаю,
А може вам краще б було запропонувати якусь простеньку облікову систему з Новою поштою зі зручним веб-інтерфейсом?
-
интерецные конкурсы у вас)
-
Current freelance projects in the category Javascript and Typescript
Real Estate Platform - Blockstar (AI + 3D + Blockchain)
25 000 USD
Blockstar is a technology-driven startup focused on transforming real estate investing through blockchain, AI, and modern web applications. Our platform enables users to invest in fractionalized real estate assets, providing a seamless and data-driven investment experience. Cryptocurrency & Blockchain, Javascript and Typescript ∙ 1 hour 14 minutes back ∙ 5 proposals |
Fix the CSS/DOM layout of cards in the Chrome extension for localizing D&D BeyondThere is a Chrome extension Manifest V3 that localizes the D&D Beyond website into Ukrainian. The project is written in TypeScript + WXT. The extension works through a content script: it finds English text on D&D Beyond pages and replaces it with the Ukrainian translation. The… HTML & CSS, Javascript and Typescript ∙ 4 hours 10 seconds back ∙ 16 proposals |
Modules for a website on Laravel
90 USD
Delivery and payment module for the site https://novabook.top/ (Botble CMS / Laravel) Add convenient delivery and payment methods (including installment plans) in the checkout, similar in style and convenience to the mirson ua site.Delivery (mandatory) Nova Poshta Branch… Javascript and Typescript, PHP ∙ 10 hours 2 minutes back ∙ 18 proposals |
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5770 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 13 hours 20 seconds back ∙ 82 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 18 hours 45 minutes back ∙ 17 proposals |