Need a specialist in Google Script
Good afternoon, dear freelancers. I need a specialist in Google Script.
The essence of the task
There are two tables: one for orders, and the other for tracking inventory and profits. When the status of an order changes in the orders table, the inventory is updated and the profit is calculated in the second table. Now, the order statuses will be updated not manually but from the CRM. It is necessary to write a doPost function so that when the order status changes, the same logic works as with manual changes.
All scripts are in the attachment. For questions, please write to me privately.
UPD
Надо эмулировать объект e и передать в функцию
statusHandler
Пример объекта
Информация
Объект e в onEditTriger: {"authMode":"FULL","range":{"columnEnd":16,"columnStart":16,"rowEnd":13110,"rowStart":13110},"source":{},"triggerUid":"9268348","user":{"email":"","nickname":""},"value":"Катя"}
That is, essentially, the order number comes in the post, you need to run through column A and find the row in which the order number is located and pass this data to the function.
Тоесть по сути в post приходит номер заказа, нужно прогнать столбец A и найти строку в которой номер закза и передать в функцию эти данные.
Applications 1
-
1 day33 USD
1 day33 USD
Good day!
I have extensive experience working with Google Sheets and their automation. I will be happy to help you implement your task.
Feel free to reach out, I am ready to start right away.
-
1 day22 USD
3668 107 0 1 day22 USD
I would like to see the tables that the code refers to...
It will be easier to adjust the code this way..
-
1 day22 USD
2060 25 0 1 day22 USD
Good afternoon, Dmitry. The task is clear, I am ready to start working on the order.
-
1 day356 USD
3853 24 0 1 day356 USD
Good afternoon,
I am a Google Script specialist and ready to take on your project. I can help with writing the doPost function for updating product stocks and calculating profits when the order status changes in the spreadsheets.
It is required to emulate the object e and pass it to the statusHandler function based on the data coming in the POST request. I would be happy to help with this task.
My rate is $16 per hour. I will be waiting for additional information to start working.
Thank you.
-
1 day45 USD
4464 102 0 1 day45 USD
Good afternoon. I will be happy to help. I will complete everything quickly and efficiently!
-
2 days56 USD
94346 1269 1 10 2 days56 USD
Hello. I have a lot of experience with JavaScript. As I understand it, there will be a request coming from the CRM?
Current freelance projects in the category Javascript and Typescript
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 ∙ 2 days 17 hours back ∙ 101 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 ∙ 2 days 23 hours back ∙ 21 proposals |
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 days 18 hours back ∙ 32 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 ∙ 4 days 22 hours back ∙ 18 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 ∙ 5 days 16 hours back ∙ 90 proposals |
Ukraine