Tableau Desktop Keyboard Shortcuts

Post your working scripts, libraries and tools
turnercj65
Posts: 1
Joined: 05 Nov 2015, 18:56

Tableau Desktop Keyboard Shortcuts

05 Nov 2015, 18:59

Here is a script to hack in some more keyboard shortcuts to Tableau Desktop!

Code: Select all


#SingleInstance force

SetTitleMatchMode 1

#ifWinActive Tableau

; ctrl-shift C = Create Calculated Field
^+C::
ClickMenuItem(301, 40, 373, 428)
return

; ctrl-shift D = View Data
^+D::
ClickMenuItem(301, 40, 339, 129)
return

; ctrl-shift P = Publish Workbook
^+P::
ClickMenuItem(447, 40, 504, 112)
return

; ctrl-shift Home = move pill to dimensions shelf
^+Home::
MouseGetPos, x, y ;get current position of mouse to reset the mouse after hot key
SendEvent {Click %x%, %y%, down}{click 100, 400, up} ;click and drag to dimensions and let go
MouseMove %x%, %y%, 0 ;restore mouse position
return

; ctrl-shift R = Rename field
^+R::
MouseGetPos, x, y
MouseClick, right, %x%, %y%
Sleep, 75
x+= 75
y+=95
MouseMove %x%, %y%, 0
MouseClick, left
x-= 75
y-=95
MouseMove %x%, %y%, 0
return


ClickMenuItem(menuButtonX, menuButtonY, menuItemX, menuItemY)
{
	MouseGetPos, x, y ;get current position of mouse to reset the mouse after hot key
	MouseMove, menuButtonX, menuButtonY, 0 ;move mouse to menu button on toolbar
	MouseClick, left ;click on appropriate menu button
	MouseMove, menuItemX, menuItemY, 0 ;move mouse to menu item
	MouseClick, left ;click on appropriate menu item
	MouseMove %x%, %y%, 0 ;restore mouse position
} ;end ClickMenuItem

User avatar
Joe Glines
Posts: 588
Joined: 30 Sep 2013, 20:49
Facebook: https://www.facebook.com/theAutomatorGuru/
Google: https://plus.google.com/105328929654286634910
GitHub: joetazz
Location: Dallas
Contact:

Re: Tableau Desktop Keyboard Shortcuts

16 Mar 2017, 09:13

I'm using Tableau and there is no hotkey for exporting images. The following will copy the default image to clipboard and paste to PowerPoint if it exists.

Code: Select all

sleepy:=75
;************************************************************
if WinActive("ahk_class Qt5QWindowIcon"){
Send, {Alt}
sleep, sleepy
send, w ;select Worksheet option
sleep, sleepy
send, c ;Select copy option
sleep, sleepy
send, i ;select image option
sleep, sleepy
send {Enter} ;click the copy button

;***********paste into PowerPoint *******************
If WinExist("ahk_class PPTFrameClass")
{
WinActivate
sleep, sleepy
    Send, ^v
}
}
StevieD

Re: Tableau Desktop Keyboard Shortcuts

17 Nov 2017, 17:57

Any idea if the copy and paste function still works? I've tried it and it doesn't seem to?
User avatar
Joe Glines
Posts: 588
Joined: 30 Sep 2013, 20:49
Facebook: https://www.facebook.com/theAutomatorGuru/
Google: https://plus.google.com/105328929654286634910
GitHub: joetazz
Location: Dallas
Contact:

Re: Tableau Desktop Keyboard Shortcuts

18 Nov 2017, 05:38

I used this not too long ago. It automated exporting the images and saving them to the hard drive

Code: Select all

sleepy:=100
;************************************************************
if WinActive("ahk_class Qt5QWindowIcon"){
MouseClick, left, 873 ,156
sleep, sleepy
Send, {Alt}
sleep, sleepy
send, w ;select Worksheet option
sleep, sleepy
send, e ;Select copy option
sleep, sleepy
send, i ;select image option
sleep, sleepy
send {Enter} ;click the copy button

WinWaitActive, Save Image,,2
ControlClick, Save, Save Image
}

Return to “Scripts and Functions”

Who is online

Users browsing this forum: Maniax2 and 30 guests