Posts

Showing posts from August, 2021

How to Request Payments with Razorpay and Google Sheets

Image
Razorpay is a popular payment gateway in India that allows you to accept online payments from customers anywhere in the world. Your customers can pay with credit cards, debit cards, Google Pay, Walmart’s PhonePe and other UPI apps. Razorpay, similar to Stripe, offers a simple no-code tool for generating payment links that you can share with customers over SMS, WhatsApp, or email. When a customer clicks on the link, they are redirected to a secure checkout page hosted on Razorpay where they can can make the payment using their preferred payment method. Here’s a sample payment link generated with Razorpay - https://rzp.io/i/6uBBFWBfv Generate Payment Links with Razorpay It takes one easy step to generate payment links with Razorpay. Sign-in to your Razorpay account , go to the Payment Links section and click on the Create Payment Link button. The built-in wizard is perfect for generating a few links but if you are however looking to generate payment links in bulk for multipl...

How to Share Files in Google Drive with Multiple Users

The Google Drive API makes it easy to share files and folders with other users programmatically with the help of Apps Script. For instance, here’s a snippet of code that will let you share the file with another Google Account user and provide them edit access to the file. Replace the role from writer to reader to give them read-only access . const shareFilesInGoogleDrive = ( fileOrFolderId , emailAddress ) => { Drive . Permissions . insert ( { role : "writer" , // or "reader" or "commenter" value : emailAddress , type : "user" , } , fileOrFolderId , { supportsAllDrives : true , sendNotificationEmails : true , } ) ; } ; It is recommended that you set the sendNotifications flag to true as it will send an email notification when the file is shared with a user who may not have a Google account. Share Files with Multiple Users A limitation of the Drive API is...

How to Share Files in Google Drive with Multiple Users

The Google Drive API makes it easy to share files and folders with other users programmatically with the help of Apps Script. For instance, here’s a snippet of code that will let you share the file with another Google Account user and provide them edit access to the file. Replace the role from writer to reader to give them read-only access . const shareFilesInGoogleDrive = ( fileOrFolderId , emailAddress ) => { Drive . Permissions . insert ( { role : "writer" , // or "reader" or "commenter" value : emailAddress , type : "user" , } , fileOrFolderId , { supportsAllDrives : true , sendNotificationEmails : true , } ) ; } ; It is recommended that you set the sendNotifications flag to true as it will send an email notification when the file is shared with a user who may not have a Google account. Share Files with Multiple Users A limitation of the Drive API ...

Useful npm Tips and Tricks that Developers Should Know

Image
Node Package Manager, or npm, is a tool to install and manage JavaScript packages in your project. And if you have Node installed on your computer, you have already have npm as well. npm Commands You Should Know This is not a tutorial for learning npm, the official docs are good place to get started, but a collection of tips and tricks that will help you do more with the npm utility. Let’s jump right into the list of useful commands: Instantly run packages without installing The NPM registry is a treasure trove for finding packages that do useful stuff and aren’t just for programmers . For instance, the speed-test package shows the speed of your internet connection. The emoj packages helps you search for emojis from the terminal. And wifi-passwords is a simple way to know the password of your current WiFi network. You can run these utility packages directly from the command line without installing them using the npx command. npx speed-test npx emoj unicorn npx pub...

Essential Date Functions for Google Sheets

Image
Dates are internally stored as sequential serial numbers in Google Sheets. This serial number represents the number of days elapsed since December 31, 1899. You can use the DATEVALUE function to convert any date input to a number that represents the date. For instance, both the functions DATEVALUE("Jan 1") and DATEVALUE("01-Jan-2021") return the same number (44197) though the inputs have vastly different formats. The function TODAY() returns the current date while the function NOW() returns the current date and time. Both these functions do not require any arguments and they update when any cell in the Google Sheet is changed. The function NOW() + 2 returns the current date and time plus two days while NOW() - 9/24 returns the date and time 9 hours ago since 1 = 24 hours. The functions YEAR() , MONTH() and DAY() can be used extract the year, month and day of the date that is passed as an argument. The DAYS() function calculates the number of days be...

How to Create a Telegram Bot for Sending Notifications using Google Apps Script

Would you like to receive notifications in your Telegram messenger when a new form response is submitted in Google Forms. Or maybe send a… source:https://ift.tt/3xNeoj8