Create a table to work with New Post
67 USD You need a Google Source table that could be multiplied into different tables with the preservation of the functionality:
Columns
1) number on the list 1-2-3-4 and so on (automatically counted)
2)Client's FIO text field (inserted in the table by hand)
Text field number of the phone (inserted in the table by hand)
4) text field TTN (inserted by hand)
Number field price (which is written by hand)
6) Number field price out (written by hand)
7) the number field of the margin and here the functional begins:
7-1 if the status ttn is a refusal, the line is red, the margin is equal to the determined number that I myself once prescribed somewhere in the cell.For example, he wrote -200, and all the red fields of steel -200, he wrote -300, and all the red fields -300 steel.
7-2if the status ttn - sale, the line is colored in green and the margin is equal to the difference between the price above - the price above
7-3So you should leave the possibility to write a number in the margin by your hands for the forces of major situations, not depending on the outcome etc., so that at the same time in the table nothing would be broken.
7-4 You must have the ability for the forces of major situations to paint the line with any other color that anything does not break.
You need to be able to add and remove the lines in the table so that nothing is broken.
7-6If the TNT stool is not yet purchased, but already in expensive - a beautiful line with a blue color
7-7If the status of TDN is already in the department but not yet purchased - a beautiful line with yellow color
If the field is empty or the field is in incorrect format or awaits a shipping, the line remains white.
8)the field of the status of the new mail, where the word must be prescribed the status of the TTN (sold / rejected / goes to the department / arrived in the department)
9) 4 text columns for what I could write any comments on them
10)It is very important that it is updated either by pressing a button or itself with a certain frequency.Best in hand by pressing the button.
11)It would be very necessary to have the tabs below January-February-March and so on, on which there were respectively empty duplicates of the template, after the end of the month to move to another tab.
The option is to update each line separately - it is not suitable, the line will be a lot
Client's review of cooperation with Andrii D.
Create a table to work with New PostVery efficient and communication at the height.
Freelancer's review of cooperation with Andrey Scherbina
Create a table to work with New PostGood customer, perfect TZ!!! Communications 24/7
-
Winning proposal5 days67 USD
231 1 0 Winning proposal5 days67 USD
I have a great experience working with Google tables and new mail, I can show examples of my work. He has done a lot of projects and optimization for different types of business. I think I will be able to help and suggest you how to optimize) I will be happy to work with you. Please write to L.S. a good day)
-
2 days38 USD
1115 109 0 2 days38 USD
Hello Andrei.
I write scripts to update the status of TTN. There are no problems with the package, but there are moments for implementation - write, we will discuss details.
-
2 days45 USD
953 11 0 2 days45 USD
Hi, I will do in google sheets, previously worked with apps script, and with the API of new mail. Go to turn!
-
Добрый день! Можете показать структуру гугл-таблицы(в копии)?
-
Current freelance projects in the category Java
Development of simple 2D games (Snake, Galaxy, etc.) for Google Play MarketHello! I am looking for a developer (or a beginner with a good foundation) who can create several simple classic 2D games for the Android mobile platform with subsequent publication in the Play Market.To start, one or two games need to be developed. Examples of settings and… Java, Gaming Apps ∙ 1 day 9 hours back ∙ 16 proposals |
Application developmentI wish to create a mobile application for communication, the app should have audio and video calls, group chat creation, the ability to sync with phone contacts, account settings: email binding, 2FA, phone number, the ability to customize app notifications, change the app… Java, Python ∙ 6 days 2 hours back ∙ 39 proposals |
Kyiv