AnsweredAssumed Answered

Restricting records in IWP using boolean calculation

Question asked by DoubleDee on Aug 26, 2013
Latest reply on Aug 26, 2013 by DoubleDee


Restricting records in IWP using boolean calculation


     Good morning. I have one last problem after a very, very long journey to get a registration site working.

     Here's an excerpt from documentation:


          "6. Limiting Access On A Record-By-Record Basis — To allow or prohibit record viewing, editing, and deleting privileges to certain records within a table, you need to specify a Boolean calculation that determines whether the privilege is permitted. For each record in the database, access is allowed when the calculation evaluates to True or to a non-zero result, and access is prohibited when the calculation evaluates to False or zero.


If you specify a calculation to prohibit viewing of certain records within a table, in most cases you should use the same calculation to prohibit editing and deleting of the same types of records. Otherwise, you may inadvertently allow users to edit or delete records that they cannot view."

I have everything set up for my registration site and it's all working except for the fact that my guests can see a huge database toolbar with a button for editing records and of course seeing everyone else's records, which I obviously don't want. With a little deviousness or just a misunderstanding, I could have someone delete another already registrered customer. Or all of them.

Here are my questions:

1. Can I hide the toolbar on the IWP web page using FMP12? It sure is a huge problem for a basic registration site, which is a major advertised feature.

2. Barring that, what would be the boolean calculation referenced above, if I want the user to be a guest along with other guests? (ie: no extra registration to just be a database user so you can then register). There will be an automatic hidden account # created when they enter the DB, since there is an automatic new record waiting for them, as well as the create date and time. I would think that I could use this data in some way to restrict the user from all other records, but I'm not well versed in calculations. Can anyone help or point me to some well constructed information about this?

     Thank you!