Using a data query app, you can enable other users to search your records across specific fields for specific values. Such a search screen proves especially helpful for large data sets such as product catalogs or libraries.
Creating the data query app
To use a data query app in your Base, you must first add it to your Base.
Learn how to add an app to your Base here.
Edit settings of a data query app
After you have successfully created your data query app, you can select the table, view and columns that can be searched for certain values in the app's settings. To do this, simply open the app via the pencil icon in edit mode.
For example, product name and part number might be appropriate query fields for a product catalog. You could search an employee database for employee names using the "employee" query field:
In addition, you can select in the settings which table fields should be displayed in the query results, i.e. which data is visible to users of the app. Simply hide confidential information by disabling the slider.
Also, you can sort the query results by a column and it is possible to activate a text field for notes above the query results. Use this for explanatory notes and further information.
Edit the name of a data query app
You can rename a data query app that you have added to one of your bases at any time. To do so, simply open the app via the pencil icon in edit mode. If you click on the pencil icon next to the name in the upper left corner, you can change the name of the app.
Share a data query app
You can share your data retrieval apps with other users with just a few clicks. To do so, copy the individually generated app link and/or save the QR code. Both access options can be sent or made available to as many people as you like (with or without a SeaTable account). Users just need to click on the link or scan the QR code to get to the app.
Learn more about sharing a data query app here.
Search for a value in the data query app
After you have successfully shared your data query app, other users can start querying and access the shared data. To search your records for specific values, you simply enter them in the query fields and click Query.
Display of the found records
After you click Query, the found records are immediately displayed in a table. All users of the app can only see the column values of a record that you have enabled or not hidden in the table fields.
Copy a data query app
You have created a data query app that you want to use in a similar form for another user group? Then simply copy the existing app and customize the copy as you see fit. You can learn how to copy an app here.
Disable a data query app
If you've created a data retrieval app that you want to temporarily disable, you can disable it with just a few clicks to revoke access to all groups of users. You can find out how to do this here.
Delete a data query app
You can delete a data query app that you no longer need. Don't worry: Deleting a data query app doesn't delete any data in the base. Learn more about app deletion here.