In this tutorial, we will see how we can add a custom menu and submenu in Google Docs (Spreadsheet, Document, etc.) and then add some action when the menu or submenu is clicked. This solution is for the following problem I had: I had a lot of programming code blocks in a Google Document. I … Read more
This article shows how you can get TimeZone name and id in PHP from latitude and longitude value by using Google Maps Time Zone API. Note that: You need to put your API Key in the maps api url like this: https://maps.googleapis.com/maps/api/timezone/json?location=$latitude,$longitude×tamp=$time&key=xxxxxxxxxxxxxxxxxxxxx You can get the API key from here: Get API Key Here is … Read more
This article shows how to get latitude and longitude value when you click or move the mouse over Google Map. In previous article, we had seen how we can Display Google Map with Marker when we have latitude and longitude value. Here, we will be using the same code to display the Google Map and … Read more
This article shows how to create a new marker whenever you click or double click on the Google Map. In previous article, we had seen how we can Display Google Map with Marker when we have latitude and longitude value. Here, we will be using the same code and adding a new functionality of displaying … Read more
This article shows how you can generate Google Map and display it in your webpage when you have latitude and longitude coordinates value. We will be using HTML and Javascript to display the Google Map. First of all, you need to get the Google API Key from Google API Console. You need this API key … Read more
Here is a quick PHP code to fetch latitude and longitude of any given place using Google Maps API. CURL is used to fetch data from the API URL. $address = "Kathmandu, Nepal"; $url = "http://maps.google.com/maps/api/geocode/json?address=".urlencode($address); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $responseJson = curl_exec($ch); curl_close($ch); $response = json_decode($responseJson); if ($response->status == … Read more
This article shows: 1) How to create Google Form using standalone HTML file 2) Fetch data from Google Spreadsheet and populate Select box of the HTML Form 3) Populate second select box based on the value selected from first select box 4) Show result data from spreadsheet on form submit Basically, we have a spreadsheet … Read more
This article shows: 1) How to create Google Form using standalone HTML file 2) Email form submitted data to any particular email address Create HTML file We create a Form in a new HTML File. Go to http://script.google.com Go to File -> New -> Html file Type the name of the file, e.g. form.html Write … Read more
This article shows: 1) How to create Google Form using AppScript’s “FormApp” class 2) Send Form URL to any email address using MailApp or GmailApp class 3) How to use Triggers in AppScript 4) How to send Form submit Responses to any email address 5) How to save Form submit Responses to any particular Google … Read more