its crazy how the developers dont know how to make the process more simple. This is too much trouble to go through for a basic button. either way excellent explanation. thanks.
It might look like it is a lot of trouble, but this is actually quite powerful. Anyone can follow this 5 min video, and you can then use this knowledge to build more complex systems.
Here you are assigning to the fixed page, but I want to give the reference to the specific cell. How can I do that? For instance, I have 100 pages, I will put list of pages to the cell A1, (it will be drop down list) after that if you click the button it will take you to the page that is shown on A1 cell ?
I wanted to get to any sheet. Used Insert...Link...Sheets and named ranges... selected sheet I wanted .. enter. You get a cell with the sheet you want to go to. Click on cell and choose cell name . done. No scripts No Drawing buttons However you do not get a button displayed, just a cell. Hope this helps someone
@@paleteriaelpibe7035 Good question. It's clickable, but needs 2 clicks (one on the cell, another on the link that appears nearby). Maybe not so straightforward for users of our sheets, but helpful anyway.
Hi Lorvha. This is a late reply hope it is still useful. This script will open a dialogue box and ask for the cell reference you enter it and then click OK function goToCell() { var strRange = Browser.inputBox("Insert the required cell (e.g.: B20):", Browser.Buttons.OK_CANCEL); SpreadsheetApp.getActiveSheet().getRange(strRange).activate(); }
I am getting this message when I click the button A script attached to this document needs your permission to run. And its asking me to sign into the account I'm already signed into.
It is normal. You are not signing in into your account, you are authenticating that you trust the script you just created. After trusting it and giving it permission to run on this spreadsheet, it won't prompt this anymore.
its crazy how the developers dont know how to make the process more simple. This is too much trouble to go through for a basic button. either way excellent explanation. thanks.
It might look like it is a lot of trouble, but this is actually quite powerful. Anyone can follow this 5 min video, and you can then use this knowledge to build more complex systems.
function P1() {
// 1 = row 1, 14 = column 14 = N
goToSheet("DashBoard",47,1)
}
function goToSheet(sheetName, row, col) {
var sheet= SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row,col)
SpreadsheetApp.setActiveRange(range);
}
Here you are assigning to the fixed page, but I want to give the reference to the specific cell. How can I do that? For instance, I have 100 pages, I will put list of pages to the cell A1, (it will be drop down list) after that if you click the button it will take you to the page that is shown on A1 cell ?
Thanks Mate
Thank you very much for the script. It helps me a lot.
Glad to hear that
Thank you. "Just what the doctor ordered," as they say. Cheers.
i was looking for it!!!!!
its very helpful, thanks
You're welcome!
Thanks for this! Is there a way that one button can open multiple sheets not just one?
Not that I know of
I really want to thank you for sharing your wonderful ideas on this, it is very useful for my project, again a big thanks.
Nice job...no need of repeating the functions(gotosheet function), one function will serve all the buttons😂😂
Just call it and assign thr parameters
Thanks for the tips!
Very Helpful - but I couldnt' get a copy of coding you display. That would be very handy for all.
thank you
Just what i wanted !!!
Thanks :)
Glad to hear that!
I wanted to get to any sheet. Used Insert...Link...Sheets and named ranges... selected sheet I wanted .. enter.
You get a cell with the sheet you want to go to. Click on cell and choose cell name . done.
No scripts
No Drawing buttons
However you do not get a button displayed, just a cell.
Hope this helps someone
Greaet idea. Do you know how to make it clickable?
Excellent idea! Thanks for sharing!
@@paleteriaelpibe7035 Good question. It's clickable, but needs 2 clicks (one on the cell, another on the link that appears nearby). Maybe not so straightforward for users of our sheets, but helpful anyway.
how can i a button for "Go to specific Ceell"? Example Cell: G1:L1
Thank you very much for answer
Hi Lorvha. This is a late reply hope it is still useful. This script will open a dialogue box and ask for the cell reference you enter it and then click OK
function goToCell()
{
var strRange = Browser.inputBox("Insert the required cell (e.g.: B20):", Browser.Buttons.OK_CANCEL);
SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
}
@@EdgeOfYesterday it's not working
it was really helpful. thank you
Glad it helped!
My tool doesn't have script editor function, what can I fix that?
Google changed its location, it is on "Extensions -> Apps Script" now.
ThankYou Mate
You're welcome!
tks alot brother....i am from manokwari papua
Welcome 👍
Thank you so much GOD bless
You are so welcome
Great Job
thank you
Thank you
welcome
I am getting this message when I click the button A script attached to this document needs your permission to run. And its asking me to sign into the account I'm already signed into.
It is normal. You are not signing in into your account, you are authenticating that you trust the script you just created. After trusting it and giving it permission to run on this spreadsheet, it won't prompt this anymore.
GOOD job
but dosent work on mobile (androïde & ios)
if it is made like that, can the hidden sheet be accessed?
no
Thanks
Welcome
thank you for this.
You're very welcome!
Hey please help me out my script is running but not able to go to particular sheet
use my script
hello thank you for this video, but it is giving me an error (scripts cannot convert 'comments' to int.)
CAN WE CREATE PRINT BUTTON ?
Please share the code.
como se puede hacer un boton para imprimir en google sheets
Button Script link not working
I want to send mail according to the customer mail ID not specific mail ID so how we add mail ID cell in script
"Exception: Invalid argument: sheet"
Not working bro....
what happened there?
I want to send mail according to customer mail ID
Thank you.
You're welcome!