Thank you for your post.
I was hoping other forum members would chime in on this one, as you may think an answer coming from FileMaker, Inc. would be biased.
In any case, FileMaker Pro comes with Instant Web Publishing. This allows you to share your database over the web with five simultaneous users. For more users, you would need FileMaker Server.
Yes, up to five people can use the same guest account and access only certain fields. Since this is all being accessed from the same database file, another FileMaker Pro user can also access the file, and depending on the access privileges, add to the record, enter completion date, etc.
You can also create scripts that will email you (or a set of people) when a new record is created.
If you want clarification on any of the above topics, please let me know.
i've personally created a database for a company that has its registrations done online, they wanted them to come directly into the database, depending on how skilled your web developer is, its not too difficult, this is what i did, this only works on mac though
1) every time a problem is arisen and entered on a form on the webpage, have it put the information into a .csv file to store all the values, its possible to design the form so that if the csv file is not there, it will be created
setup a script in filemaker to perform the applescript step below and setup an an FTP program (fetch works with apple script perfectly, u can just record the actions),
2) record the ftp program logging into the ftp server, and copying the file onto your desktop then deleting it off the ftp server
3) setup a script that performs the importing of the .csv file into the database
4) run another apple script to delete the .csv file off your desktop
its a bit of a hairy way around it, but my client runs a childrens program with over 1000 kids, registrations comming in all the time, this handles all the registrations and brings them straight into the database
Had you used XML instead of .cvs, you could have imported the data directly from the served file - and on any platform.