range should be dynamic and use headers[0].length. also who wants to fill a 2D array manually? Just use [headers] in setValues
@markfernandomaligmat698
Жыл бұрын
LoL I think it's easy to just write the header. But it's cool though.
@jessepinkeye2339
Ай бұрын
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.
@andreaguerri.educational
5 ай бұрын
very cool, brava👏👏👏👏🤩...but you can a typewriter effect? I understand who you are from your voice (beautifull)
@DaimtoAps
4 ай бұрын
I have a script that types it for me.
@rexated5148
9 ай бұрын
How did you call your function from the sheets screen? Did you need to select a cell, then write “=createHeader()”, then press enter?
@DaimtoAps
9 ай бұрын
I normally do it when a new sheet is created but you could create a menu item or a button
@man49231
11 ай бұрын
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
@DaimtoAps
10 ай бұрын
Sounds like an interesting idea im not sure if its possible though.
@ontolandianamaec.6145
7 ай бұрын
How to create this? Where do i input this to create a header?
@see9981
11 ай бұрын
Hi How to save From 1 Sheet Data to other sheet with matching dates.
@DaimtoAps
11 ай бұрын
you should be able to create two deferent objects
@thatveganpest
9 ай бұрын
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?
@DaimtoAps
9 ай бұрын
Hmm strange which quote exactly?
@thatveganpest
8 ай бұрын
@@DaimtoAps CalendarApp
@thatveganpest
8 ай бұрын
Do you know what might of happened?, i was making events every 30 seconds but that should still be fine
@hexprince
Жыл бұрын
That's awesome 👍 ❤
@arpa1520
9 ай бұрын
GOOD VIDEO, IS IT POSSIBLE TO GET INFORMATION OF A HTML FILE IN GOOGLE DRIVE AND CREATE A NEW REGISTER TO GOOGLE SHEET??????
@DaimtoAps
9 ай бұрын
Depends on what information you want from the HTML file
@arpa1520
9 ай бұрын
@@DaimtoAps some text
@edhahaz
8 ай бұрын
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.
@arpa1520
8 ай бұрын
@@edhahaz if you have some video like that, let me know
Пікірлер: 26