filling in forms

[stuj1026]

not sure if this is the right forum but here goes!

We are a insurance company and frequently have to go out to the web to check to see if an applicant has any claims against him/her. We get this information thru the department of health in florida.

We are tring to be able to fill in fields on the department of health webpage using the field data from filemaker. and then open the URL up to see the results.. Anybody know how to do this?

Thanks Stu

[Garry Claridge]

ActiveX (Applescript for Mac) can talk to both FMP and a browser. You may be able to get it to call the form url, populate the form from fmp, then submit it.

All the best.

Garry

[Anatoli]

Stuj -- I am lost in your description. Could you describe that again?

Where are the data going to browser? What do you need to do with them?

Is data in 2 systems?

[stuj1026]

We are using windows.. I purchased a plugin called do-http thinking that might work although I cant figure it out and support from the developer is practically nil.

[stuj1026]

Hi Analtoli

here is a discription of what we are doing! We are an insurance company that handles medical malpractice. We have a filemaker database with over 4000 doctors in it.. We frequently have to goto the department of health website to check to see if a particular doctor has had any claims filed against them .. This information is only available on the web.. What we currently do now is

[1] print out the doctors information from filemaker..

[2] goto the department of health website-- enter in the doctors name and licence number. Hit the (SUBMIT) button.

If the doctor has had a claim against them it comes up in our browser.

Using the open url script will only bring us to the web page where we can enter the doctors name and licence number.

What we are trying to do is pass the licence number field from filemaker and the doctors name from filemaker to the internet using a script so we dont have to physically type it into the fields on the web.

So in other words we would click on the doctors name in filemaker which will take us to the department of healths website with the doctors name and licence number already filled out for us. All we have to do is hit the submit button on the website.

Thanks for all your help

Stu

[djgogi]

Hi,

first you'll have to seek for how the requested URL is generated by your browser:

For ex. this page is generated from server by an cgi and request is:

http://www.fmforums.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=12;t=000570;p=

So look in HTML for the form that is requesting data from web.

Than repeat the formating in FM using your data and open and submit URL by openURL step.

Dj

[goostree]

Here is a similar solution I found on databasepros.com. It uses information on your database to pull maps from mapquest.com. Might give you some ideas on how to work out your solution.

databasepros.com

[Anatoli]

goostree -- we need something else.

Stuj, if the site will be designed to take parameters in URL, then it will be no problem.

Ask them. Maybe they will design (or have already) page for analyzing the URL and do sort of auto-log. It will be "http://www.site.com?user.pass"