How to Prepopulate Form Fields With Data From Other Tables with Table Prefill?

January 25, 2023

Jotform Tables Prefill allows you to prepopulate form fields with data from a specific table of your form. As you already know, in Jotform Tables, you can add a new tab to view data from other forms you have. You could also create a blank tab or import existing data. You can select one of the tabs as the source to prefill your form.

Below are the steps to prefill your form with data from Jotform Tables:

  1. Go to the Publish tab in the Form Builder.
  2. Click Prefill on the left.
  3. Choose the Tables Prefill option.
form builder pre-fill your forms image.
  1. Select the source Table and Tab.
  2. Map the Tables’ fields to your form fields.
  3. Click Save Settings to save the changes.
form builder pre-fill tables image.
  1. Next, click the Add a New Prefill button.
form builder tables prefill add new prefill image
  1. Select the entries to prefill your form then click Create.
prefill-select-rows-create-min.png

You can filter the submissions to display a specific set of information. To know more about the filter, see “How to Use Different Filters to Easily Manage Your Data in Jotform Tables”.

The Prefilled URLs are now created. Each of the Prefilled URLs is labeled based on the user’s name from the selected table.

Notes

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

Managing the Prefills

Clicking the prefill’s vertical ellipsis icon will allow you to do the following:

form-builder-tables-prefill-menu-min.png
  • Send Invitation – to send the prefilled URL via email.
  • Copy URL – to copy the URL to the clipboard.
  • Rename – to change the name of the Prefilled URL.
  • Delete URL – to delete the prefilled URL.

You can also select all prefills and download, send, or delete them all at once.

form-builder-tables-prefill-select-all-min.png

Send Invitation

When you click the Send Invitation button, a modal window is displayed. The recipients’ email address is automatically filled with the entry’s email address. Add a message if you wish to and click the Send Invitation button to start sending off invites.

form-builder-prefill-send-invitation-min.png

Note

You can select all the prefills, but you can only send an invitation to up to 5 people at a time.

Prefill Permissions

By default, the invited users can edit the values on the form. If you do not want users to edit the data, change the permission from Editable to Read Only.

form-builder-tables-prefill-read-only-min.png

If you have questions, suggestions, or having difficulty setting up the prefill, kindly comment below or contact us through our support channels.

If you are curious about what else you can do with the Prefill, we suggest you check out the following page: Pre-populate Form Fields with Jotform Prefill

Was this guide helpful?
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:

  • SandyRFK
  • Justin
  • taraknathgorai
  • Cianbro HR
  • Jacques le Roux
  • Nima Alipour
  • ssimo3
  • Roberto Manguel
  • adan5643622