Newbies musictech Posted November 1, 2004 Newbies Share Posted November 1, 2004 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... Link to comment Share on other sites More sharing options...
Wim Decorte Posted November 1, 2004 Share Posted November 1, 2004 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 Link to comment Share on other sites More sharing options...
Newbies musictech Posted November 1, 2004 Author Newbies Share Posted November 1, 2004 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. Link to comment Share on other sites More sharing options...
transpower Posted November 1, 2004 Share Posted November 1, 2004 Why not use IWP and simply have the other FMP query the first? Link to comment Share on other sites More sharing options...
Newbies musictech Posted November 2, 2004 Author Newbies Share Posted November 2, 2004 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. Link to comment Share on other sites More sharing options...
Fenton Posted November 2, 2004 Share Posted November 2, 2004 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 -[ 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. Link to comment Share on other sites More sharing options...
Newbies musictech Posted November 24, 2004 Author Newbies Share Posted November 24, 2004 Bump. I am still trying to find a solution. Any more thoughts?:? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7107 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now