Back to zzTakeoff Community Channel LogoFeature Requests

Settings - creating "Dropdown Options" hotkey for new row

Completed

Not sure if there's a hotkey for adding rows. I tried "enter" and "enter+alt/shift/ctrl".

Is there a hotkey or combo keys to add new line? I'm currently manually clicking the star


1

Need a Excel copy paste feature, then this is not needed!

I type the dropdown value, press Tab then Enter then Shift+Tab, then type the next dropdown value, and repeat. I even wrote a script to auto type these values based on a text file, and it will auto fill the dropdown values. Its using the standard operating system applescript tool for mac to auto type values in the browser.

Thanks @Stephen


I'll give it a whirl. I got to the part yesterday where I tab'd, then enter but not Shift+Tab.

I'm not sure I understand the script - auto type business but I'm interested

You could have a chat session and try to get something like this working on windows:


; Prompt the user to select the text file
Local $filePath = FileOpenDialog("Select Text File", @WorkingDir, "Text Files (*.txt)")
If @error Then Exit
; Open the file for reading (mode 0)
Local $fileHandle = FileOpen($filePath, 0)
If $fileHandle = -1 Then
    MsgBox(16, "Error", "Could not open the file.")
    Exit
EndIf
; Wait for the user to switch to the target application
MsgBox(64, "Ready", "Press OK, then switch to your target window. You have 3 seconds.")
Sleep(3000)
; Read the file line by line
While 1
    Local $line = FileReadLine($fileHandle)
    If @error = -1 Then ExitLoop ; End of file reached
    ; 1. Type the value from the current line
    Send($line)
    ; 2. Press Tab
    Send("{TAB}")
    ; 3. Press Enter
    Send("{ENTER}")
    ; 4. Press Shift+Tab
    Send("+{TAB}")
    ; Small delay to allow the application to process inputs
    Sleep(500)
WEnd
; Close the file handle
FileClose($fileHandle)
MsgBox(64, "Finished", "Script completed successfully.")



Think of this script as a macro that mimics a person typing. It opens a file and loops through a set of keystrokes for every line of text found.


Here is the step-by-step breakdown:


1. Getting the File

  • FileOpenDialog: Pops up a window for you to pick your .txt file. It saves that location to $filePath.
  • FileOpen: Opens that specific file in "read mode" (0) so the script can see what's inside.

2. The Countdown

  • MsgBox & Sleep(3000): This gives you 3 seconds to click into the application (like a web form or Excel) where you want the typing to happen. If you don't switch windows, it will just type into thin air.

3. The Automation Loop (While 1)

This section repeats for every single line in your text file:

  • FileReadLine: Grabs the next line of text. If it hits the end of the file (@error = -1), it stops.
  • Send($line): Types out the text from that line exactly as it appears.
  • {TAB}, {ENTER}, +{TAB}: These are the keys you asked for. The + symbol is AutoIt shorthand for the Shift key.
  • Sleep(500): A half-second pause. This is crucial because scripts type faster than most apps can load; without this, the script might skip fields.

4. Cleanup

  • FileClose: Properly releases the text file so other programs can use it.

OK, I see now. I may get something like this going when I get the time to program this knock-off streamdeck I picked up last week.

Thanks for the inspiration - @Stephen you're a #goodegg

@Chaz, we did a minor update that allows you to hit enter while the last dropdown option input is selected to automatically create a new dropdown option.


@Kyle, we haven't added support for Excel copy/paste yet because users could potentially add hundreds/thousands of options in the dropdowns, and it can become a speed issue with our current architecture. We are planning to add an option that pulls from a list (since lists are meant to handle high volume), and from there, users could import options into the list from Excel, etc.

@Lorin than you do much for the follow-up (another #goodegg)


i will check it out shortly and see how it goes. Love the idea of dynamic lists!

You must be logged in to post replies. If you don't have an account you can signup here.