Need help with Google sheets

[kunj_thakker]

With Reference to https://groups.google.com/d/msg/mitappinventortest/tatdg8aVXDY/kB7Xy2JDEAAJ
@TIMAI2
I wanted to ask from where can I learn the the scripts , how to write them myself, Any links or examples would be of great help!

Thanks in advance!

[TIMAI2]

There is quite a bit from what we already did, but have a look through this list:

AI2 and Google Drive/Docs/Sheets

 

HOWTO: Query Any Google Sheet with a Web App.

UPDATED! HOWTO - Upload Any File to Google Drive !

HOWTO: Use AI2 to directly submit Google Form Data

HOWTO: Google Drive - Multiple Files Download (file by file)

HOWTO: Download Google sheet as CSV

HOWTO: Send Data to Google Sheet with Web App

HOWTO: Show Image from Google Drive

HOWTO: Upload Image to Google Drive using base64 and Google Apps Script Web App

HOWTO: Upload Image to Google Drive using base64 using Camera Image

HOWTO: Get Data from Private Google Sheet with A Google WebApp

HOWTO: Get the ID of Image after uploading using base64

HOWTO: Upload CSV or List to Google Sheet

HOWTO: AI2 - Google Sheets - Web App - Create/Read/Update/Delete

HOWTO: OCR Images and Camera Pictures with Google Docs

HOWTO: OCR pdf and image files using Google Docs OCR function

HOWTO: Upload "Any" File to Google Drive

HOWTO: Use google web app and google query to download filtered output as pdf from Google Sheet

HOWTO: Use Ai2 to Delete Images (or other files) on Google Drive

HOWTO: Take Photo, get GPS Location and Address, upload Image to Google Drive, and save Location data to spreadsheet 

HOWTO: Select a Single Row from a Spreadsheet, and howto EDIT that data

and also remember:

1 Open the script project
2 Go to Publish
3 Deploy as Web App
4 Project version: - select New from the dropdown
5 Execute the app as: your google account address (email)
6 Who has access to the app: Anyone, even anonymous
7 Press the Update button

You have to do this EVERY TIME you change your script

[kunj_thakker]

With reference to this link:

HOWTO: Query Any Google Sheet with a Web App

function doGet(e) {

  return queryAnySheet(e);

}

function doPost(e) {

  return queryAnySheet(e);

}

What are these doPost and doGet functions? here they would trigger the Function queryAnySheet
Are doPost and doGet some specific functions which would Post and Get data or are these just the names given by the user and names can be anything?

another doubt is about e
function doPost (e)
Can it be some other letter? if not what is e 's role?

[TIMAI2]

See here:

https://developers.google.com/apps-script/guides/web

I would leave “e” as “e”

[kunj_thakker]

Thanks for your help!