Automation of workflow between various programs
Posted on 2011-03-18
I am a novice.
I am using a website that has helped me to set up a form. When users answer the form it adds the answer to a database. It then automatically updates an sql database at my end.
I then use hotdocs to prepare a complex document. The form includes information about the users email and credit card. I can then submit payment to paypal and email the completed document to the user and update the database to recordthe file name of the completed document, that it has been emailed and that payment has been processed.
I want to automate this. So that when the database receives an update it triggers the opening of the appropriate hotdocs document, imports the data into hotdocs and saves the document to the name suggested by the database, processes paypal and emails the document.
Somebody suggested autohotkey. I was wondering if this was suitable or if there is better software for a novice to use to automate the work flow.