Correction of the script in the Google Table
11 USD The script creates in List1!In a column of unique codes from the first five characters List1!A; then searches for coincidences in List2 (by the first five characters) and records in List1!S the number of coincidences of the code (how many times the product has been sold). There are also manipulations with List1!D, but this can be ignored.
What to fix: at the time of creating the script, the code of the goods began exclusively with "A", and their script is perfectly considered. But now there are codes starting with "B" - their script does not think. I have to do what I thought. And also counted all the codes that contain the first symbol of the cyrillic and 4 digits after (for the future).
Symbols in the code of the goods are numbers and cyrillic (no Latin).
The script is attached.
Applications 2
Client's review of cooperation with Anton T.
Correction of the script in the Google TableVery fast and without pre-working. The script works as it was agreed in tz. I recommend cooperation!
Freelancer's review of cooperation with Aleksey Goryachev
Correction of the script in the Google TableCustomer quickly responded, quickly checked and successfully closed the project
-
1 day11 USD
3668 107 0 1 day11 USD
I look at the code, I’ll fix it.
But you also need to show the table with which the code works.
-
1 day11 USD
1838 43 0 1 day11 USD
Good day !
A interesting code. The error really is, the code is actually adjusted only under the letter "A" and the numbers.
Go, we'll make a universal code that will work according to your TZ
-
Winning proposal1 day11 USD
5923 345 0 Winning proposal1 day11 USD
I write a pure new simple script for the data that is actually used (without a third list, etc.).) will work according to your algorithm: allocation of codes in the form of the first 5 characters, building a list of unique codes, calculating the number of sales of each code
-
1 day11 USD
865 50 0 1 1 day11 USD
Hello Alexey !
I’m ready to help you, I’ve watched the script.
I know what the problem is, copied your table to myself and introduced changes to the script all worked as needed.
Write me, I'll give you a link and you'll see the right table.
Current freelance projects in the category Javascript and Typescript
Commercial on-premise video communication platform "ViM"It is required to develop an on-premise video conferencing system with a basic calculation for 100 simultaneous connections (10 isolated rooms of 10 people each). The platform should have a built-in architecture for future horizontal scaling up to 1000 users by adding new media… Javascript and Typescript, Web Programming ∙ 3 hours 46 minutes back ∙ 18 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 1 day 7 hours back ∙ 17 proposals |
Website design updateIt is necessary to update the design of the existing website using HTML, CSS, JS: refresh the appearance, make it modern and responsive for mobile devices. Smooth animations and interactive elements need to be added. HTML & CSS, Javascript and Typescript ∙ 2 days 1 hour back ∙ 87 proposals |
Consultation and audit of the current project on Odoo 19 Community Edition
We 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 ∙ 2 days 6 hours back ∙ 7 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 ∙ 4 days 3 hours back ∙ 101 proposals |
Kyiv