Google Sheet Scripts
1 . In the tab "working area" in this tab we will enter the data, for example, in the 3 = cells will be sh001, sh002, sh003. We set out 3 cells and run a script. There should be 2 buttons "Enter" and "Scribe", we're pressing "Enter" in this example.
2nd After pressing "Enter" the script should be issued in the pop-up box with the "Input" list of the table, we select the desired entrance.
Three The script after selecting the tab, turns to the chosen tab, finds the "sku" column in this column searches for the value of sh001 and if it is there, the script in the quantity column opposite sh001 puts +1 to the already existing number, and in the "working area" column the sh001 cells paint green if the script does not work painted red.
4 . This was an example with the option of "introduce" , the option of "writing does everything itself only -1"
-
1156 45 0 Good day !
I realize a Google script under a Google table. Start through the menu.
-
270 8 0 Good day .
As you want the buttons in the drop-down menu on the task panels or checkboxes or images.
Do I have to eat cells? I don’t understand why to do this.
The task is clear in principle. Small details are only interesting.
And it is desirable to look at at least a copy of the table with which it is going to work.
Current freelance projects in the category Javascript and Typescript
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 ∙ 1 day back ∙ 24 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 ∙ 2 days 16 hours back ∙ 93 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 ∙ 3 days 11 hours back ∙ 26 proposals |
Improvement of the existing Next.js/Supabase project: offers, CRM, analytics, AI chatThere is an active project WatchGenius — a luxury watch analytics platform with a catalog of models, price analytics, external offers, application forms, and an AI chat. The project has already been partially developed. We need not a website from scratch, but an experienced… Javascript and Typescript, Web Programming ∙ 5 days 12 hours back ∙ 55 proposals |
I am looking for a Senior Full-Stack Developer (Payload CMS) — migration of 2 websites for a hotel chain.The resort hotel network is transitioning from Webflow to its own headless stack. Two corporate websites (~140 pages in total), multi-tenant architecture — one code serves multiple hotels on different domains. The project has already started: the infrastructure is deployed,… Content Management Systems, Javascript and Typescript ∙ 9 days 10 hours back ∙ 19 proposals |