- cris74Asked on November 03, 2016 at 09:00 AM
When will you replace the manual process by an automatic data flow, as already exists for Google sheets?
This is a re-post of a comment on How to Create an Excel Report
- JotForm SupportChriistianAnswered on November 03, 2016 at 11:18 AM
Can you please provide us more details regarding your concern? Currently, once you created an Excel Report, you will have a link where you can download the updated submission data of your form. What are you referring to with the manual process?
We will wait for your response.
- cris74Answered on November 03, 2016 at 12:40 PM
I would have an Excel file updated in real time by new subscriptions. For now exploit the submissions, I have to sign on my JotForm space, select my form, click report, copy the file from the download directory: these manual operations are reliable but are not automatic.
However, by integrating "Google spreadsheets" Google sheets automatically updates all submissions to this form. I would like an Excel integration to do the same. Because the Google sheets can not be used by the VBA code of Excel workbook.
- JotForm SupportdavidAnswered on November 03, 2016 at 02:13 PM
Though it is not possible to update the sheet directly via JotForm, this can be done through Zapier:
This does require a Microsoft OneDrive Business account.