Restricting Web Access to Specific Records

[sdennie]

What's the best way to restrict specific records from showing up on the web?

Our situation: we have a database of missionaries, which constituents can look up to find contact information, bio info, etc. But some missionaries are in countries not exactly friendly to missionaries. We need their records for internal use, but don't want to make them public via the web.

Thanks for your siggestions.

[sdennie]

Well here's what I did (until somebody gives me a better idea).

I created these fields:

Hide (with values of "Yes" or "No)

FirstName_web (calculation field)

LastName_web (calculation field)

If the value of Hide is "Yes," then FirstName_web = "" (blank), and LastName_web also = blank. Otherwise, if the value of Hide is "No," then FirstName_web = FirstName, and LastName_web = LastName.

So, on the search page, a search for any of those persons shows no results. And if they choose the "Show All Records" option, the list will include some lines with no names.

It works for now.