Form Connectors FAQ

Form Connectors FAQ

Is it possible to connect a form to an Excel spreadsheet on Google Drive, OneDrive, or Dropbox so that each time a form is filled out on the device, it adds a line to the same spreadsheet?

Our Google Spreadsheet connector currently supports this scenario, in that we append rows to the same Google Spreadsheet. When you create new versions of your form, we continue to append rows to the same worksheet, just adding missing columns as needed.

For the Excel side on Dropbox, Google Drive, etc, we do not currently support appending rows. This is because if we did so, we would have to download the file first each time in order to append the row, then upload it back to the storage location. When there are many entries coming in – and often concurrently – this rapidly becomes very problematic.

Google Spreadsheet does not have this problem, because we are able to add rows through a programming interface (called an API) instead of downloading the spreadsheet each time.

Microsoft is said to be launching new APIs in the future that will match Google Spreadsheet, when/if this happens we will look to add appending support for Excel Online.

    • Related Articles

    • FAQ- Data Captured

      Q: I have published a new Form version but I am still seeing some Data entries coming in against the old Form version. Shouldn't the users app have updated to the latest version automatically? A: The system will automatically update mobile users with ...

    • SQL Form Connectors – Custom SQL

      There are two ways to control the flow of data to your SQL tables using one of our SQL form connectors (SQL Server, MySQL, or PostgreSQL): “Auto Maintain” and “Custom SQL“. In this article, we’ll look at “Custom SQL” and how you can use it in your ...

    • Task Template Connectors

      Task connectors effectively allow you to add connectors to generate emails, text messages, or REST calls based on events occurring on a Task if the assigned user changes, the status updates, or the Task becomes overdue. You define these connectors on ...

    • Form Captured Data FAQ

      I have published a new Form version, but I am still seeing some Data entries coming in against the old Form version. Shouldn’t the users app have updated to the latest version automatically? The system will automatically update mobile users with the ...

    • Form Connector – Power BI

      This is a Premium connector that directly connects to Microsoft Power BI. Power BI is a business analytics solution that includes multiple tools and building blocks to visualize your data and share insights across your organization. Our platform ...