...

You can test your queries directly in the web browser. Note that characters such as the equals and double quotes must be [ URL encoded as shown in the examples below where you see %22 for quote and %3D for =

...

And the following Url parameters:* media

•  media=jason - This must be set as shown

...

•  query=<query string> - This is where you specify which rows to match based on the data in your spreadsheet.

...

•  update=<update string> - This is where you specify which cell(s) to update in the matched row(s)

...

•  method=put - A hard coded Url parameter that must exist in the Url string

...

Google Apps

...

Form submissions can be saved to your Google Apps Premier account.

The first step is to create a Collection (effectively a folder) in your Google Apps account. This will be the location where your form submissions will be stored. For example, create a Collection called Leave Approvals.

Panel
Image Added Create a new Google Apps Collection

 

 

 

[[Image:GA_Create_Collection.png|frame|left|Create a new Google Apps Collection]]
<br style="clear: both" />

...