Видео

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 ruclips.net/video/Ig7A7uObuVU/видео.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: ruclips.net/video/QHqBes3yYjQ/видео.html . Let me know if it works out for you.😃

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 ruclips.net/video/CxOybQdZZcM/видео.htmlfeature=shared

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

Hi, you'll need to modify the code to remove the places that has "ui alert". Can i check why you prefer to disable the confirmation?

Technically it’s possible with some adjustments to the code. How many questions are u looking at?

Hi, i have added multi-qn capabilities ( up to 5 qns). Get it again from same link.

You've done a great job! It's working excellently.... 👍🏻

Glad it helped

Hey there , no I don’t have , thanks for ur suggestion

Yes! I have now updated the template so you can input the folder ID and it will process all the spreadsheets in the folder. Please go to the link in the video description to get the latest template. Let me know if it works for you.

Yeah, you are the best 🥹 Give me your paypal i will donate