- chrisAsked on August 29, 2017 at 11:38 AM
I need to a) import an existing excel sheet b) convert to form c) email form link to list of people d) have people fill in some "cells" e) download populated data to local excel worksheet. Need to know if this can be done using Jotform API with VB scripting in excel worksheet.
- JotForm SupportNik_CAnswered on August 29, 2017 at 12:31 PM
Unfortunately, there is no way to import excel sheet and create a form of it. The only way is to create a form from scratch and mimic the fields from the sheet.
You can share the form link easily by following this guide: https://www.jotform.com/help/303-How-to-Send-a-Form-via-Email
You can easily integrate the existing form with Spreadsheet by following this guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet
Then, every time the form is submitted the data will go to that sheet.
Could that work for you?