This code is very short and sweet thank you. The only thing I had to change in the script was to write "form" in lowercase instead of "Form", and it all worked smoothly.
So glad this was helpful! You can right-click on any single column or row number (e.g. the part where it says A,B,C etc. or 1,2,3, etc) and delete that single row or you can select multiple rows or columns and do the same thing. So for example if you want to delete all the rows after row 30, you can click on "31", scroll down, hold down Shift and then click on "1000", right-click and select "Delete 969 rows"
I just made a new version of this video using an onEdit script, which makes this functionality available for mobile phones or tablets: ruclips.net/video/K5uOSI5i8ME/видео.html
You need to make sure the tab name matches between the Google Sheet and the script (sometimes a blank space at the beginning of end of a tab name can throw you off in the script)
It gets easier! You can make a copy of the final project and play around with it to learn more, and if you break it, you can go back to the original again. 😉
You can duplicate the form entry tab and have a separate tab for each user. Then in the script you can just use an or statement for the tab name. E.g. If ((tabName == 'Form 1' || tabName == 'Form 2' || tabName == 'Form 3') && val == 'Submit')
It sounds like you might need to update the range where the script is getting the data. If it's saying the last one is null then the script is likely not getting any data. If your "FORM" tab looks different than the FORM tab in the template, you will want to modify the range where it's getting the data. That is this line: let data = form.getRange(5,5,form.getLastRow()-4,1).getValues().flat(); This assumes that the data entry is starting in E5. If you are starting in B2, then you would need to modify to: let data = form.getRange(2,2,form.getLastRow()-1,1).getValues().flat();
This code is very short and sweet thank you. The only thing I had to change in the script was to write "form" in lowercase instead of "Form", and it all worked smoothly.
Awesome, thanks for sharing!
ang because of this i love yooooooooooo but may i ask how did you do it or you just hide the rest of the column and rows that aren't use?
So glad this was helpful! You can right-click on any single column or row number (e.g. the part where it says A,B,C etc. or 1,2,3, etc) and delete that single row or you can select multiple rows or columns and do the same thing.
So for example if you want to delete all the rows after row 30, you can click on "31", scroll down, hold down Shift and then click on "1000", right-click and select "Delete 969 rows"
Thanks for your great tutorial! It's really helpful! By the way it doesn't work on Android phones, right? What can we do for Android phones?
I just made a new version of this video using an onEdit script, which makes this functionality available for mobile phones or tablets: ruclips.net/video/K5uOSI5i8ME/видео.html
This was a great tutorial, I used the same script but i keep getting an error message that says "Form not defined"
You need to make sure the tab name matches between the Google Sheet and the script (sometimes a blank space at the beginning of end of a tab name can throw you off in the script)
OMG FINALLY ❤THIS IS EXACTLY WHAT I WAS LOOKING FOR. ✨🙏 THANK YOU
Awesome, glad I was able to help! I love the simple solutions.
My head hurts from trying to understand but thank you for this.
It gets easier! You can make a copy of the final project and play around with it to learn more, and if you break it, you can go back to the original again. 😉
do you have a video about data entry that can also retrieve the data and update it on the same field? like the excel forms?
btw, your codes are the very short and easy to understand. thanks! ^_^
I just recorded a part 2 for this video that includes save/update/retrieve/delete functionality. ruclips.net/video/hZSP1C1RWtM/видео.html
Is there a way that multiple users can use the form simultaneously without interfering with each other?
You can duplicate the form entry tab and have a separate tab for each user. Then in the script you can just use an or statement for the tab name.
E.g.
If ((tabName == 'Form 1' || tabName == 'Form 2' || tabName == 'Form 3') && val == 'Submit')
Thank you so much. One last question, is there a way to make it able to submit without having all cells filled in?
@@dcjohnson7615 Currently there is no restriction on cells having to be filled in to submit the form, so it will work as is.
very short and efficient code thankyou
Glad it was helpful!
hey i get the exception that my parameters for the getrange function are (number,number,number,null)
It sounds like you might need to update the range where the script is getting the data. If it's saying the last one is null then the script is likely not getting any data. If your "FORM" tab looks different than the FORM tab in the template, you will want to modify the range where it's getting the data. That is this line:
let data = form.getRange(5,5,form.getLastRow()-4,1).getValues().flat();
This assumes that the data entry is starting in E5. If you are starting in B2, then you would need to modify to:
let data = form.getRange(2,2,form.getLastRow()-1,1).getValues().flat();