Creating a Google Table
Prohibit filling the lines manually.To be able to submit a request for delivery only through the form.The 2ndCreate a form to create a new line with the button "Add Order" .After filling out the form and clicking on the button - create the corresponding line with these data.3 .With the possibility to make possible filling the form only with a standard non-fat black font.and 4.Fix the date of submission of the application and the timer of the glass of time passed after the submission of the application.To be seen in the list of applications how many days the application is required
and 5.Add the status of the application to the drop-down menu.Show only current applications with current status.The second status is planned delivery, the third status is delivered.6 .Form a second list -> register of submitted applications.After changing the status to delivered -> the application disappears from the delivery table and enters the application register and does not interfere with the main table.In the main table, only current applications and scheduled will remain.7 .Create a way of grouping applications into one trip.Now from the whole list, the logist according to his requirements forms a group of applications and indicates the line above - the date of delivery and driver.My idea is to add the column delivery date and make the lighting of all lines with requests with a certain color for the visual effect.The trigger for lighting can be the delivery date or the status of "planned delivery"
Ready to answer all the exhaustive questions.If some of the points are impossible to realize or can be realized in another way - ready to consider an alternative
Додано фото приклад форми заповнення
The 10. When choosing the status of "planned" applications automatically drop into a series, forming a list of planned discounts
9. Заявки фільтруються по додаванню зверху вниз. Чимдовше заявка в таблиці - тим нижче буде в списку .
10. При виборі статусу « заплановано « заявкиавтоматично опускаються в низ , формуючи список запланованих знизу
Applications 2
Client's review of cooperation with Oleksii Kuzavov
Creating a Google TableIt all went on a higher level. The Executive Communicable, worked out the final option and performed all the corrections that the customer introduced and we got even the best product, not expected to recommend to everyone.
Freelancer's review of cooperation with Andrii Tarnavsky
Creating a Google TableA great customer.
Clear and clear TZ, always in contact. Beautiful communication. Everybody is pleased.
I am happy to work again.
I recommend it.
-
3621 113 7 1 Good day
I am specializing in creating and editing such tables.
Ready to implement your project.
Write in a personal message to discuss details.
-
270 8 0 Welcome to! I think the forms here are not quite relevant, it's better to do everything on the script. There is experience working with Google tables, writing scripts and formulas, recently made myself a similar thing(work need), if it will be interesting I can describe how everything works, make screens(screens because some information I can't show, I need to paint).
-
530 32 4 I do in the form of a web service, there are similar projects.
There are a few questions, but the task is generally clear.
• • • • • • • • •
-
421 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
Добрый день, обязательно нужны Google таблицы?
Возможно проще и красивее будет обычным web сервисом с нужным фунционалом?
-
Доброго вечора. Нещодавно робив схожий проект. Тільки зі студентами. Опрацювання заявок на практику. Коли нова заявка приходить з Гугл форм - додається в таблицю, після чого при зміні статусу на дані перевірено - вона переміщується до листа "Підтверджені заявки" і при зміні кожного статуса - переноситься на потрібний лист.
Тут можна повісити тригер який спрацює при зміні статусу.
-
Це можна зробити через Гугл скрипти і підв'язати до таблиці.
Єдине що не зрозумілий до кінця 7 пункт.
-
По яких вимогах логіст формує групу заявок на доставку?
-
Current freelance projects in the category Data Parsing
Svitlahata
17 USD
It is necessary to import 1819 products from the XML/YML feed of Prom.ua to OpenCart 3. A ready XML file is available, which contains product names, descriptions, prices, photos, specifications, manufacturers, and categories. Requirements: import all products to OpenCart… Content Management Systems, Data Parsing ∙ 5 hours 27 minutes back ∙ 22 proposals |
Data parsing through mobile APILooking for a person with experience in data parsing through mobile API, for parsing e-commerce, rozetka and similar sites. Tasks: 1. Intercepting traffic from the mobile application (Android), setting up a proxy, analyzing requests. 2. Identifying the necessary API endpoints… Python, Data Parsing ∙ 2 days back ∙ 29 proposals |
Looking for a programmer or vibe coding Automation scraping data 2https://drive.google.com/file/d/14tP5XWJB9acV4gn_cJrFwMpihUj3EbQz/view?usp=sharing I accidentally sent that link Web Programming, Data Parsing ∙ 2 days 2 hours back ∙ 38 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 6 days 21 hours back ∙ 20 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 7 days 1 hour back ∙ 38 proposals |