Відео

If u refresh the form does it work? It may take a few seconds for it to reflect.

@@SheetSmarts no I tried that

@BucketList60 hmm… so the sheet numbers (current enrolment ) are updated but the form choices are not updated everytime a form is submitted ?

Exactly. I tried a sample exactly the way you did in the video with capacity of 1. It logged the one on the response master form but didn’t take it off the form the next time I went to fill in the form. I tried it a couple times step by step through the video. So I feel like there’s a glitch somewhere. I’ve deleted the sheet and may try again with a fresh download.

Ok can u check what type of question do you have , multiple choice or dropdown? See if selecting the correct type of question in settings sheet solves the problem . I tried to replicate the issue and if my question is drop down but i put multiple choice in the settings sheet then the option will not be removed when full capacity .

Hi, I have put the code in a spreadsheet so it’s easier to do the duplication. Go to ko-fi.com/s/e48c3f832e to get the spreadsheet

Hey there, yes it should work with any type of responses. Do check if all steps followed and all the google permissions given.

Thank you for your concern! The Google prompt about sharing sensitive info is standard for all Google Apps Scripts to ensure users are aware of potential data access. Rest assured, my script doesn’t share sensitive information. For your peace of mind, it’s always good to verify scripts yourself. Check out my other video, “Check Google Scripts Safety with ChatGPT - Easy Guide,” where I show how to evaluate the safety of Google Scripts using ChatGPT: ua-cam.com/video/aWb2us_LW3c/v-deo.htmlfeature=shared. Thanks for watching!

Hi, to see code click on extensions on the menu and press apps script

He is asking for code which you mentioned after removing my functions in apps script..

@@caankur89 Ah yes, i should have made it clearer as instead of pasting the code, i have created a spreadsheet template (the code is inside the sheet) with a button. So just click the button and follow along.

Hi, can u contact me to provide more details. Check my channel for contact details.

Pls try this - To change the timezone in Google Sheets: 1. Open the Google Sheet. 2. Go to File > settings. 3. In the Settings window, adjust the Time zone to your timezone. 4. Click Save settings.

Hi there , yes that can be done , I’ll look into that and put up a video when ready .

Ah good idea , so what i can do is to also create url links to all the folders created. If that is what u want, I will update the template

@nevecariaga6485 I have updated the template , now after creating the folders, the name of the folders u put in the template will become clickable and lead to the folders . Please go back to the link in the video description to get an updated copy of the template .

Glad it was helpful!

Glad it helped! Checkboxes - a bit challenging as a user may choose more than 1 so it needs additional logic to process it. I will look into that and if it can be done without issues then I will reply here and update the template

In the script change to .atHour(5)

Please check the chat ID, ensure the bot has permissions in the group, reinstall the trigger and verify the bot’s API token in the ‘Settings’ sheet.

Is there a way to combine this template with another template from the tutorial "Sort / Group Form Responses into Separate Sheets Automatically in Real Time!"

Is this template also available for Checkboxes

if u wanna reset the limit , u can simply backup the old responses into excel and delete the responses in the responses sheet . And to clean up clear the numbers in the “current enrolment” cells

Yes, PM me via my contact form .

For checkboxes , it doesn’t work using this template due to the way checkboxes responses are stored in Google but good idea though. I’ll mull over that

Great to hear!

Hi! Could u take a look at this and give it a try ua-cam.com/video/Ig7A7uObuVU/v-deo.htmlfeature=shared

@@SheetSmarts but that's not i wanted. I mean that can we insert file (image type e.g. jpg) from harddisk to google slide? Not from Google Forms. Thanks man

Ok got it . If u are using Google slides, the pictures will need to be in a Google drive instead of ur hard drive. If in Google Drive, then yes it’s possible & thanks for ur suggestion . I will do a video tutorial on that soon. However inserting 100s of pictures may risk the dreaded 6 min “timeout” issue. Will see how we can overcome that.

@@farera182 I've just released a video on how to insert pictures from google drive to google slides in bulk! Check it out: ua-cam.com/video/QHqBes3yYjQ/v-deo.html . Let me know if it works out for you.😃

@@SheetSmarts Hi sir! Is it possible to automate slides having both text and image in a slide?

Hi! Currently only 1 range . Let me take a look later, will update u if i make any changes .

Hey there, I have updated the file to be able to include multiple range protect and unprotect. Could u give grab the file from the link again to give it a try and lemme know if it works well for you.

Try refresh the sheet, the menu should come out

@@SheetSmarts i did that ,not helping

@manish_sarswat_iiitg can u try my other videos that have menu, see if for other templates, can the menu appear for u?

@@SheetSmarts ok i'll try that ,ty

Hey there sorry that it’s not working for you. The template - can u double check , see if the entries are correct. And u have given the permissions as in video . There’s quite a few steps for the set up, so do check again.

It's working. And I have a question. Is there any limit for the number of messages receiving inside our Telegram group?

No limits :)

Thank you it's working.

Hi, can you make a video on an easy way to create a Telegram bot for schools and colleges for automation? Example: If students search for old question papers, the PDF file will be downloded....

Hey there, this formula works with excel too . But for my other videos they only work with google sheets etc.

Hi hi there have u gotten the link from Ko-fi and made a copy of the template yet? U Need to fill up the cells as in the video. Then press the “Click to Start” button

Thanks a lot for this, works perfectly!

Sorry this only works in googlesheets. Check the video for step by step instructions okie.

@@SheetSmarts 😞😞😞

Need to press the button. Check out again and follow the tutorial , let me know if it worked out for u

Didn't get that button

@com.art.5940 hmm I’m not sure why the button didn’t load for u. Did u use ur laptop browser? Also Try use Chrome browser. When u go to the link as in the video , u need to make a copy of the file. The spreadsheet will load and u should be able to see a rectangular “button” that says “Click to Start”

Nothing happened 😢😢😢

Sorry that happened . I tried and it’s ok so far.

Check description ya 👍

Ah I get what u mean, so if a user chose a,b,c , it creates 3 sheets named a,b and c . Yes it should be possible . Will look into it.

@@SheetSmarts thank you !

Hi @MadShearz, i have created a video based on your suggestion - check it out ua-cam.com/video/CxOybQdZZcM/v-deo.htmlfeature=shared

@@SheetSmarts thank you so much ! I will try this and let you know !