Use a Unique ID to prepopulate fields including the File Upload field

Hi,

I'm wanting to allow customers to register for my service using the standard information fields.

Additionally I need them to upload a photo

The form will create a UID

The customer can use the UID to view some of there information - including the photo.

Scenario - the form and payment gives the customer 1month membership and Unique ID (UID).

the UID is used to verify currency of membership.

I was hoping to use the prefill function to recall there name, photo, and membership status from a table/database on the backend.

How can i do this using Jotform?

tom

Hi Thomas,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

To achieve your goal:

• Add a Take Photo widget to your form to allow customers to upload photos directly.
• Use a form field to generate and store a Unique ID (UID) upon submission.
• Store membership status and other data in Jotform Tables.
• Use Tables Prefill to prepopulate the form with existing data (name, photo URL, membership status) when customers enter their UID.

This setup lets customers upload photos, receive a UID, and later use that UID to view or update their information with prefilled data from your backend table.

Give it a try and let us know how it goes.

Best regards,
Jotform Support

need to recall the photo too

Hi Thomas,

You can prefill photos using Jotform Tables Prefill by storing the photo URL in your table and mapping it to the form's photo field. Note that the photo itself is saved as a URL, which Tables Prefill can recall along with other data like name and membership status.

Here’s how:

1. Store the photo upload URL in your Jotform Table.
2. Go to the Form Builder, then Publish > Prefill > Tables Prefill.
3. Select your source table and map the photo URL column to the photo field in your form.
4. Create a new prefill entry and share the prefilled URL with your customers using their UID.

This way, customers can see their photo and other info when they enter their UID.

Give it a try and let us know how it goes.

Best regards,
Jotform Support

Hi Tom,

I'll need some time to look into this. I'll get back to you as soon as I can.

We appreciate your patience and understanding.

thank you :)

Hi Tom,

It's not possible for the File Upload field to be prepopulated, and It's not possible to use the value from the Unique ID widget to prepopulate your other fields. You can use our Random Value Generator widget instead. You need to create two forms, the first one is where the value of the Random Value Generator will be generated. The second form is where they will view the membership status. On the second form, you also need to add the Spreadsheet to Form widget. Let me walk you through this:

1. In Form Builder of your first form, click on Add Element on the left side of the page and search for Random Value Generator from the Widgets tab.
2. Next, click on the Wand icon of the Random Value Generator, and from the General tab, set up your preferred Widget Settings.
3. If you want to hide this, select Yes from the Hide field and click on Update in the bottom-right corner of the page.

You can manually enter the membership status of the users in the Tables of your first form. Let me show you how to do this:

1. In Tables, manually enter the membership status of the users.

After this, you can now download the submissions as an Excel file. Let's do this:

1. In Tables, click on the Download All button on the upper right side of the page and select Download as Excel.

Let's now add the Spreadsheet to Form widget to your second form:

1. In Form Builder, click on Add Element on the left side of the page and from the Widgets tab, search for Spreadsheet to Form.
2. Next, click on the Wand icon of the Spreadsheet to Form widget.
3. From the General tab on the right side of the page, upload the Excel file and select UID as the Access Code Column.
4. Lastly, click on Update in the bottom-right corner of the page.

Here's the result:

Let us know if you have any other questions.