Recent Additions
NSLOOKUP with Google Apps Script
Anyone who deals with public DNS must have used NSLOOKUP Command Line Tool available in major Operating Systems. Google provides public DNS servers with IP Addresses 8.8.8.8 and 8.8.4.4 which we usually use to resolve a domain name and find value for the various type of DNS records. Traditional DNS queries and responses are sent over UDP or TCP. ![]() Google Public DNS Provides API https://dns.google.com/resolve? which can be used in Apps Script program with UrlFetchApp to fetch the results from Google Public DNS Server. Here is a sample code. var api_url = 'https://dns.google.com/resolve'; // Google Pubic DNS API Url var type = 'MX'; // Type of record to fetch, A, AAAA, MX, CNAME, TXT, ANY var name = 'sbctech.net'; // The domain name to lookup var requestUrl = api_url + '?name=' + name + '&type=' + type; // Build request URL var response = UrlFetchApp.fetch(requestUrl); // Fetch the reponse from API var responseText = response.getContentText(); // Get the response text var json = JSON.parse(responseText); // Parse the JSON text var answers = json.Answer.map(function(ans){return ans.data}).join('\n'); // Get the values Logger.log(answers); // Log the Values After running the above code. Values will be logged in the Logger. 5 alt1.aspmx.l.google.com. 5 alt2.aspmx.l.google.com. 10 alt3.aspmx.l.google.com. 1 aspmx.l.google.com. 10 alt4.aspmx.l.google.com. For more details on API, you can check the Google Documentation
|
reCAPTCHA with Google Apps Script
reCAPTCHA is a free service by Google that protects your forms from spam and abuse. reCAPTCHA uses an advanced risk analysis engine and adaptive CAPTCHAs to keep automated software from engaging in abusive activities on your site. It does this while letting your valid users pass through with ease.
There are lot of tutorial and libraries available for different languages like Java, ASP, Php etc but I could not find a tutorial to integrate the same with Apps Script Web Applications.
Due to some security restrictions, using reCAPTCHA with Apps Script is not straightforward as given on reCAPTCHA guides by Google.
Here are the steps to use it with your Apps Script Projects.
You can watch a live demo here. I hope this tutorial will be useful to you. Are you stuck somewhere in Google Apps Script project? or would you like it to be developed by an expert? Just follow this link and fill the form. We will get back to you as soon as possible.
|
Use of URLFetch with Google Docs native API
Today I have posted two short code which use URLFetch and oAuthConfig to get the list of Documents of a Domain user and share the documents of one user with another user. Here are the links to those 2 tutorials. |
Duynamically adding/removing form elements
I have posted the code, how to add or remove form elements dynamically. Check the whole code and demo here. |
Doodles for your Google Apps Domain using GAS
I have made a spreadsheet application which can be used to update Doodles for your Google Apps Domain. Have a look here for detailed instruction and Application spreadsheet. |
Chart services examples added
I have added few chart examples which will be rendered dynamically with data coming from spreadsheets. Have a look here (Chart services). |
Creating calendar events by submitting UI form
Today, I have posted a new example, which shows you how to create a Calendar event through a UI form. On submission of the form, It will log the event entries in a spreadsheet as well. You may check it here. |
New Examples: Caption Panel, Stack Panel, Scroll Panel, Split Layout Panel
Today i have added few more examples. These examples are very useful. I googled these examples but found nowhere, so I thought to document it. Here are the links. |
1-10 of 20