JotForm User Guide / Advanced Features /

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

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

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.

2. Click Prefill.

3. Click the JotForm Table Prefill option.

4. Select the form as your source.

5. Select the specific table from the chosen form.

6. Match your form fields.

7. Click the Add More button if you wish to match more fields. Click the Save button if you are done.

8. Click the Add a New Prefill button. This will open the selected tab/table.

 

9. From the table, you can select the individual submission or select all. Assuming you've already selected the submissions, click the Create button.

Note that while you can select all submissions, you can only create 20 Prefilled URLs at a time. Selecting all and clicking the Create button will not work. You will receive a message indicating the limit instead.

Additionally, you can filter the submissions to display a specific set of information. To know more about the filter, please visit the following guide:

How to Use Different Filters to Easily Manage Your Data in JotForm Tables

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

By default, the users can edit the Prefilled URLs. If you do not want users to edit the data, change the permission from Can Edit to Read Only.

You can select all Prefilled URLs and send or delete them at once. Click the Select All and click Send Invitation to send or click the Delete button to delete.

When you click the Send Invitation button, a popup is displayed. The recipient's email address is automatically filled with the user's email address from the selected table. Add a message if you wish to, and click the Send Invitation button to start sending off an invite.

You can select all Prefilled URLs, but note you can only send an invitation to up to five (5) people at a time. Selecting more than this number will display an error message, and the button to sent the invitation is grayed out.

On each Prefilled URL, clicking the 3-dot menu will allow you to do the following:

Send Invitation: If you wish to send the prefilled URL individually. It's useful if the user lost the previous invitation.

Copy URL: If you wish to send the prefilled URL manually.

Rename: If you want to change the name of the Prefilled URL.

Delete URL: To delete the prefilled URL.

Click the Settings link if you wish to add or remove fields or remove the prefill altogether.

JotForm Tables Prefill supports the following fields only:

Text Fields: Name, Email Address, Address, Short Text Entry, Long Text Entry.

Number Fields: Phone, Number.

Select Fields: Dropdown, Single Choice, Multiple Choice, Scale Rating, and Spinner.

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 to check out the following page: Pre-populate Form Fields with JotForm Prefill.

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:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

1 Comment...

  • adan5643622

    Is there a way to assign a prefilled form? This is because i want to my clients use the prefill form many times.