Yes, but this is perfect if you want to automate dozens of sheets. I've used this for my client's team spreadsheet for his football clinic . At the click of a button it automatically creates a new team sheet, assigned teams based on their age and whatnots, then rename the sheets based on their names. Manually inputting the header that has A to R columns every newly created sheet can be tedious.
Hi! I have made a CSV Importer that lets users drag and drop CSV files onto the Google Sheet from their device. I am trying to add another functionality that is the moment they drop the CSV file, allowing them to select which columns to import. Could you please help me out. thanks
It's possible to load files from GDrive and it's possible to parse HTML, even from a website. It's also possible to make your own HTML elements and get data out of it.
How did you call your function from the sheets screen? Did you need to select a cell, then write “=createHeader()”, then press enter?
I normally do it when a new sheet is created but you could create a menu item or a button
LoL I think it's easy to just write the header. But it's cool though.
Yes, but this is perfect if you want to automate dozens of sheets. I've used this for my client's team spreadsheet for his football clinic . At the click of a button it automatically creates a new team sheet, assigned teams based on their age and whatnots, then rename the sheets based on their names.
Manually inputting the header that has A to R columns every newly created sheet can be tedious.
How to create this? Where do i input this to create a header?
Hi! I have made a CSV Importer that lets users drag and drop CSV files onto the Google Sheet from their device. I am trying to add another functionality that is the moment they drop the CSV file, allowing them to select which columns to import. Could you please help me out. thanks
Sounds like an interesting idea im not sure if its possible though.
very cool, brava👏👏👏👏🤩...but you can a typewriter effect? I understand who you are from your voice (beautifull)
I have a script that types it for me.
I noticed it’s been saying I have hit my quota creating a calendar event even though I have not, have you had this issue?
Hmm strange which quote exactly?
@@DaimtoAps CalendarApp
Do you know what might of happened?, i was making events every 30 seconds but that should still be fine
GOOD VIDEO, IS IT POSSIBLE TO GET INFORMATION OF A HTML FILE IN GOOGLE DRIVE AND CREATE A NEW REGISTER TO GOOGLE SHEET??????
Depends on what information you want from the HTML file
@@DaimtoAps some text
It's possible to load files from GDrive and it's possible to parse HTML, even from a website. It's also possible to make your own HTML elements and get data out of it.
@@edhahaz if you have some video like that, let me know
Hi How to save From 1 Sheet Data to other sheet with matching dates.
you should be able to create two deferent objects
That's awesome 👍 ❤
range should be dynamic and use headers[0].length. also who wants to fill a 2D array manually? Just use [headers] in setValues
👍
But what is case it use for?
I have a report generator
Lol, Manually we build header faster , simpler way... 🤦why you are using app script (complex method)
The data was coming from an api in my case