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

A: 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 each time first in order to append the row, then upload it back to the storage location. When there are many entries coming in, 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. If/when this happens, we will look to add appending support for One Drive and Office 365.

Q: How can I prevent signatures from being sent by a connector that is set to send media files separately? Can they be excluded?

A: Yes! For any field with media that you wish to exclude, like signatures, just tick the checkbox for "Is Personal Data" in the form designer and then also tick the "Anonymize Personal Data" checkbox on the form connector. These fields marked as anonymous will not be sent along with other media by the form connector when the connector fires.

Q: Why is the file name for my form connector not being accepted?

A: Be sure to omit any hashtag (#) characters from the file name! These are not accepted by OneDrive, and possibly other online storage services as well.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.