Video

Hi, I have a question about this topic. The same formula referencing the same sheet works in some sheets, but in other sheets, it doesn't. All of the sheets are mine, some are shared with other accounts and others are only mine, but again, no rule, in some works and in some doesn't.

Hello! Great video! Do you have any sugestion for the case where the original file was an exel file? For the past year I that file only using sheets. Now I want to use the importrange in another G sheet, but the original is an exel. What do you recommend?

For some reason the old value and new value code is not working on my end. All I can see is undefined and the new value. May I know what is the reason for this?

I'm having a problem that every hour I have to allow access and not only one time, do you know anything about?

Thank you. I was looking to sort on a query and was stuck. This helped. Thanks a lot

Hi, thank you for your tutorial. I already follow exact like you did, but I have an error, always like thank. the error note is TypeError: Cannot read properties of undefined (reading 'response') at getEditorLink(Code:6:21), could you help for it?

thank you very well explain exactly what I needed!

wowow Great!

Please creat a follow up, changing the feilds and collecting data and changing title of sheet

Thanks for such a wonderful video, one query,how to use more than one filter, as you have used Japan using "where'

This was very helpful, unlike many other videos on this topic. I am struggling with "deselecting" the items i have already selected. I tried "else activeCell.setValue(oldValue-newValue)", I also tried a few indexof options, but i couldn't manage it. Would you be so kind and help me on this matter? :)

Thanks🎉

Do you have a part 2 of this?

Is anyone else experiencing issues with copying? Whenever I try and copy a cell or drag the same value that includes multiple values in it, it reverts to blank..

why other cells are not working once l put a ref they don't automate product l have that error in two cells

thank you for your videos

Hello sir, Thanks for the video. I have Question! it looks like we can only edit it for a new response. What about the hundreds of responses that have been submitted before this script was used? I want to edit the past responses, because if I create a new one and input it manually again it takes a lot of time, because my responses have exceeded 100. is there a solution for that? so that the graphs and answers on the G-Form are no longer error or defective because they do not match the sheet?

Hello, How are you? Thank you for your videos and the effort you put behind them. However, at 4:54, you talked of sharing the link on the automatic way of updating the Google form once you input data in the sheet. You mentioned including the link in the description, which I can't find. Could you have forgotten to include it or if it doesn't bother you, kindly share it as a reply to this comment. Thanks!

Is there a way to only have the categorized sheets and not the master responses sheet or is the only option to hide it?

I hate that it is 2024 and this highly demanded feature is not built into Google Sheets.

This should be a built in feature.

thank God for your video!! finally figured out why i cant get access to the sheet i basically own lol! keep it up!

I am having problem in dragging down my formular becuase its from different sheets and in the formula it has numbers of the sheets so when I drag down it reflects just the formula of the first sheet it doesn't change the different sheets

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

thank you so much! super helpful.

Hi! Thank you for your time to share a so informative video. I'm new in this type of scripting and google sheeting-forming so to say. 🙂 I have a question: is it possible to make a form and a sheet but not link them together like you show in the video, but still to submit the data from the form to a specific sheet with a script? Or a form must be every time be linked first to its sheet and then can I use a script for data validation or whatever?

Is there an example video of you using it? I started skipping through Part 1 and would just like to see you scan the QR code and register the purchase. Because I'm unsure if this is what I'm looking for and it would be unfortunate if I follow these tutorials, just to find out this is not what I'm looking for.

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

I followed your instruction. I am still getting stuck at 11:56. I spend 5 hours to figure out how to do QR code. It is not easy.

@practicalsheet I have did same but when I delete some rows from input data then it's gets deleted from importantrange sheet as well, I want once data import from input sheet it should be paste value and if new data entered in input sheet then also added in importrange sheet as values only

Error The data validation rule has more items than the limit of 500. Use the "List from a range" criteria instead.

Hi, Could you please check my previous comment i made on one of your video

Hi, would it be possible for you to help me regarding a project that i am doing? i could talk to you more about this on Instagram or something like that and it would be really helpful if you could help! Many Thanks

I'm getting the following error and not sure why it's not working. Any ideas on how to fix? TypeError: e.response.getEditResponseURL is not a function at getEditLink(Code:6:30)

+1 sub

So, is there a solution to uploaded sheets to work with the importrange now?

super helpful for a beginner, thanks for taking the time to share!

What about a confirmation dialog or popup on mobile? Does that work?

Hi! I was wondering, can you still create graphs like this? So for example: Sector x Focus Area [Multiple Dropdown]

Thanks a lot boss, please help me with the template

I am getting the error "TypeError: ListValue.toString(...).IndexOf is not a function" Any suggestions?

🎯 Key points for quick navigation: 00:00 *📝 Introduction to CSV files* - CSV is a text file representing a table with elements separated by commas. - CSV files are lightweight and useful for data transfer between software. - Understanding CSV basics is crucial before importing into Google Sheets. 04:30 *📊 How to import CSV into Google Sheets* - Two main methods to import CSV into Google Sheets: uploading directly or using the "Import" function. - Various options available during the import process, like replacing, appending, or inserting the CSV data. - Understanding how Google Sheets handles CSV data alignment and data types upon import. 07:57 *🔄 Automating CSV import using Google Apps Script* - Exploring the concept of automating CSV imports at specific times. - Creating a script to automatically import CSV data into Google Sheets. - Customizing the script for specific needs, like appending data or creating new sheets. 25:49 *📁 Automating CSV Compilation Process* - Demonstrates the ability to compile multiple CSV files into one folder automatically. 26:19 *🔄 Modifying Existing Sheets* - Explains how to import data into an existing sheet instead of inserting a new sheet. - Highlights the option to replace existing data or append new data carefully in Google Sheets. 27:27 *📋 Implementing Automation Methods* - Shows how to create a menu for easy access to importing CSV data in Google Sheets. - Introduces setting up triggers to automate the import process on a daily basis. - Discusses the benefits and considerations of manual versus automatic import options based on the project's specific needs. Made with HARPA AI

dataSS variable wins for me this time. xD Thanks for the tutorial! Will try to add this code to the others in one script.

I've been searching for a similar tutorial on clothing inventory for a very long time. This is exactly what I needed, thank you so so much!

Super useful! If I want this to work alongside with the ID Ref script what should I do? Tried copying ID REF code to be before Categorize Code, but could make it work; I changed column values to be +1 and to try to copy the last column but couldn't make it. Even if it's not possible this still works a lot!

Hi! Can I ask a question? I want to add description when created as event. but the description is in for different cells. How can I compile and modify it in the description of the event. Please help me.

Hello, do I duplicate the code if I also want to create a multi-select for the student column (column 1 in this tutorial)? Because I tried it and I got the student column to work but then the hobbies column stopped working. Can you do a part 2 please to show up how to setup another column in the same 'main' sheet.

Great work. I wish I had the time to watch all your videos just to learn something from these very interesting features. However, as I am doing this only for my own interest and not for business, hopefully, I'll get to do it in the future and become a Patreon. Keep up the good work. May I contact you to ask for customized projects in future?

Spot on, gracius