IssueTracker

In your example, you would be happy if a shortcut can trigger a script much in the same way as you would trigger from the editor. The reason I ask is that there differences on how you execute the script.

I have VBA macros written for some common tasks such as highlight a cell with a color yellow. I will have a macro called highlightYellow and will map it to Ctrl-Y. So, when I have to highlight some cells yellow, I select and press ctrl-y. This helps me save time and repeat this often.

duplicate of issue 36752293?

It would be useful to be able to consume a sequence of keystrokes in the manner Vi and Emacs do. With JavaScript syntax, it would be easy for people to create many commands. I can't imagine doing it in VBA.

would be great

I like the suggestion in #6. Would like to see a sequence of keystrokes ala Emacs if that is possible.

Working with a Mac with Parallels, so switching between Windows and OSX constantly.  I want a way to map some of the basic windows keyboard shortcuts to Google Docs under Chrome running under OSX, and even though I can do so for Chrome as a browser using OSX keyboard shortcuts, I can't for Google Docs.  I was hoping this would at least provide a way to do it, either by A) exposing keypress events or B) allowing a shortcut key sequence to be defined for a menu item, then I would code that menu item to execute the desired function.

Looking for, at a minimum, the Ctrl-Z shortcut.

Ref: Comment #6. I too would love to see vi like commands in the AppScript.

I would love even just a simple CTRL+key. Multiple keystroke might be developed later, or build over the simple mechanism at application layer.

I'm also interested in this feature -- and would like to see it available for other document types.  Example: a "smart" screenplay editor that auto-formats a paragraph based on a keyboard shortcut.

I like Content Assist function, But Ctrl+Space is used to switch input methods in Chinese system which cant't change in Chromebook. Also some other system keystroke maybe occupied that key.

Have just done the google mail snooze mini-tutorial and now would love to have a keyboard shortcut I can press to "snooze" emails to 7 days, rather than the "select Move-to label, type, select correct label, press enter dance":  http://gmailblog.blogspot.co.uk/2011/07/gmail-snooze-with-apps-script.html

Docs doesn't have keyboard shortcut to insert equation. Reaching out for mouse everytime when writing technical documents is a major pain. If this feature was available, users would have solved the problem themselves without waiting on the team.

This is necessary to develop serious add-ons!

please! app script googlers, make this feature available at least thru Chrome if nothing else.

Unassigning

I would love this feature. I have some large spreadsheets with various scripts. Everything would be much more easy if I can access those scripts via shortcuts. !

This seems like a no brainer, being able to use custom keyboard shortcuts with scripts would be fantastic - and frankly, is almost a requirement for quickly accessing various scripts.  Not being able to do this is a major down side to google scripts.  This needs to be added.

Google, please add such needed feature!

Please add this feature.  In the mean time, if anyone knows of a workaround, please post it here. Tamper monkey?

This is highly needed... it would double the value of the scripts at least

Scripting in google docs without keyboard shortcuts is very poor compared with what Microsoft enables. It is very strange that for 3 years Google guys did nothing to enable such obvious and used-everywhere feature

Great idea to add such a convenient feature. It would indeed help us to be more productive.
I have a little hack though. You can create a custom menu for triggering macros, and then using ALT+H and arrows you can manage to trigger them using your keyboard.

This feature would be highly useful.

As a workaround I think you can create a menu option and then use a Chrome Extension such as Vivium to assign a shortcut to press the menu option.

Yup... would be really nice.

I guess we must be close to seing this. With every new version, Google SpreadSheet shortens the gap with Excel.

Keep up the good work.

If manually clicking an Add-on sidebar button doesn't suffice, wouldn't using a local / desktop scripting program ( like AutoHotKey ) that listens for key combos and clicks that Add-on button work well enough? I'd prefer to see custom key combo assignment come to ChromeOS before the Apps Script team spends time engineering it for just Sheets.

In addition, the new IFRAME mode in HtmlService does allow for key codes to be passed on to Add-ons...

$(document).keydown(function(e){
  //CTRL + V keydown combo
  if(e.ctrlKey && e.keyCode == 86){
    $( '#output' ).html("I've been pressed!");
  }
})

Have to click on / activate the sidebar first for that to happen.

@#33, doesn't that only bind the keyboard shortcut to the sidebar? So the user still has to click the sidebar to be able to activate the keyboard shortcut, right? How are you defining "document" in $(document) such that it applies anywhere on the page or text?

@34, yeah sidebar would listen for keyboard only when active. exposing an onKeyDown() simple trigger that the entire active Doc or Sheet listens for i think is still the main request

perhaps this could be a type of trigger. keyboard shortcuts such as CTRL or ALT to run a script or menu item.

another idea.
triggers like on open and on edit... could add a trigger like onkeystroke(ctrl-z)
or something like that.

 I just spent two years convincing my office to switch to Google Docs.   I have a guy that just jump back to Word because I can't create a custom keyboard shortcut.   This is completely unacceptable.  I'm putting myself out there for you, how about you do the same for me.

#39, have you looked at LaTex?

#39, have you looked at the Auto-Latex Equations add-on for Google Docs? https://chrome.google.com/webstore/detail/auto-latex-equations/iaainhiejkciadlhlodaajgbffkebdog?utm_source=codegoogle might help solve your problem.

Is going to be implemented by Google? I'm really interested on this functionality

I tried the "Shortcut Manager" add-on to Chrome to try to trigger an action while in google doc thinking I would then trigger a custom script.  This works fine in several browser windows but when I open a google doc it seems to get blocked just when I want it.  

I can't for the life of me think why more people haven't requested the functionality discussed in this thread.  It seems to me a very basic requirement of any reasonably sophisticated program to offer keyboard shortcuts.  

Scripts is crippled without this.

WAKE UP GOOGLE! Come on, I told my boss "sure, it should be possible". Why not?:
function onOpen(e) {
   SpreadsheetApp.getUi()
       .createMenu('My Menu')
       .addItem('My Menu Item', 'myFunction', 'myKeyboardShortcut')
}
I don't think that is hard to implement, there might be something behind that.. security issues? don't think so.. At least explain why you don't implement it..

In particular, I'd like to be able to define short-cut keys to do special characters like a non-breaking space etc.  Microsoft does this well.

[Comment deleted]

Please add, how has this not been added already... please add the other company we work with refuses to use excel and I have to suffer through this crap

This is a crippling missing feature.

yes please

There should be an OpenSource alternative for docs, spreadsheet, etc.. and we'd all be pleased.. sorry Google. The same way I change from JS Maps Api to Leaflet js... Anyone knows some? I know it is not so 'correct' to say it in this forum.. well. I like Google tools, but some times they are too close..

Yes, there are OpenSource alternatives: OpenOffice and LibreOffice come to mind.

but, do they offer the GREAT feature of editing the same document at the same time through the internet?? I think this is why most people choose it, at least that is why I do...

great, thanks! the only problem is that I use Ubuntu 14.04 LTS .. =S I hope it works with 16.04 LTS, I may upgrade.

This came ware on Kendra Barker phone

ZOMG ADD THIS FEATURE PLEASE LAZORS!!!!

Thanks!

I'd definitely use this.  There are a number of these I used in Excel.  I'm 90% transitioned from Excel, save features such as this one.

How has this not been added more than 6 years later...?

So pathetic. Google is the new, crappier Microsoft.

Whilst it is not a fix - it is a "workable" alternative - CTRL+ALT+H opens the Help menu - press the right arrow to get to the Add-Ons menu then down arrow to the menu item I want to use.

@snels Honestly, that's not a bad solution because it could be mapped to a keyboard macro (although frustrating for a novice user). Also, it's Alt+Shift+H or Alt+H

Programmable Keyboard hot keys for scripts would be fantastic. Otherwise, Programming in Docs is crippled.  

+1 for shortcuts for Google Apps Script function trigger.

7 years later, could we please have this implemented?

What they said ^^^

It staggers me that this feature has not been implemented yet. The ability to program functionality into google apps is an essential feature, but little extras like keyboard mapping to scripts, is what google scripting needs to jump into the truly "professional" category.

Google Apps Scripting is a ghetto.

Community should make an OpenSource alternative, could be LibreOffice community..

Off-topic, but it's the easy collaboration and commenting that keeps me in the Google Docs ecosystem.  Otherwise, I'd love to switch.

Please add this feature. What kind of IDE is that, which doesn't have a shortcut to run the script?

I added a custom menu with a few items and was wishing for this feature.

I've spent considerable time researching a solution to custom hotkeys with no success. Please support this feature.

This has been one of the main reason why I'm not fully vested in this platform with my firm yet, rewriting VBA to Google App Script is easy, but it is currently quite inconvenient to execute the code.

This would be wicked welcome! Thank you much!

Yes this would be a major improvement, and be much appreciated.

The lack of this feature has been seriously handicapping my productivity. I am trying to use Google Docs as a unified place to write onboarding guides for my organization, and I want to include code syntax highlighting. Currently the plugin I use requires me to click 4 times to accomplish a task that should be possible in one key shortcut.

Adding my voice, please add this feature!

Yes please. Just choosing a monospace font for some text, as one would want for code, requires selecting it from the menu. It can be easily done from a script, but to be convenient to access, we need to be able to specify shortcut keys for the scripts.

+1

I'd appreciate this function also. Please add my vote.

+1

+1

+1

Can we get a little inside why this is such a long standing issue, and why it is hard to implement? (Given the obvious usability and flexibility improvements, there must be serious implementational and architectural issues to wait this long, and i would love to get a glimpse into them.)

Anyone from google paying attention to this thread?  
Has there been an institutional decision to restrict extendability and programmability of Docs?
Lack of programmable hot-keys in Docs impairs the development of custom documentation applications.

Google. We need this.

+1

+1

+1

+1

Unstarred , because the issue has been around since Nov 2010!!!

Don't unstar it! That just tells google you don't care about this issue.

my gmail wont send or recieve mails

This is truly a must have.

There should be an easy straightforward way to add shortcuts for very menu item in a custom menu, beside adding shortcuts directly to script functions

It is a bit silly that in 2017 you cannot change shortcuts or assign your own to GAS functions within google sheets.

Like many others I am trying to make the move from Excel/VBA to google sheets/GAS but I am finding it very limiting and frustrating.

I see the status is accepted, does that mean an improvement is in the pipeline or has it been that way for the last 7+ years?

​​This might sound naive to more seasoned coders, but can't Google assign even just one sort of "master" key to invoke a macro player?

For example, a new type to trigger might be added, that responds to custom key combinations, that the coder would have already specified in Code.gs. These key combinations would not conflict with existing shortcuts because they can only be called after that master key, say, F7, is pressed.

After set up, the user would then hit F7, and Sheets would send a visual cue (a modal dialog box? something else?) that it will now expect a combination shortcut---Ctrl-H or Ctrl-Alt-F3 or whatever. And then the macro would run.

I'm making a suggestion because obviously Google has the resources and the expertise to implement our request. So what's stopping them? Perhaps restrictions brought about by browser standards outside their control? Or Javascript rules?

My point is, I'm open to not having the traditional approach of invoking the shortcut key directly, and instead placing it after a prefix of some sort. The "Alt" key already works in a similar fashion, after all. When you hit it on many systems, you are able to use single letters to call commands on the menu.

Just saying. Because this issue really limits my ability help my end users.

+1

Is there any way that Google will give feedback on this issue which is outstanding for many years now?  From the comments it is obviously an issue that is seriously required by a lot of people.

What about open an new issue, that google is not responding at this issue?
:-)

+1

+1

+1

+1

+1

+1

Obviously the various Google apps read the keystrokes, so even exposing a set of ten (say Alt-Shift-0 through Alt-Shift-9) to binding by script would be a help. Then a scripter could create a small set of individual scripts that could be invoked without taking the hands off the keyboard and moving to the mouse. A workable side-step would be an action recording (attached to a keystroke!) which replays some actions: something to play stored input.

Related to this feature is the concept of user space: a script can apply to a document or (if you have the right agreement with Google) a firm. It would be very helpful if a user could create a script that applies to their environment: then users could define a tool or script (such as "apply monospace to selected text or current element") and have it carry through to all their own documents.

These would go a great deal toward turning various Google docs from what I currently experience (great collaboration tools but poor writing tools) to something usable for collaboration and writing.

I speak for myself only. None of my statements should be attributed to or held against my employer.

+1

The lack of this functionality is killing me -- tedium, errors, etc. Going on 8 years now with no help at all!!!

+1 Would be great to have this feature.

Please please add this!

Has anyone ever heard from Google as to why they won't make this change?  Is GAS being left on the heap to die?  The scripting here is so limited in giving user feedback, it's ridiculous.  I wrote an app extension to Google Sheets and would love to add help text.  No events for hover, focus and no way to use a hotkey.  Google, you're missing the boat again.  AWS took the crown from you for hosting because they didn't snub PHP and other scripting languages.  When someone comes out with a decent, collaborative suite that isn't so elitist, you'll lose to them too.

People have been clamoring for this feature for 8 years.  What is the deal?

Do we have any updates on when it will be included?

still up?

The last week Google announced the launch of  Google Sheets Macros. See the guide on https://developers.google.com/apps-script/guides/sheets/macros

That's super! But it is mainly Google Docs that I was hoping to get the keyboard shortcuts in. Hopefully now that it's in Sheets, they'll add it to Docs.

Also it's a pretty limited set of keyboard shortcuts, requiring pressing three modifier keys, but it's still a welcome improvement and I'm glad they listened.

My thanks to Google! I have already put this to work, wha who!

May many more such improvements come soon so we can eventually do any keyboard mapping needed :).

At long last --- 10 customize-able slots for keyboard shortcuts!
(Never mind that each one takes almost all the fingers of one hand. )

Thanks Google... Even though it certainly *took* you long enough, hehehe.

As mentioned by others, Google Sheets launched Macros, which allow you to assign keyboard shortcuts to a macro. You can import an existing script function as a macro and assign it a shortcut. More information on the manifest fields that allow you to define these shortcuts manually is available here:

https://developers.google.com/apps-script/guides/sheets/macros#manifest_structure_for_macros

This is not fixed. It's only fixed in Sheets, not Docs. Docs is where I really wanted it. You can close the ticket when it's fixed in Docs.

@grantstreet you can follow this feature request:

"Feature request: map shortcut to script functions in Google Docs"

https://issuetracker.google.com/issues/79461369

Thanks

On Wed, May 9, 2018 at 10:52 AM, <buganizer-system@google.com> wrote:

--
*Lyle Kopnicky, **Perl Software Developer*

*Grant Street Group*Ph: (412) 391-5555, Ext. 6817

Yes, sheets has had this functionality for a long time.  How does one
assign hot key shortcuts to call custom scripts in DOCs?

On Wed, May 9, 2018 at 7:43 AM, <buganizer-system@google.com> wrote:

just as a disclaimer, I do somewhat understand the concept of macros; however, (and I'm not sure that this is related to this issue) what about creating a whole new shortcut with apps script to execute an insertion to a spreadsheet cell, specifically for checkboxes? How would this be done? or am I asking the wrong questions?

Authors need this capability for Docs, not just sheets. My issue is tweaking paragraph spacing in Docs, as I can with a macro in MS Word.

There is already support for some client-side events (big list of built-in keyboard shortcuts), so it's a matter of exposing that API and providing a way to attach one's own JavaScript code.

Or just add keyboard shortcuts for paragraph/line spacing the way there already are for embedded media in Docs.

Add to Docs as well please

Yeah, I'm not sure why this is closed.  Yes there is https://issuetracker.google.com/issues/79461369 but the OP did not specify Sheets or Docs, so until it's available on both, this issue shouldn't be marked "Fixed."

Docs!

OP responded in #3 with a description of using the feature in sheets: "...tasks such as highlight a cell with a color yellow".

Please add this capability to Docs. I specifically want to script the ability to create a style palette and add keyboard shortcuts for activating the palette and styling text with one of the styles in the palette. Right now there is only one format supported by a keyboard shortcut, and that is Normal Text. Many documents need several different forms of formatting - especially when creating documents with code snippets.

+1 for this to Docs, please :)

+1 for docs!

+1 for Google Docs.
Microsoft is winning this one for a lot of utilities. Docs is supposed to buffer the loss of functionality of highly copyrighted material by having publishable addons. I am writing this after discussing the need for a hotkey for a LaTeX add-on. I truly wish I could share this addon to get more users familiar with chrome, but they'll probably use firefox for this one!

+1 for hotkeys for a LaTeX add-on! Also great for highlighting code blocks.

+1 this is needed

+1 for Docs

+1 for Doc please!

Looks like option for Google Drive Right Click Menu is announced in Next 19. Waiting for this to be available for all developers.
https://youtu.be/6XCr60vRs2Y?t=66

+1 for Docs, please!

+1 for Docs

+1 for Docs

+ for Docs

+1

+1

Question: This issue is marked as "Fixed" as of May 9, 2018 09:42AM, and it clearly is tagged as applying to "Sheets" not Docs. Will all these +1 comments do anything to bring the feature to Docs? I don't think so. Based on the comment at May 9, 2018 12:51PM, go to https://issuetracker.google.com/issues/79461369.

+1

Google Macros is crap.
1) Very cumbersome to distribute Macro among all the spreadsheets (unlike Microsoft)
2) Keyboard shortcuts are restricted by 10 numbers and VERY unconvenient keys Ctrl+Alt+Shift
Google is crappy monopoly, does not care about users at all

+1 for Doc
...as working with text using keyboard → annoying by mouse twice click custom menu → and so many times

I hope to see this feature.

What I want to do and eventually find this page, is that I want to insert a Date/Timestamp quickly to my Docs.
Most people know it is trivial in Sheets, just Ctrl+; ( or some variants ) . That's viable long before Macro for Sheets.
And the real pain is, I think I did that with F5 25+ years ago when using notepad in Windows 3.1
That's the very first thing I try to do with vim scripting 20+ years ago....

And I remember I started a thread in good old days Google Groups long before this issue ( or the issuetracker .... ) exists.

So 13 years ago I did my own grease monkey  script and many other things.... that now I don't have time to do or to take care about.
And Google is so stubborn and aged.

+1 for me as well

+1

+1

+1

+1

+1

Guys, adding the features of shortcuts (hotkey) and icons to custom menus on Google Sheets, Docs, and to the whole G Suite -now Google Workspace- would be highly appreciated, to say the least. Thanks!

+1

+1

+1

+1

+1

what is the progress on this?

+1

+1

+1 for Docs support in addition to Sheets

+ 1 for docs

+1

+1

+1

+1

We need keyboard shortcuts for AppScript Functions in sheets, docs, everywhere. In sheets, the macro solution is a hack, not a real solution. There are many cases  where you want to call one of a few functions on a per row basis. Crawling your mouse all the way up to the menu on every single row for 100 rows is ridiculous. I want to use the keyboard, down arrow, ctrl-u, down arrow, ctrl-i, something like that. boom boom very quick. This issue has been open a long time, there are an insane number of +1's. Google, get this done please.

And what's the deal, this is marked "fixed" but clearly isn't. But all of the "duplicates" asking for this to really be fixed are marked closed and merged with this one.

since this issue is erroneously marked "fixed" and clearly it isn't fixed, and since all of the other related issues are closed down after being mergedinto this issue, I created a new issue here, feel free to +1.
https://issuetracker.google.com/issues/196617707