« previous next »
Pages: [1]   Go Down

Author Topic: Anyone use or familiar with AutoHotKey?  (Read 1115 times)

Online CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 16499
  • Total likes: 7436
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Anyone use or familiar with AutoHotKey?
« on: September 23, 2019, 06:36:50 PM »
I am trying to pull info from Excel into web form using AHK.
Logged
Only on DDF does 24/6 mean 24/5/half/half

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6796
  • Total likes: 2635
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #1 on: January 28, 2022, 03:25:34 PM »
Quote from: CountValentine on September 23, 2019, 06:36:50 PM
I am trying to pull info from Excel into web form using AHK.
Bump

Looking for someone a bit familiar. I'm looking to pull data from google sheets I have something set up but it's being glichy.
Logged
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Online Euclid

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2010
  • Posts: 5027
  • Total likes: 6179
  • DansDeals.com Hat Tips 5
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #2 on: January 29, 2022, 07:53:53 PM »
Quote from: Yo ssi on January 28, 2022, 03:25:34 PM
Bump

Looking for someone a bit familiar. I'm looking to pull data from google sheets I have something set up but it's being glichy.
Don't they have an API? Why would you want to use AHK?
Logged

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6796
  • Total likes: 2635
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #3 on: January 30, 2022, 12:14:36 AM »
Quote from: Euclid on January 29, 2022, 07:53:53 PM
Don't they have an API? Why would you want to use AHK?
Your referring to google app script?

In short I'm using an existing spreadsheet (that sometimes changes) I don't want to mess with the sheet, I would just like to get data from a row and I then have a waitkey which waits till I press the shortcut and then it populates the appropriate fields. It works really well when it it works ;D

The main 2 issues are that A. The wait key sometimes doesn't wait. B. The way I get information from the cells is by having it press the left and right arrows and copying each field, but it doesn't always get the right fields.
Logged
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Offline Live N Learn

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2015
  • Posts: 3822
  • Total likes: 336
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #4 on: January 30, 2022, 04:10:31 AM »


Quote from: Yo ssi on January 30, 2022, 12:14:36 AM
Your referring to google app script?

In short I'm using an existing spreadsheet (that sometimes changes) I don't want to mess with the sheet, I would just like to get data from a row and I then have a waitkey which waits till I press the shortcut and then it populates the appropriate fields. It works really well when it it works ;D

The main 2 issues are that A. The wait key sometimes doesn't wait. B. The way I get information from the cells is by having it press the left and right arrows and copying each field, but it doesn't always get the right fields.


For issue B, you can try to add a sleep between each stroke and play around with the timing to get it right and short.
Logged
".איזהו חכם, הלומד מכל אדם"

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6796
  • Total likes: 2635
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #5 on: January 30, 2022, 10:58:10 AM »
Quote from: User6669 on January 30, 2022, 04:10:31 AM
For issue B, you can try to add a sleep between each stroke and play around with the timing to get it right and short.
Exactly what I tried. It seems it's unrelated to the timing, it just sometimes works and sometimes doesn't :-\
Logged
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/
Pages: [1]   Go Up
« previous next »