Skip to main content

How it works

You can add a dropdown to your Fillout form that lets respondents pick existing records from your Zite database. This record picker only links to the selected record. It does not update existing records. If you want respondents to edit records without database access, see this article.

Common use cases

  • Employee Onboarding: Let HR select a manager, department, or mentor
  • Equipment Checkout: Allow staff to select equipment or devices from a database
  • Course Enrollment: Let students pick existing courses or programs in an enrollment form
  • Vendor Requests: Link purchase requests to existing suppliers or vendors
  • Content Management: Let authors select an existing category, project, or campaign

Add a record picker

1

Link records

On your Zite database, link tables by following these steps.
Zite database table of budget requests with an Employee column linked to the Employees table
2

Connect your form

Open your Fillout form. Go to Integrate on top and choose Zite Database. Then, set your preferences.
Integrate tab in the form editor with Zite Database highlighted under Popular apps
Zite automatically maps matching fields when available. If not, you can manually drag your database columns (on the left-hand panel) into the form.
3

Insert record picker field

For example, let’s allow our employees to request budget approval through a form. They can select their name from the Employees table. Their response is recorded in the Budget Requests table and linked to them.
Budget request form in the editor with the Employee record picker in the Zite Database fields list
Drag the record picker into your form. This becomes your dropdown for selecting records.
4

Publish and share

Click Publish on the top right to reflect the changes.Respondents can now select records from your database.
Live form with the Employee record picker open, listing employees with their ID, department and position
Currently, only the selected record’s ID can be displayed or used elsewhere in the form. Individual fields from the selected record, such as its name or email, aren’t available.

Advanced features

Open the record picker’s settings by clicking the settings icon to show Advanced on the right-hand panel.
Record picker settings with Advanced open, showing Fields to show, Field to search by and Filters
Here, you can set:
  • Fields to show - choose which database fields are visible instead of showing all record details
  • Field to search by - allow lookup using a field other than the primary field. Email notifications show this field’s value for the selected record. If it isn’t set, they show Answered instead.
  • Filters - show only selected records based on conditions you set

Link records

Link records across tables to assign or reference.

Update with forms

Edit existing Zite database records with a Fillout form.