Ragic gives each user the ability to create different View types. As we query more and more often, there are a set of queries that users will regularly execute.
Users can save these types of frequent searches on any combination of fields from the left sidebar on the sheet as Personal Views.
If you want your users to view the filtered entries only, you can apply Fixed Filter on the sheet.
The saved Views are listed on the left side, above the Search button.
After finishing your search, clicking on the Clear Filters button will lead back to the full database.
Different types of Views are explained in the below sections:
If you want every user who has access to the same sheet to be able to see a view that is saved, you can set up a Shared View. This way users can see the views you created directly without setting them up themselves.
You can set a Shared View as a Default View for a sheet, so that whenever the users go to a sheet, the default view will automatically be applied. You can set a view as the default view by right-clicking on the shared view's name, or through the arrow on its right side.
The user can clear the filter conditions applied by this default view by clicking on Clear Filters at the top of the sheet.
Another type of view is called a Fixed Filter. A fixed filter is pretty much like a default view, but the filter conditions cannot be removed by the user. This can be used in conjunction with Duplicate Sheet, so that you can create different versions of a sheet by assigning different fixed filters to them.
You can combine fixed filter with the field type "select from other sheet" and fixed filter to limit the selection options.