How to Prepopulate Form Fields With Data From Other Tables

December 7, 2023

Jotform Tables Prefill allows you to use data from your Jotform Tables to prepopulate fields on your form. You can use one of your form tables or import your existing data into Tables and use it. See How to Import Data in Jotform Tables to learn more.

To prefill your form with data from Jotform Tables

  1. In the Form Builder, select Publish at the top.
  2. Go to Prefill on the left.
  3. Select Tables Prefill.
Steps to access Table Prefill in Jotform Form Builder
  1. Next, choose your source table and tab.
  2. Map your table’s columns to your form fields.
  3. Once you’re done, select Save Settings.
The Table Prefill configuration page in Jotform Form Builder
  1. On the next page, select Add a New Prefill.
The Add a New Prefill button in Jotform Form Builder
  1. Choose the entries to prefill your form, then select Create in the upper-right corner.
The data selection in Jotform Form Builder's Tables Prefill configuration page

Notes

  • While you can select all submissions, you can only create 20 prefills at a time.
  • Jotform Tables Prefill supports the following elements:
    • Full Name
    • Email
    • Address
    • Short Text
    • Long Text
    • Phone
    • Number
    • Dropdown
    • Single Choice
    • Multiple Choice
    • Scale Rating
    • Spinner

You can now copy and share your Prefilled URLs. Use the prefill menu to manage your prefills.

The Tables Prefill menu in Jotform Form Builder

Here are the available options:

  • Send Invitation — Send the prefilled URL to up to 5 people via email.
  • Copy URL — Copy the URL to your clipboard.
  • Rename — Change the prefill’s label.
  • Delete URL — Delete the prefill.

Select multiple prefills to download, send, or delete them all at once.

The download, send, and delete buttons in Jotform Form Builder's Tables Prefill

Changing Prefill Permissions

By default, invited users can edit the prefilled values on your form. To prevent your form fillers from changing the values, set the prefill’s permission to Read Only.

The permission options in Jotform Form Builder's Tables Prefill
Academy Logo

Introduction to Form Building

Prefill

Go to course :Prefill
lesson-2 - image
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • Dotsy Torres - Profile picture
  • Sri Sukhi - Profile picture
  • Jose - Profile picture
  • SandyRFK - Profile picture
  • Justin - Profile picture
  • taraknathgorai - Profile picture
  • Cianbro HR - Profile picture
  • Jacques le Roux - Profile picture
  • Nima Alipour - Profile picture
  • ssimo3 - Profile picture
  • Roberto Manguel - Profile picture
  • adan5643622 - Profile picture