Managing your business with anyPiece/WYSIWYG Web editor/Web designer or programmer/Work with google spreadsheet

Prerequisite
 
 * Please make sure your form have following field configure into your form
 * Please configure the extrouter web.config as per below
 * To get this client id and client secret, please visit [Google oAuth]


 * Please configure the refresh token
 * Refresh token would be the key token that will enable the system to upload data to your spreadsheet without your user name and password
 * To get refresh token, type http://yourwebsite.com/google_spreadsheet. You will be ask to login under your google mail account


 * Since we have updated one of the component (newton), please update the web.config to below

 


 * Make sure that you have created the spreadsheet into your google drive with the same name as spreadsheet_name

Setup guide on the form
Please make sure all the fields below is listed in the spreadsheet -> Field: spreadsheet_name -> Field: sheet_name -> Field: success_return -> Field: productname -> Field: productqty -> Field: name -> Field: email -> Field: mobile -> Field: address
 * Create all the three hidden field as per stated in the Prerequisite
 * Put the form action to "google_spreadsheet" and method to "post"
 * Please make sure all the form have the field which will be sent over from the form to google docs. If there is a missing field, you will get an error like below.
 * If you are doing correctly, the system will push the screen to success_url which you have configure in the hidden field