Jump to content
Sign in to follow this  
tedhill3470

How to get AutoIt varaible/info into FileMaker Pro 9

Recommended Posts

tedhill3470

Hello, I'm using an Internal FileMaker Pro 9 script to start an outside third party email application and to also start an AutoIt file to capture the date from the third party application using ControlGetText. The AutoIt file waits until the Outlook sending mail window appears, and then I'd like to import the date into a field of that FileMaker Pro record showing when that record was emailed. However, ControlGetText doesn't work as the FileMaker Pro fields aren't control fields, and I can't seem to find a way to accomplish this. Does anyone have any suggestions?

Any help greatly appreciated,

TIA

CODE
WinWaitActive("PDFCreator 0.9.5")

$text8 = ControlGetText ("[CLASS:ThunderRT6FormDC]", "" , "ThunderRT6TextBox5")

$date2 = StringMid ( $text8 , 5, 2 ) & "/" & StringMid ( $text8 , 7, 2 ) & "/" & StringLeft ( $text8 , 4 )

WinWaitActive ("Outlook Express", "Sending mail")

?????

Share this post


Link to post
Share on other sites
Richard Robertson

Have you tried the old activate the window and tab around method? It sometimes works.

Share this post


Link to post
Share on other sites
tedhill3470

Have you tried the old activate the window and tab around method? It sometimes works.

And it worked this time. Thank you for helping me with my first autoit script, Richard.

CODE
WinWaitActive("PDFCreator 0.9.5")

$text8 = ControlGetText ("[CLASS:ThunderRT6FormDC]", "" , "ThunderRT6TextBox5")

$date2 = StringMid ( $text8 , 5, 2 ) & "/" & StringMid ( $text8 , 7, 2 ) & "/" & StringLeft ( $text8 , 4 )

ClipPut( "" )

ClipPut( $date2 )

WinWaitActive ("Outlook Express", "Sending mail")

WinActivate ("[CLASS:FMPRO7APP]")

Sleep( 100 )

Send("{TAB}")

Send("^+{V}")

Share this post


Link to post
Share on other sites
Richard Robertson

Some simple solutions are the best.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×