-
Accur DigitusAsked 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 SupportReplied 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.
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 SupportReplied on August 11, 2022 at 4:18 PM
First, replace the Search field with the widget.
- Click on the Add Form Elements at the upper right of the page.
- Click and drag the Spreadsheet towards the form.
- The settings will open on the right side.
- Rename the Search button
- Upload your Spreadsheet file.
- Please note that the first column in your Spreadsheet will serve as the Unique code or Primary key.