1 2 Previous Next 19 Replies Latest reply on Feb 24, 2016 5:43 PM by farm60

    Catastrophic CMD + 8 Mac shortcut

    farm60

      We just stumbled on a serious problem. A Mac user running El Capitan and utilizing FMP version 14 with a hosted database tried to enter SHFT 8 (an asterisk) in a field, but he mistakenly entered CMD 8.  This immediately began deleting records in the table without any warning message or request for confirmation.  I duplicated this phenomenon using FMP Adv 14 on another Mac using the same OS. Turns out that CMD + 8 is not one of the shortcut keys in OS X as seen in the Keyboard section in System Preferences.  Fortunately we had an automated backup from the day before.

       

      Are we the only ones to find this odd and dangerous behavior?  Any fixes?

        • 1. Re: Catastrophic CMD + 8 Mac shortcut
          CamelCase_data

          There's no native keyboard shortcut to delete all records.

           

          Do you by any chance have scripts included in the Scripts Menu? These get shortcut command+1, 2, 3, 4, 5, 6, 7, 8, 9, 0.

           

          My guess would be that command+8 runs a script that deletes all records. In that case, this isn't a bug in FileMaker itself but rather a problem with how your database has been set up.

          • 2. Re: Catastrophic CMD + 8 Mac shortcut
            farm60

            There are dozens of scripts arranged in multiple folders. Are you saying that using a shortcut involving the command key plus a number will automatically bypass an invoking button that activates a script?  This would seem very dangerous since a user could activate scripts willy nilly without it being appropriate.  Would turning on the Script Debugger and the Data Viewer potentially help in determining which script accounted for this phenomenon? The bigger question is how to disable this feature.

            • 3. Re: Catastrophic CMD + 8 Mac shortcut
              CamelCase_data

              You can use the script debugger, but normally you just need to look in the Scripts menu. Whether or not you have a button on the layout executing the script has no effect on whether shortcuts also execute those scripts. So you should only leave scripts visible in the scripts menu if you are sure that they are "safe" and will work well no matter which layout you invoke them from.

               

              I normally use custom menus and hide the entire scripts menu from end users.

              • 4. Re: Catastrophic CMD + 8 Mac shortcut
                taylorsharpe

                Command plus a number runs the first set of viewable scrips in your list of scripts.  Command 1 runs the first one, Command 2 runs the second one. 

                 

                No you can't remove it.

                 

                You can hide all of your scripts.

                 

                Or you can make 10 scripts with nothing in them. 

                 

                Or you first 10 scripts can have a feature that looks to see if the Command Key is pressed and Exits the script. 

                • 5. Re: Catastrophic CMD + 8 Mac shortcut
                  TonyWhite

                  The first 10 scripts that are checked to show in the Scripts menu get keyboard shortcuts, as you have seen.

                   

                  Make sure that each of those 10 scripts are non-destructive so that a keyboard slip does not cause damage.

                  If needed, use scripts that do nothing so that the first 10 slots are filled and a new script does not suddenly show up.

                   

                  That is the fix. Good feature...use as above and you should be OK.

                   

                  Hope that helps.

                   

                  Tony White

                  • 6. Re: Catastrophic CMD + 8 Mac shortcut
                    farm60

                    Thanks so much! This really helped.  I unchecked all scripts and now CMD + 8 does nothing.  I never knew about this aspect of FileMaker!!!

                     

                     

                    All the best,

                     

                    Paul

                     

                    Paul Farmer, PhD

                    Manager of Research Projects

                    Emory Vaccine Center

                    954 Gatewood Road

                    Atlanta, Georgia 30329

                    Work Phone: 404-727-8598

                    Cell Phone:    770-843-3957

                    FAX: 404-727-9316

                    Email: pfarmer@emory.edu

                    • 7. Re: Catastrophic CMD + 8 Mac shortcut
                      farm60

                      Thanks Taylor! I just unchecked the scripts and now all is good. Was a little disconcerting not know about this behavior.

                       

                      All the best,

                       

                      Paul

                       

                      Paul Farmer, PhD

                      Manager of Research Projects

                      Emory Vaccine Center

                      954 Gatewood Road

                      Atlanta, Georgia 30329

                      Work Phone: 404-727-8598

                      Cell Phone:    770-843-3957

                      FAX: 404-727-9316

                      Email: pfarmer@emory.edu<mailto:pfarmer@emory.edu>

                      • 8. Re: Catastrophic CMD + 8 Mac shortcut
                        farm60

                        Thanks Tony. Problem solved after unchecking all scripts. I’ll know better in the future!!!

                         

                         

                        All the best,

                         

                        Paul

                         

                        Paul Farmer, PhD

                        Manager of Research Projects

                        Emory Vaccine Center

                        954 Gatewood Road

                        Atlanta, Georgia 30329

                        Work Phone: 404-727-8598

                        Cell Phone:    770-843-3957

                        FAX: 404-727-9316

                        Email: pfarmer@emory.edu

                        • 9. Re: Catastrophic CMD + 8 Mac shortcut
                          rgordon

                          Here is another keyboard gotcha on a Windows keyboard.  Crtl + a is the command to select all.  If a user wants to type a capital A and accidentally hits the CTRL key instead of the Shift key, all of the text in the field will highlight which mean as soon as they type another letter, all of the text be overwritten.  You can do an undo but most users don't realize what happened. 

                          • 10. Re: Catastrophic CMD + 8 Mac shortcut
                            farm60

                            Wow. Lots of surprises today!

                             

                            Paul Farmer, PhD

                            Manager of Research Projects

                            Emory Vaccine Center

                            954 Gatewood Road

                            Atlanta, Georgia 30329

                            Phone:  404-727-8598

                            Email:    pfarmer@emory.edu<mailto:pfarmer@emory.edu>

                            • 11. Re: Catastrophic CMD + 8 Mac shortcut
                              TonyWhite

                              Here is one more classic keyboard shortcut issue that is good to address...

                               

                              Users will sometime intend to type ⌘+F (Command+F) on the Mac, or (Control+F) on Windows and instead type Command/Control+D (just to the left of "F") which will silently duplicate the current record.

                               

                              The general fix here is to set up Custom Menus and override the Record Menu and the Duplicate menu item with a script that presents a dialog to the user where they can cancel or proceed with the duplication. While you are at it you will likely want to override other commands that located in the Records menu as well. (I am looking at you Delete Record... and New Record)

                               

                              There is much more that could be said about Custom Menus...another very useful feature of the FileMaker platform.

                               

                              Tony White

                              • 12. Re: Catastrophic CMD + 8 Mac shortcut
                                DavidJondreau

                                Keyboard shortcut issues aren't a FileMaker thing.

                                 

                                Command W on a Mac is Close Window. Right next to the W is a Q. Command Q is Quit application. A few times a week, I'd find myself quitting an application when I meant to close the window.

                                 

                                I ended up remapping the OSX shortcut so CmdQ doesn't quit anymore.

                                • 13. Re: Catastrophic CMD + 8 Mac shortcut
                                  FilmUser

                                  Add to what Rgordon said - your curser must till be clicking in the field for the undo to work, re the Control A thing. Come out of the field, and undo doesn't work.

                                  • 14. Re: Catastrophic CMD + 8 Mac shortcut
                                    BeatriceBeaubien

                                    And Shift-Control-E on Windows, Option-Command-E on Mac, can have pretty awful consequences. The record is deleted without dialogue.

                                     

                                    All the best,

                                     

                                    Beatrice

                                     

                                    On Feb 24, 2016, at 11:08, TonyWhite <noreply@filemaker.com> wrote

                                     

                                                              

                                    Catastrophic CMD + 8 Mac shortcut

                                    reply from TonyWhite in Discussions - View the full discussion

                                     

                                    Here is one more classic keyboard shortcut issue that is good to address...

                                     

                                     

                                    Users will sometime intend to type ⌘F (CommandF) on the Mac, or (ControlF) on Windows and instead type Command/ControlD (just to the left of "F") which will silently duplicate the current record.

                                     

                                     

                                    /snip

                                    Tony White

                                     

                                    1 2 Previous Next