Form that Returns Data Input based on One Input Value?

Hello. I am working with my team on a smooth digital process for people to check in and collect their t-shirts. The t-shirt sizes were collected in a Google form earlier with their full names only (no other contact information).

So far, I'm thinking that

1. we will have a QR barcode for people to scan
2. the QR takes them to a Jotform where they type in their name
3. the form looks through the spreadsheet for their names and returns other associated values such as the timestamp and size input (they would be unable to edit this return btw)
4. then there is a signature field for them that they sign & submit
5. the final page is a simple "Uniform Collected!" thing

Is it possible for a JotForm to do all that? I believe the link below hints at this direction but the pictured examples seem a bit outdated. (https://www.jotform.com/answers/647303-is-there-a-widget-that-return-me-a-value-depending-on-date-of-birth)

Sincere thanks for your help in advance!

Hi oteeprosper2, 

Thanks for reaching out to Jotform support. Yes, I think you can achieve this with Jotform.

As for the QR code, you can easily get the Jotform form QR on the Publish page. Let me show you how:

1. In Form Builder, click on Publish.
2. Click on View More under the Share Form section.
3. Click on Share With QR Code to get the QR code for your form.

Once the QR redirects users to your form, you can build it as you prefer. To repopulate the fields based on the user name inserted, you can use our Spreadsheet to Form Widget. Here's how to do it:

1. In Form Builder, click on Add Form Element and select the Widgets tab.
2. Search and select the Spreadsheet to Form widget.
3. You can upload your spreadsheet in the right pane section.
4. Select the access code that will trigger the widget to repopulate the other fields.

Here's how it works:

You might want to check out this guide about How to Use the Spreadsheet to Form Widget. Note that the spreadsheet uploaded in the widget is a local file and can't be updated dynamically. This means that if an edit is made on the sheets, you need to re-upload the updated version in the widget. Unfortunately, there isn't a dynamic way to fetch the data to populate form fields from an online source of data.

As for adding a signature field, you can easily do it in the builder. You can find the signature field in the Basic tab.

Also, you can customize the Thank You Page to your needs. Let me walk through it:

1. In Form Builder, click on Settings.
2. Select Thank You Page on the left and customize the body as you prefer.

That's it! Let us know if you need any other help.

Thank you Joseph! This was incredibly helpful. Instead of people typing their names in the widget, I added an autocomplete field that would bring up matches for their names and their selection would be copied into the widget. The steps now are:

1. a QR barcode for people to scan
2. people type in their name in the autocomplete field and select the right one
3. autocomplete field is copied into the widget
4. their entry is found and completes other fields with signature prompt

Everything seemed to be working, but I ran into another hiccup. Let's say someone who DID NOT register types in their name, the widget now says "Your submission is not found" as a sublabel. They freak out and go back to choose someone's else name. The fields will fill themselves and they sign. Is there a way to clear the other fields if that happens, like once "a submission is not found"?

I was thinking of some assigning value mechanism that would initiate conditions to clear other fields but that option is not available in the widget settings. Is my question crossing CSS code territory 😐😐

Hi oteeprosper2, 

Thanks for getting back to us. Unfortunately, I couldn't fully understand your issue. I need more details about your issue and what you want to avoid to check out a solution for you. Can you give us more details? You can add a screenshot or a screen recording to explain your issue better. You can use Loom to make a screen recording and paste the link here.

Also, it would be useful the have one of the access codes to insert in the widget to test how your form works.

Once we hear back from you, we'll be able to move forward with a solution.

Hello Joseph,

Apologies for the silence! I went through the widget guide you sent and found what I was looking for.

Thanks again for your help!