@@saperis Workflow and automation with Google Forms. A script like formsapproval. I don't know if my company would like to integrate a third-party add-on on our Gsuite, hence, Looking at using App Scripts for this.
Great Video Saperis. How would I build an Array using your example? In your example you log out just each row. So we each loop you loose the last row. How would I build an Array, row by row to show the complete array of all the rows? So, as it loops it adds the next row to the last one until you have a complete array. I have an XML response that I am trying to first load into an array then write in one hit to the sheet. I am currently using .appendRow within my loop which is really, really sloooooooow.
Thank you for your video you make my mind
My pleasure 😀
Thanks!! Estava esperando por esse! Gostaria de agradecer muito. Não vejo a hora do próximo. Parabéns pelo ótimo trabalho.
Muito obrigada Muzio!
Thank you !!!
You're welcome!
Awesome!! Thank you!!
You‘re welcome Steve! Check out my Google Apps Script online course I‘ll soon be launching: courses.saperis.io
Greetings, Chanel
Thank you! Will you have a tutorial on workflow with Google forms using App Script in the future?👍
Hi Toria. Maybe. What exactly would you be interested in learning? Greetings, Chanel
@@saperis Workflow and automation with Google Forms. A script like formsapproval. I don't know if my company would like to integrate a third-party add-on on our Gsuite, hence, Looking at using App Scripts for this.
Hi, do you have a tutorial on how to do a dependent dropdown for a whole sheet using App Script?
Hi Leah. No, I don't have such a tutorial video. 😒
Great Video Saperis. How would I build an Array using your example? In your example you log out just each row. So we each loop you loose the last row. How would I build an Array, row by row to show the complete array of all the rows? So, as it loops it adds the next row to the last one until you have a complete array.
I have an XML response that I am trying to first load into an array then write in one hit to the sheet. I am currently using .appendRow within my loop which is really, really sloooooooow.
Its ok Chanel I manged to sort it. I needed to use .push([])
Hi there. Yes, with the push method you add a new item to the end of an existing array.
How to use Conditional Formatting with Google App Script? Please make a video on this topic!
Thank you for the idea. I might actually do so in the future.
@@saperis I am waiting ...
I would say to choose for() if you need to have a condition different of the array lenght.
Sure, that's a good choice.