How to build a Help Desk System with Google Sheets, Google Forms and Google Apps Script

[@practicalsheets]

We are just starting. Next steps will include tracking of cases, emails and more. Any suggestions?

[@agonaivankutosi4185]

This has really been helpful to me in my ticketing system . . keep it up

[@jawsstech]

Thank you so much for this tutorial. I am already learned very much from watching your video. I am a subscriber. Your coverage of how to use the google documentation was so helpful to me. It is going to make a huge difference in my ability to use apps scripts. Thanks again.

[@practicalsheets]

Ím so glad this is helpful to you Thanks for the kind words! Regards!

[@tecstalinramirez]

Conocí tu canal en español, es asombroso que también lo tengas en inglés, tu inglés es muy muy bueno, agradezco a Dios tus conocimientos y método de enseñanza, eres muy bueno, bendiciones.

[@practicalsheets]

muy amable por tus palabras. La verdad todavía me quedo pensando muchos temas, jaja, pero hacer videos me ayuda no solo a mejorar en sheets, sino tambien en ingles! gana-gana! Mil gracias!

[@PaulRiveroZ]

​@@practicalsheets Hola! están geniales estos videos, pero me cuesta un poco el inglés. ¿Cual es tu canal en español?

[@practicalsheets]

@@PaulRiveroZ Aquí te lo dejo Pablo www.youtube.com/@JuanSGuzman Saludos!

[@cameronf06]

Thank You for this tutorial! I am currently implementing a system for my department. Excellent tutorial 🎉

[@practicalsheets]

Thank you for commenting!

[@delomuvis4162]

I really admire your knowledge in the use of google products. Which course did you take that got you up to speed please. Can you share it with me?

[@practicalsheets]

Hello! I began with this youtube channel www.youtube.com/@ExcelGoogleSheets/videos Kind Regards

[@bijanbaniasadi6559]

Very nice to see the method!

[@practicalsheets]

Thank you! Actually this timestamps took way longer than I thought. Next video I´ll get into the help desk aspect with more detail. Regards!

[@wyvettecharles7628]

Thank you for sharing this. It actually worked but the 1 for the Requirement Code did not work. I will have to use a formula instead. I left off on this part and will come back and finish this tomorrow. Please share videos on how to assign and escalate the tickets. And are you available for 1 on 1 sessions on google calendar?

[@СергейИзместьев-ф1н]

Hello! Thank you for your hard work. Is it possible to download your scripts or transfer them to google? Best wishes!

[@practicalsheets]

Hello!! You can access all of them in the patreon page where you can support me. If not, send me an email. Regards!

[@torialpedro6540]

Hello! Thank you for your videos. I am following along. I am still getting e is undefined. after adding the trigger

[@practicalsheets]

Hello! Are you running it from the editor, or just sending the form? Regards!

[@didulanimesh6775]

super

[@practicalsheets]

Thank you!

[@Sheikh_Yerbouti]

I am following along with you to learn a bit more about forms and scripting them. I am currently stuck on this error and I have checked and double checked, but still keep receiving this error "TypeError: questionResponses[0].getItemResponses is not a function at addAnswer(Code:6:40)".

[@practicalsheets]

Hello Lachlan! Make sure you end getItemResponses with parenthesis () Regards!

[@bijanbaniasadi6559]

Hey, thanks, bro!

[@practicalsheets]

Thank you for commenting!

[@Friz819]

i appreciate what we are building here. I get to the execution log, and it says status failed for the submission. Any ideas about how I can make this work?

[@Friz819]

@practicalsheets I found that I had errors where I had "(" and sometimes "{" vs. "}" positioned. I found i spelled "form" as "form" and eventually....... it worked!! I'm going to next video at some point soon. THANK YOU SO MUCH! this is great.

[@practicalsheets]

Sorry I wasn´t of any help ;) But sometimes when you solve it on your own you learn more that if I had told you... Kind Regards

[@yenmagi8887]

Thanks for this. However I am having problem with trigger whenever I submit the form it says ReferrenceError: formResponse is not defined at addAnswer (Code:4:17) What should i do?

[@practicalsheets]

Hello Google Forms has had some problems in the past month Did it finally work? Regards!

[@joselitosalvadora8007]

Good day sir, how about if we add in the array a File Type, it do append on sheet but we can't browser the file

[@pongepongstan8637]

Hi @practicalsheets I got this error code "TypeError: Cannot read properties of null (reading 'appendRow') at addAnswer(Code:15:6)" please help to resolve this

[@practicalsheets]

Normally when the error is appendRow, the problem is in the sheet Please check that the name of the sheet is correctly written Regards!

[@pongepongstan8637]

@@practicalsheets Hi I have change the name of the sheetsand it works now amazing!!, I have one other question, what if I want to insert or upload picture in the forms? I tried to put picture as one of my questionResponse but what I get from the response trigger is some random letters like this "[Ljava.lang.Object;@2b92eeb6"

[@practicalsheets]

@@pongepongstan8637 Hello An image comes as an array, so you should use [0] to access the first element of the array Images is a bit more complex subject I'll try to do a separate video Kind Regards

[@hancemaglasang449]

Hi why do i still have the same error after adding the trigger?

[@practicalsheets]

Which error? Kind Regards

[@BradSalsman]

Am getting this error: TypeError: Cannot read properties of undefined (reading 'getResponse') at addAnswer(Code:6:35) Would appreciate any assistance, thanks.

[@practicalsheets]

Are your running the function from the editor? Regards!

[@mysterygay3]

@@practicalsheets i have the same error, code 14:41, running from trigger (submit form)

[@practicalsheets]

​@@mysterygay3 Do you still have the error? Could I see your code?

[@mysterygay3]

@@practicalsheets thankfully i fixed it, i realized the error code is line number and position of the error, so after some researching it worked flawlessly. Really thank you for your guide

[@practicalsheets]

I´m glad you fixed. Fixing these types of errors is the best way to learn. Regards!@@mysterygay3

[@starry_impression]

When I am creating the trigger, the event source doesn’t have from form, I only have from spreadsheet. When I fill the form, the trigger is not executing

[@practicalsheets]

Helloo You sure you´re creating it from the Google Form and not the Sheet? Regards!

[@gangialf90]

I try it but i have a problem with the timestamp variable; i’m currently stuck on this error and i have checked, but still keep receiving that error “TypeError: formResponse.getTimeStamp is not a function at addAnswer (code:4:30)”

[@practicalsheets]

Hello Dario Google Forms has been having several issues this past month. Were you able to solve? Regards!

[@gangialf90]

@@practicalsheets no, after several attempts, I finally opted for another method

[@practicalsheets]

@@gangialf90 Too bad! So sorry I wasn´t able to help. Regards!

[@tantahwooding1759]

Does Practical Sheets build Help Desks for clients?

[@practicalsheets]

Hello! Not yet! I´m no expert in help desk. Hoepfully with this series of videos I can learn more about it, with the help of your comments Regards!

[@kervinmartinez6628]

How about uploading photo? How can we do that on script with links on google drive to see the photo

[@smac771]

Why I can't trigger the bot by simple update the sheet, made by filling the FORMS ? Writing the script looks so complicated.

[@practicalsheets]

Hello Is true, We could also do the consecutive numbers without any code, just with formulas. However, this heavy work will pay in the future, because we can have a much more flexible system. I will try to do a parallel system without any code, so we can see the differences Thank you for the comment!

[@torialpedro6540]

I have an upload function in my form. The uploaded files go to a google drive folder. I can't seem to add the code for the file. I am using var image=questionResponses[4].getResponse() but it fives error.

[@practicalsheets]

Yeah. I think attached files work differently. Iw ill work on that. Regards!

[@khaaaloi]

We have the same error. Hopefully, there is an answer to our issue. :)

[@kervinmartinez6628]

is there any update on this?

[@TreyTamayo]

Hello, I am having an error when running a trigger, it shows ReferenceError: emai is not defined at addAnswer(Code:12:25

[@practicalsheets]

Hello! Are you sure thevariable is not "email"? Regards!

[@kevinpiedragosa2981]

How to reset Requirement Code Number using FormMule?

[@BusinessBananaShikhe]

Can u share scripts

[@practicalsheets]

Of course! In the patreon page you´ll find all scripts and templates Regards!

[@jaws21015]

@@practicalsheets but it's not free is it?

[@practicalsheets]

@@jaws21015 No, sorry. It´s the catch for patreons, jaja. Regards!

[@gautamvaid1415]

Hi I am Gautam facing TypeError: questionResponses[0].getResponses is not a function at addAnswer(Code:6:33) and this is my code which wrote function addAnswer(e) { var formResponse=e.response var email=formResponse.getRespondentEmail() var timestamp=formResponse.getTimestamp() var questionResponses=formResponse.getItemResponses() var high=questionResponses[0].getResponses() var gautam=questionResponses[1].getResponses() console.log("email: "+email) console.log("timestamp: "+timestamp) Logger.log("high: "+high) Logger.log("gautam: "+gautam) } Kindly help me out where i am wrong.

[@practicalsheets]

You should do Logger.log(questionResponses) to find your error Kind Regards