Jump to content
Sign in to follow this  
musictech

HTML form fields ---> Filemaker

Recommended Posts

Hi,

How do I pass data from form fields inside a simple html page to a filemaker database? Right now our web page is being hosted on a separate IP and I would need to make a call to our database which is on another separate IP and insert the records the user typed in on our web form into our database automatically and then return to a thank you page.

Error checking would be nice but is not required.

That's it.

How the heck do I do that?

Thanks in advance!

Eric...

Share this post


Link to post
Share on other sites

On Windows you can use VBscript to read the values of the fields in an HTML form, write them out to a text file and import them into FM.

Not sure how to do this on a Mac

Share this post


Link to post
Share on other sites

Any way to automate this? The import process?

We host on Macs, both FMP and HTML. So perhaps we need to look at a different solution.

We get like 60+ form processes per day and right now they get emailed via a Cold Fusion script where then a staff member enters them into FMP. Yuck! We need to automate that process.

Share this post


Link to post
Share on other sites

Why not use IWP and simply have the other FMP query the first?

Share this post


Link to post
Share on other sites

Good idea.

I'm just wondering if there is a more efficient means to do this other than that method. If I use IWP can I still maintain the look and feel HTML forms give me within my site?

Thanks.

Share this post


Link to post
Share on other sites

A whole 'nuther direction would be to use a plug-in, such as POP3it, to receive email directly into FileMaker, then parse the form into fields. We have some examples here (somewhere) that illustrate this kind of parsing; it's usually fairly easy, as HTML forms are fairly simple and consistent.

POP3it used to be able to check the mail automatically at set intervals (and run scripts before and after), but they haven't got this feature working yet for FileMaker 7 B)-[

Perhaps, as Wim says, you could use a more direct technique, with a scripting language. Command line or AppleScript on a Mac may be able to do this; but I'm not enough of a web-guy to know how.

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  

×

Important Information

By using this site, you agree to our Terms of Use.