Synchronization of two tables. inventory of goods
It is necessary to synchronize two Google Sheets: one contains the list of orders, and the other tracks inventory (the inventory table is not critical - it can be replaced with a program/application).
In the order list table, add a dropdown list of products in column Q (from the "inventory" table).
Also, when a product is selected, automatically fill in the cells:
D - purchase
G - product name
P - product name in SMS
And implement the following: when a product is selected in column Q, the product should be deducted from the stock (not necessarily online, for example once a day or upon request).
It should also be possible to add and adjust the quantity of products and purchase price in the "inventory" table (reminder that this table is not critical, it can be created in a program/form/database/application).
This order list table is used by managers, so this task can be performed after 6 PM or, preferably, on a similar table (I will create a duplicate table).
Applications 1
Client's feedback on cooperation with Artem Plaha
Synchronization of two tables. inventory of goodsEverything was done professionally and quickly
Freelancer's feedback on cooperation with Andrii Kovgan
Synchronization of two tables. inventory of goodsI was glad to work with Mr. Andriy again, we quickly discussed everything and completed the project. Thank you
-
Good day. Ready to start working, I have worked with Google Sheets multiple times. I look forward to collaborating
-
574 1 0 Hello. I have extensive experience in developing and automating various tables and reports in Excel and Google Sheets. I am ready to complete the task.
-
492 2 0 Good day, I have experience working with Google Sheets, I can complete your task as quickly and as well as possible
-
545 4 0 Good day
Ready to implement your project on Google Script+Make.
The automation will work at specified hours.
I have extensive experience in automations through Google Sheets.
I will be glad to cooperate
-
673 3 1 Hello. I can implement it with a Google script.
I think creating a separate program for replacing the accounting table is not practical. It will be much more convenient for you to open the table and quickly correct the necessary values (since there are not many), or I can do it in the future if you need to create a simple admin panel with a web interface. (More for aesthetics).
-
5760 374 2 3 Good afternoon.
I can do it with formulas and scripts.
-
546 3 0 Good day.
Have experience in automating Google Sheets.
Ready to complete your task.
Write to discuss the details.
-
1606 16 1 Good day! I am ready to take on your project. Write to me privately to discuss the technical specifications and cooperation terms.
-
805 7 0 Ready to implement your request through Make.com in combination with App Script. All I need to get started is a small mini demonstration of how you want to see the result
-
934 11 0 Hello!
Ready to help with this project!
Write to clarify details
-
Вітаю, Андрій
Я так розумію, облікової системи у вас немає і не потрібна? Чи можна пропонувати?
-
Current freelance projects in the category Bot Development
Development of turnkey Telegram bots for business and automation
36 USD
Hello! I professionally develop Telegram bots of any complexity tailored to your needs: Business automation, orders, chats Digital goods stores (including PlayerOk, Playrock) Support for Telegram Stars, promo codes, referral programs Interactive bots: calculators,… Bot Development ∙ 2 hours 4 minutes back |
Connect the chat-bot and payment system for selling the webinar through Telegram.
24 USD
It is necessary to create and connect such a bot through which a webinar can be sold. In Telegram. That is, so that people can enter it, receive some additional information about the lecturer, the webinar, then pay for this webinar in the bot and gain access to it in the same… Bot Development ∙ 2 hours 24 minutes back ∙ 15 proposals |
Telegram bot with content generation, integration with Sendpulse
241 USD
Здравствуйте, нужен такой бот. Цена укпзана произвольная. Пишите ваши расценки и сроки выполнения. Telegram-бот с автогенерацией контента, курсами, геймификацией и трёхуровневой партнёрской программой (с возможностью клонирования) ФУНКЦИОНАЛ И ИНТЕГРАЦИИ Разработка… Python, Bot Development ∙ 4 hours 6 minutes back ∙ 3 proposals |
Installation of the bot on the server and admin panel + routing setup
29 USD
There is an easy bot with an admin panel on Angular, it needs to be deployed on hosting and routing configuration for interactions should be set up. The bot itself is on C#, and there is integration with Docker. For more detailed points, I will wait for your response. Bot Development ∙ 6 hours 18 minutes back ∙ 5 proposals |
Transfer call data from Binotel to Looker StudioHello, it is necessary to transfer call data from biontel to looker studio Incoming calls Outgoing calls Missed calls Please specify the cost and deadlines in the applications, thank you. Data Parsing, Bot Development ∙ 20 hours 28 minutes back ∙ 7 proposals |