I have written a web form which is being sent to a FM Server 9 DB which is running via IWP. My question is:

What is the best way to secure the data? I turned off Guest and then I needed a password to send the form. This is an option, but not my favourite, as some of the participants in the survey may be young. I then created a privilege set for Guest that allows them to read only. This setting means they don't need a password to POST, but they can still see the data. As the data contains email addresses, I would prefer this were not the case.

Is there a way which allows FM records to be created via a web form but a) the user doesn't need a password and : they can't log in and see the results?

I have read the docs but not seeing what I want. Thanks for your time - it's much appreciated.

Is there a way which allows FM records to be created via a web form but a) the user doesn't need a password and : they can't log in and see the results?

Probably. However, they will see the results as they create them and before they submit them. The ability to create a record includes the ability to see it and to edit it before it is submitted.

Steven

Probably. However, they will see the results as they create them and before they submit them. The ability to create a record includes the ability to see it and to edit it before it is submitted.

Steven

Sorry - I didn't explain that properly. I realize they will see their own post (as a summation in their web browser) what I meant is that I don't want them to be able to log in to the database (should they be able to find the address by viewing the html source of the form page) and see other peoples responses.

Edited February 23, 200817 yr by Guest

OK, you need to set up record level access then. And this means that each user will need to have an individual Account with a password. At lest that's what's required if I properly understand what you're trying to do.

Steven