How Can Users Without Access Rights or Guests Query and View Records?

When using an Embedded Sheet to display data, what users see depends on the Access Rights configured for the sheet in your database. For example, if the sheet is set to VIEWER for the EVERYONE group, even guest users who are not logged in can view all records through the embedded sheet.

However, if you want to allow guest users to search for specific records without making the sheet public, such as searching for a shipment by entering a tracking number online, you can achieve this using Exact Mode.

Setting Exact Mode

Both Database Query and Database View & Query support Exact Mode. When this mode is enabled, users can search for records by entering query values that exactly match the data, even if the sheet is not set to public.

Setting Steps:

1. In the embed settings, check the Exact Mode option in the upper left corner.

2. Click Set Default Query Field to choose the fields users will use to query.

3. Click Save, then complete the remaining embedded settings as needed.

Users will now be able to search for data by entering exact matches in all query fields, even if they do not have access rights to your sheet.

They can also click a result to view the detailed record.

Notes

1. In Exact Mode, users must enter an exact match in all query fields to retrieve data. Partial inputs or incomplete criteria will not return any results.

2. Exact Mode settings are shared across the same sheet. For example, if you enable Exact Mode in a Database Query for the "Sales Order" sheet, it will also apply to the Database View & Query for the same sheet. Disabling it in either one will remove the setting from both.