ATTENTION: Google Forms Add-on is deprecated. It will continue working for users who already installed it, but will not be listed on stores, although it can still be accessed directly here, and will be shutdown in a near future.

We decided to go to this route to offer a more reliable and auditable way to record data from Google Forms, so you can setup a response Spreadsheet to the form and turn on the Bkper Add-on for Google Sheets Auto-Record feature for the corresponding tab.

To do so, you should do the following steps:

  • Unlink the books and/or uninstall the Forms Add-on
  • If not done already, setup and open the forms Spreadsheet
  • If not done already, install the Bkper Add-on for Google Sheets 
  • Select the corresponding forms response tab and turn on the Auto-Record feature

That way you can keep track of every form response and, once its recorded in you book, it will be highlighted and a note will be logged.

Contact us if you need any help migrating to Bkper Add-on for Google Sheets Auto-Record feature.

   
  

 

 
 
 
With bkper Google Forms Add-on you can customize the way you, or your user, records data in your books, by specifying fields and validation rules. Each form submission can generate records in one or many books.

Linking Books

You can easily record transactions from your Google Forms by linking books to it, as follows:
 


 
 
 Each bound book will have the forms responses submitted to it.

Templates

Templates are optional. If you don't specify them (default), all form responses will be inserted.

In templates, you can insert the form item responses by referencing-it by the item index, for example:

"[0] #[1] #somehashtag"

This template will insert the item at the position index 0 and 1 in the params [0] and [1].

You can also use the [all] param if you want to reference to all responses. For example:

"[all] #somehashtag"

This will replace the [all] param by all responses, separated by spaces.

For Checkboxes and Grid item types, you can also specify the item choice by "." (dots), for example, suppose the item at position index 2 is a Checkbox:

"[0] [1] [2.0] #[2.1] #expenses"

This will replace the [2.0] param by the first choice of the item 2, and the [2.1], with the second choice.

User

If you select the Form Settings "Automatically collect respondent's XXXX username", the username will be recorded, otherwise, the trigger owner will be recorded.

Remove Link

To remove a Google Form link to a Book, just remove the link as follows:

From there on you will no longer record transactions from that Form.

Did this answer your question?