Avoid report to allow modifications of records in Filemaker Pro 11

I'm building a database that needs to display tables as lists and allow the user to export such lists as Excel spreadsheets. Creating the reports, showing them as lists and providing the button for exporting as Excel was not a problem, however I noticed that when I show those lists the user can still edit them, hence add/deleting records and modify the content of existing records. I'd like to find a way to avoid such modifications when visualizing the list, in such a way to be sure the user does not accidentally change data.

Any idea as to how to do this? I'm using Filemaker pro 11

Thanks in advance.

Answers


There are a couple of different ways that might be appropriate, depending on your needs:

  1. In layout mode, click on the field, go to the Data tab of the Inspector, and turn off field entry in 'Browse' mode. (You also have the option to turn off field entry in 'Find' mode. And you can select multiple fields at once to make the selection for all of them.) This is appropriate if your users can regularly enter data into these fields but you don't want them to enter data for this particular layout.
  2. In Manage Database, under the field options, turn on Prohibit modification of value during data entry in the Auto-Enter tab. This is appropriate if you will only be changing the value of a field during an import or with a script.
  3. In Manage Security, create a new Privilege Set that is View-Only for that table (or for those fields). This is appropriate when some users should be able to modify the data and other users should not be able to modify the data.

There are other methods, as well, but those are the three most common for limiting user access to data.


Need Your Help

glsl & perspective correction of varying values

math opengl graphics glsl texture-mapping

is every varying vertex value (or in newer versions of glsl values that go "out" of a vertex shader) interpolated by the rasterizer using perspective correction? is this hardware dependant?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.