Tutorial by Examples: at

function createGoogleDriveFileOfMimeType() { var content,fileName,newFile;//Declare variable names fileName = "Test File " + new Date().toString().slice(0,15);//Create a new file name with date on end content = "This is the file Content"; newFile = DriveApp.crea...

function createGoogleDriveTextFile() { var content,fileName,newFile;//Declare variable names fileName = "Test Doc " + new Date().toString().slice(0,15);//Create a new file name with date on end content = "This is the file Content"; newFile = DriveApp.createFile(...

function createGoogleDriveFileWithBlob() { var blob,character,data,fileName,i,L,max,min,newFile,randomNmbr;//Declare variable names fileName = "Test Blob " + new Date().toString().slice(0,15);//Create a new file name with date on end L = 500;//Define how many times to loop...

function processGoogleDriveFolders() { var arrayAllFolderNames,continuationToken,folders,foldersFromToken,thisFolder;//Declare variable names arrayAllFolderNames = [];//Create an empty array and assign it to this variable name folders = DriveApp.getFolders();//Get all folders from G...

function processGoogleDriveFiles() { var arrayAllFileNames,continuationToken,files,filesFromToken,fileIterator,thisFile;//Declare variable names arrayAllFileNames = [];//Create an empty array and assign it to this variable name files = DriveApp.getFiles();//Get all files from Google...

show dbs or db.adminCommand('listDatabases') or db.getMongo().getDBNames()

show collections or show tables or db.getCollectionNames()

Two useful higher-order functions are the binary application (@@) and reverse-application or "pipe" (|>) operators. Although since 4.01 they're available as primitives, it might still be instructive to define them here: let (|>) x f = f x let (@@) f x = f x Consider the problem ...

What is Minification ? It is the process of removing all unnecessary characters from source code without changing its functionality. Normal Syntax If we use normal angular syntax for writing a controller then after minifiying our files it going to break our functionality. Controller (Before mini...

When the range_lookup parameter is either omitted, TRUE, or 1, VLOOKUP will find an approximate match. By "approximate", we mean that VLOOKUP will match on the smallest value that's larger than your lookup_value. Note that your table_array must be sorted in ascending order by lookup values...

You need to import System.ComponentModel for using background worker Imports System.ComponentModel Then Declare a private variable Private bgWorker As New BackgroundWorker You need to create two methods for background worker's DoWork and RunWorkerCompleted events and assign them. Private Su...

You need to decide what your forest structure is going to look like before you install Active Directory for the first time. Are you to have just one domain in your forest, or are you going to have multiple domains in your forest? Active Directory can support multiple sites. Generally sites are spl...

For the layout above your customrow.axml file is as shown below <?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_heigh...

Usually to use the converter, we have to define it as resource in the following way: <converters:SomeConverter x:Key="SomeConverter"/> It is possible to skip this step by defining a converter as MarkupExtension and implementing the method ProvideValue. The following example conve...

<img src="{{ asset('static/images/logo-default.png') }}" alt="Logo"/> <!--Generates path for the file "/web/static/images/logo-default.png" -->

<img src="{{ app.request.getSchemeAndHttpHost() ~ asset('static/images/logo-default.png') }}" alt="Logo"/> <!--Generates path for the file "/web/static/images/logo-default.png" -->

In ExtJS, you can override nearly any method of the framework and replace it with your own. This allows you to modify existing classes without directly modifying the ExtJS source code. Sometimes, you may want to enhance an existing class or provide a sane default property on a class. For example, ...

ECMA 6: const user = new User({ name: 'Stack', password: 'Overflow', }) ; user.save((err) => { if (err) throw err; console.log('User saved!'); }); ECMA5.1: var user = new User({ name: 'Stack', password: 'Overflow', }) ; user.save(function (err) { ...

ECMA6: User.findOne({ name: 'stack' }, (err, user) => { if (err) throw err; if (!user) { console.log('No user was found'); } else { console.log('User was found'); } }); ECMA5.1: User.findOne({ name: 'stack' }, function (err, user) { i...

On error move to labelled code and see if there is a specific error that needs to be handled. Public Const cErrCodeNotNumber = 2262 ' This value must be a number. Public Const cErrCodeNumericOverflow = 2263 ' The number is too large. Private Sub MySub() Dim objConn As ADODB.Connection ...