We were made aware of an issue with our Google Sheets integration that we have now fixed.

On December 11, our underlying OAuth library got updated and introduced a change that broke our integration. The updated library did not mention any breaking changes and we're currently in contact with the developers of the library to check if we missed something.

As a consequence, older responses may not have synced to existing sheets and new connections could not be added. After we deployed the fix, earlier submissions should have been added to existing sheets as they were still in a "pending" state.

To make sure sheets are up-to-date, we suggest to manually clear the sheet (= delete all data in the sheet) and use our bulk sync function to import all submissions. Alternatively, you may delete the connection in the form and add a new one and then bulk sync the submissions.

But if your responses count is already the same as the rows in your sheet (minus the heading), there is nothing for you to manually sync.

We now have added dedicated error logs to the Google Sheets integration so in case something like that happens again, we'll be notified right away.

We're sorry for the inconvenience.

We just released early access to our API, added an option to enable a time picker, and fixed various, smaller bugs.

API in public beta

Our API is now available and should be considered public beta. Not all planned endpoints are available yet, and there is no official documentation yet. Nonetheless, feel free to head over to the new API settings to see how to get started.

Time picker option for date picker field

We added an option to enable a time picker if a form has a date picker field. This has been requested quite a few times, and we're happy to finally offer this option.

As noted in a recent update, you can change the locale of your workspace, which will change the language of the date picker, and it will now also take the time picker into effect. If you select "English US", you will have AM and PM in the 12h format; if you selected German, you will have 24h format. 

Fixes

We also fixed a handful of smaller issues and improved the field validations a little.

We were made aware of an issue regarding our Google Sheets integration. It was not possible to create a new connection on a workspace level because the connection was always assigned to the user who connected the Google account. This was not necessary the workspace admin and that was causing issues when trying to create a new connection in a different workspace (by the same Deftform account).

So the fix basically means that connections to Google accounts are now assigned to the actual workspace, not a single user account.

We created a migration script to create missing integrations for existing workspaces. Everything was working fine for our test accounts and syncs continued to work.

If, however, you run into issues, please remove the connection and create a new one. It should not be necessary though, but just in case. After that, simply run a one-time bulk import to re-sync all data.

When we introduced the option to send emails via a custom SMTP server, a small bug slipped through that affected all emails – not just the ones sent via a custom SMTP server. Whoops.

First off, only emails to admins were affected by this issue, and it only occurred if more than one email address was specified. For example, if you added admin1@example.com and admin2@example.com, both would receive 2 emails when a new response came in with both of them as receivers.

That issue is now fixed. Every admin only receives one email per submission now, just as intended. Thanks for reporting and sorry for the inconvenience.