Help Desk System in GOOGLE SHEETS / Support-Ticket-System google Sheet
34 USD I need to create a task management table in Google.The tasks always relate to the ratio of the employment contract of the worker with the client/ enter the task through the Google form the worker receives it on the mail, if he responds to the mail then the mail receives the one who created the task.The system generates the topic of the letter and enters the task ID when the mail is sent the task receives the status : the unprocessed employee who received the mail through the link must set the status: in the processing after receiving a decision or answering the question, the employee who created the task notes it as : closed I can see the task processing summary ( example in the screen in the application) Also in the flow table in the line of each client are displayed the pickets status (example in the application) Tickets are formulated by the current ID in the current or by the seat ID from the seat list table or by the client ID from the client list table.That is, it tics either to refer to the ratio of the seat and the customer, or only to the customer or only to the seat.If we write a task to the internal department, then the topic of the letter in Russian, if on the external it in German.Translation in 2 languages below
if on the inside separated to the external1changeWechselplanung2customer accountKunden Rechnung3customer accountProvi Rechnung4customer problemsIntervention5customer contractDLV6customer offerPersonalvorchlag7customer planAnreiseplanung8customer leaveAbreisedatum9customer documentsUnterlagen der BK10customer durationArbeitsdauer BK11customer durationBK Gehalt12customer returnBK Rückkehr13customer problemsIntervention14
The mail must already have a welcome template and address to the person to whom we are addressing from the database.The mail must have a signature based on the one who created the ticket in the pickets list should be the time of the ticket in the pickets list should be the time of the change of the status of the ticket separately
link to the table in which the system should work: https://docs.google.com/spreadsheets/d/1_wLwmOHrEEBte2DBfPQjG7hoYo5h1eKB1f0iCvXFtTA/edit#gid=423669596&fvid=1696450483
to whom addressed
Inner department from the database of employeesBackofficeInner department from the database of employeesKontatk OpiekaInner department from the database of employeesKuntakt KundeInner department from the database of employeesS.L.Inner department from the database of employeesTransferInner department from the database of employeesPartnersInner partner from the database of partners
Please ask how the author makes the video on YouTube his help desk management.If you know what to do it in 2 hours can be managed 😉 Time of discussion and planning is understood separately.Examples of implementation:
1) https://www.youtube.com/watch?v=7Pk3Qdrh8FQ
2) HTTPS://www.youtube.com/watch?v=xPVD5cHJEKY
3) https://www.youtube.com/watch?v=tkvP4Ksjpbs
4) https://www.youtube.com/watch?v=HSV7j03aSMM
I'm looking forward to good suggestions from you, thank you before!
Applications 3
Client's review of cooperation with Yurii Apostol
Help Desk System in GOOGLE SHEETS / Support-Ticket-System google SheetYuri has a very professional approach to flights. Communication is also transparent and clear. I am pleased to repeat.
Freelancer's review of cooperation with Alex Veprytskiy
Help Desk System in GOOGLE SHEETS / Support-Ticket-System google SheetEverything is well. I recommend Alex to cooperate and I am happy to continue working on the project.
-
1 day27 USD
270 8 0 1 day27 USD
Hello to you. It seems something interesting. We need to discuss and go through each point.
Write and discuss.
-
10 days113 USD
147 10 days113 USD
Good day . IT company from Kiev is ready to consider this project. For a more accurate calculation of the request to provide "Technical tasks" - (the template is provided) for the evaluation of the project and the deadline of the work. The company works with the development of websites, their promotion and contextual advertising, only on the basis of the TZ we can talk about the implementation of the project. We work with a guarantee. Congratulations to Alexander.
-
Доброго вечора.
Що означає java script?
На чому працює ваш сайт?
У вас є якийсь хостинг? -
Alex Veprytskiy Medius Work & Consulting Sp. z o.o.
сайт на flutter. Но достаточно выполнить всё в гугл таблицах
server node.js zf на digital ocean
java script = google script
хостинг есть. Сайт пока на него не надели.
-
Не - google script - а google sheets.
Там можна на різних мовах реалізувати.
node.js - не моя тема 😔 -
Alex Veprytskiy Medius Work & Consulting Sp. z o.o.
google script погуглите. Посмотрите видео по ссылкам которые в описании. Само описание тоже не мешает почитать, так как работа не по сайту а на гугл таблице. Спасибо
-
Вам тоже дякую, за відповіді.
-
Current freelance projects in the category Web Programming
Looking for a Frontend Developer (React + Tailwind) to refine the websiteHello everyone! We are looking for a skilled frontend developer to help us finish the website of a premium plastic surgery clinic. The situation is as follows: the site has been designed and built using two AIs — the logic, structure, and code were created through neural… Web Programming, Web Design ∙ 38 minutes back ∙ 13 proposals |
Development of 2 SEO-oriented websites for selling spare parts (ATVs and special equipment)Development of Two Specialized Websites for Selling Spare PartsGeneral Information It is necessary to develop two specialized websites: Spare parts for ATVs, UTVs, SSVs, and other similar equipment. Spare parts for special equipment. Existing company website:… PHP, Web Programming ∙ 10 hours 25 minutes back ∙ 48 proposals |
Need a 1C specialist (Trade Management)
23 USD
Need a 1C specialist (Trade Management) We are looking for an experienced 1C programmer for a small integration project. We have an online store and a 1C UT configuration. It is necessary to set up data exchange between the website and 1C — so that the website can receive… System & Network Administration, Web Programming ∙ 13 hours 36 minutes back ∙ 9 proposals |
Creation or adjustment of a website on OpenCartHello everyone! Preliminary situation for understanding: I ordered the development of a website from Templatemonsters. I agreed on the technical specifications in advance and purchased a template from them. In the end, the deadlines were not met, and they wrote that they could… Web Programming, Online Stores & E-commerce ∙ 1 day 22 hours back ∙ 36 proposals |
Development of an AI mobile application for children's fairy talesLooking for an experienced developer or team to create a mobile application with artificial intelligence that will generate short, kind, and age-appropriate fairy tales for children. A simple, beautiful, and safe product where a parent can create a personal bedtime story for… AI & Machine Learning, Web Programming ∙ 1 day 23 hours back ∙ 47 proposals |
Kharkiv