UrTrix - UnRevealed Tricks

Curious to know the exact date when Google cameras captured those aerial and street view photographs of your home (or any other address) on our beautiful planet? Well, you can find the dates easily both in Google Maps and Google Earth. Find the capture date of Satellite Images If you wish to know the date when satellites captured those aerial images that you see in Google Maps, you will have to use Google Earth for that. For some unknown reason, Google doesn’t display these dates on the Google Maps website or the Google Earth web app. Launch the Google Earth app on your desktop, search for any location in the sidebar and, this is important, zoom in an area as much as possible. Now hover your mouse over the map and you should see the capture date of that satellite image in the status bar as seen in the above screenshot. Finding the capture date of Street View Images If you happen to live in a country where Google Street View is available, you can use the Google Maps website i

John Q Public runs a travel agency and they have thousands of clients across the globe. Other than managing tickets and travel itineraries, the agency also keeps a record of passports and visas of their clients to ensure that customers have valid documents at the time of travel. Most countries require that a foreigner’s passport must be valid for at least six months from the date of entry. The US government, therefore, recommends that you renew your passport at least nine months before it expires. Send Automatic Emails with Google Sheets John’s agency is looking for a reminder system that will automatically send an email notification to their customers when their passports have expired or are due for renewal in the next few months. Let’s see how they can build such a workflow in 10 minutes with the help of Mail Merge for Gmail . The idea is simple. We have the customer data in a Google Sheet or a Microsoft Excel spreadsheet. The “Expiry Date” column in the spreadsheet contains t

Google Script imposes quotas around different services. If your script exceeds the specified quota, it throws an exception and terminates execution until the quota is reset. For instance, a Google Script can read 20,000 email messages from Gmail per 24 hours before it throws an exception like Service invoked too many times . The Save Gmail addon downloads email messages from Gmail and writes them as PDF files to your Google Drive. It uses a time-based trigger to run the script in the background or a user can manually run the app to download emails. If a user’s Gmail account has a large number of emails and they try to run the script too frequently, it could exceed the quota and the trigger may fail. It thus help to have some sort of checks in the script that will temporarily pause the script execution if a known exception if thrown. const suspend = ( timeInMinutes = 60 ) => { CacheService . getScriptCache ( ) . put ( 'SUSPEND' , Date . now ( ) , timeInMin

The Indian numbering and currency system widely uses lakhs and crores for writing large numbers. The term lakh means one hundred thousand while a crore represents ten million. A billion is written as hundred crores and there exist even higher denominations like arab , kharabh or neel which is equivalent to 10 trillion . If you would like to write financial numbers in Google Sheets using the Indian Numbering system (lakhs, crores), here’s a custom Sheets function INR() that can spell the numeric value in words for you. Also see: Make Invoices with Google Sheets and Forms Convert Numbers to Indian Rupees in Google Sheets To get started, go to your Google Sheet, click the Tools menu and select Script Editor. Copy-paste the function below inside the Script Editor and chose File > Save to save your changes. Now switch to the Google Sheet, type =INR(123) in any cell and it will instantly spell the number in words using the lakhs and crores system. The function was originall

With Google Drive, you can store files in the cloud and share them easily with anyone. Open any file in Google Drive, click the Share button and you’ll get a URL (link) that others can use to access your file. This is common knowledge but Google Drive has plenty of URL tricks up its sleeve that will make these simple Drive links even more powerful. Google Drive URL Tricks Google Drive Web Viewer Google Drive includes a built-in web viewer so people can view your shared files - from Microsoft Office documents to videos to AutoCAD drawings - directly in their browser. You can use this web viewer to view online files without having to download the files to your computer. https://docs.google.com/viewer?url=FILE_URL Replace FILE_URL with the full http link of the online document and anyone can view your file in the browser itself. Here’s an example . Reader Mode for Google Drive Files You can view native Google documents in reader mode (sans the Google UI) by simply replac

When you create a production build for your React App, the output folder contains the main index.html file and associated JavaScript and CSS files are added in the /static/js and /static/css folders respectively. If you are to combine all these JS and CSS files of React App in a single bundle, you can use gulp . Here’s how: Go to the command line and install the gulp packages as dev dependencies in your package.json file. npm install --save-dev gulp gulp-inline-source gulp-replace Next, create a .env file in your project root folder and set the following environment variable to disable source maps. INLINE_RUNTIME_CHUNK=false GENERATE_SOURCEMAP=false SKIP_PREFLIGHT_CHECK=true Next, create a gulpfile.js file in the root folder. const gulp = require ( 'gulp' ) const inlinesource = require ( 'gulp-inline-source' ) const replace = require ( 'gulp-replace' ) gulp . task ( 'default' , ( ) => { return gulp . src ( './

This guide explains how you can update the library version in your Google Script. It is specifically written for File Upload Forms but the steps are similar for any Apps Script Projects. Open the Google Sheet associated with your form and go to Tools > Script Editor. Inside the Script Editor, go to the Resources menu and choose Libraries You’ll see a list of libraries used by your Google Script project. For the FormsApp library, open the Version dropdown and choose the highest version of the library. Click the Save button to upgrade your project to the new library. Next, go to the Publish menu and choose Deploy as Web App. Choose a new project version and click update to publish a new version of your Apps Script web app. Your Google Script project is now updated to use the latest version of the included libraries. source:https://ift.tt/3aem3uN

Custom support systems like Freshdesk, Zoho Desk, or Zendesk offer an email address - like support@example.com - for quickly creating customer tickets without having to fill any complicated web forms . Any email message sent to your support email address automatically gets converted into a ticket and a unique ticket ID gets assigned to the support request. When a ticket is created from an email address, the email subject becomes the ticket title, the email body becomes the ticket description and the most important part, the customer’s name and email address is pulled from the FROM field of the email message header. This is important because when your helpdesk agents respond to a ticket, the replies are sent directly to the customer. Email Ticketing with Gmail Forwards - The Problem This system works perfect when the customer sends an email message directly to the help desk email but imagine if they send an email to you, the support agent, and it is your job to create a support