Project translated automatically. Log in or register, to view the original It is necessary to create a table to work with a new mail, it must track the status of the mail by the entered number.Choose options and look at everything.It is necessary to automatize the manager's work as possible.TZ for the table: 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

Proposals 5 Discussions 1

Andrii D.

Winning proposal

1 0

Projects -
Rating -
Rating 231

Budget: 3000 UAH Deadline: 5 days

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)

Oleg M.

109 0

Projects 105
Rating -
Rating 1 115

Budget: 1700 UAH Deadline: 2 days

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.