How can I autofill answers with external data?

Hello, I've been wondering if there is the possilibility of autofill fields in the form using data from raw files(excel). Is there some sort of integration that allows extracting data from onedrive to check and autofill the form in real time before sending?

Hello siproduccion,

Thanks for reaching out to Jotform Support. We do have our Spreadsheet to Form widget, which allows users to populate their form fields from an external Excel Sheet. But currently, the dropdown element is not yet supported for this widget. These are the form fields that can be populated with details from your external sheet with the help of the said widget:

• Full Name
• Email
• Time
• Short Text
• Long Text
• Dropdown
• Single Choice
• Multiple Choice
• Scale Rating
• Star Rating

If this widget will work for you, let me show you how to add it to your form:

1. In Form Builder, click on Add Form Element in the upper-left corner.
2. Go to Widgets, and search for Spreadsheet to Form.
3. Drag and drop it onto your form, and upload the Excel file by clicking on Upload File in Widget Settings.
4. Once uploaded, set the Access Code Column. It should be the data that your form fillers should enter into the Spreadsheet to widget field that would trigger the populating of data.

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

Hi, this could be usefull but we are looking for a solution that allow us to have a direct conecction with an external excel through an API or some kind of integration that let us keep the data updated.

Hello siproduccion,

Thanks for getting back to us. Unfortunetly, currently, it is not possible to extract data from external Excel sheets dynamically. You will need to update the Excel sheet in the widget manually with new entries.

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. 

Reach out to us if you need any more help.