Form Search bar - Spreadsheet to form widget

  • Accur Digitus
    Asked on August 11, 2022 at 1:35 PM

    I need to configure the Search Bar & category to my Form which would reflect my data of client details as per nature of business, contact details , company member, designations of the company working employee serving contact numbers 7 etc. , for Example: if we search by name a company " Accur Digitus" the details should come of Director s & employees email, contact number, Designation, Nature of business.
    The dat is on Excel which need to genreate online on jotform for data base.
    so, its a humble request to help on this case

  • Lesther JotForm Support
    Replied on August 11, 2022 at 4:05 PM

    Hi Accur Digitus,

    Thanks for reaching out to Jotfor Support. I found the form Accur Digitus Job Sheet in the account registered to your email address. If this is the form that you're working on, I see a field where it asks for the employee code. I assume this is the search bar that you're referring to.

    We can use the Spreadsheet to Form Widget to achieve your requirements. The form fields will be populated coming from a Spreadsheet (XLS, XLSX, or CSV files). However, this will only pull one row of data.

    1660248035 62f55fe33ef7d  Screenshot 10

    Check our demo form here . Here's the guide on How to Clone an Existing Form From a URL.

    If this is not what you're referring to, please give us more details on what you want to achieve. Include a screenshot in your message to help us understand better what is going on.

    Let us know if you have any other questions.

  • Lesther JotForm Support
    Replied on August 11, 2022 at 4:18 PM

    First, replace the Search field with the widget.

    1. Click on the Add Form Elements at the upper right of the page.
    2. Click and drag the Spreadsheet towards the form.
    3. The settings will open on the right side.
    4. Rename the Search button
    5. Upload your Spreadsheet file.
    6. Please note that the first column in your Spreadsheet will serve as the Unique code or Primary key.1660248684 62f5626cc6eaf  Screenshot 10