Author: admin
With its soaring temperatures, May ranks among the hottest months in the Indian subcontinent, prompting a desire to seek cooler destinations to alleviate the heat. Additionally, May marks the official summer vacation period in India, making it an ideal time for family getaways. Fortunately, India offers a plethora of locations to explore in May, ranging from the majestic Himalayas to picturesque hill stations and lush jungles. Whether you prefer backpacking or spending quality time with loved ones, these tourist places in India provide a refreshing escape from the summer heat with their mild climates, allowing you to relax and rejuvenate…
Notion, my absolute favorite tool for storing all sorts of things from web pages to code snippets to recipes, just got better. They’ve released a public API and thus it will be a lot easier for developers to read and write to their Notion workspace from external apps. For instance, you can create a document in Google Docs and export it to Notion while staying inside Docs. Google Sheets users can pull pages from Notion database into their spreadsheet. Any new submissions in Google Forms can be directly saved to Notion and so on! Save Gmail Messages in Notion I…
Would you like to receive notifications in your Telegram messenger when a new form response is submitted in Google Forms. Or maybe send a notification alert to your entire Telegram group when an important event happens. In this step-by-step tutorial, you’ll learn how to create a new Telegram bot and send messages to your Telegram channel and groups through this bot with the help of Google Apps Script. Create a new Telegram Bot Open the telegram app on your desktop or mobile phone and search for the @BotFather bot. This is the official Telegram bot that you can interact with…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
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.…
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…
The Document Studio add-on helps you generate Google Documents from data in Google Sheets and Google Form responses. You can create a template in Google Docs and the add-on will replace the placeholders with answers submitted in the Google Form response. This approach may however create a lot of blank rows in the table for answers that have no response in Google Forms. To give you an example, if the user has not answered the Age question, the generated document will have a row for the {{Age}} question but with a blank value. Remove Blank Rows in Google Docs With…
The month of May in India is characterized by intense heat, yet it transforms into a vibrant and joyous period filled with remarkable festivals. These celebrations, which range from cultural to religious, captivate participants and provide a welcome distraction from the sweltering temperatures. They foster a sense of community and joy, showcasing the rich diversity of the nation through music, dance, and cultural expressions. Many of these events are held in the cooler hills, making them ideal for both sightseeing and trekking. To fully experience these festivities, consider planning your visit to align with one of these delightful celebrations as…
You run a coffee shop and you are looking for a spreadsheet formula to quickly look up prices of the product that your customer has ordered. You have the price matrix stored in a Google Sheet with the names of beverages in one column and the quantity-wise prices in the adjacent columns. When a customer selects their favorite beverage and the cup size, you can use the MATCH function to find the relative position of the column and row in the price table that matches the selected beverage and quantity. Next, use the INDEX function to find the actual price…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
Your organization has a few vacant positions and you are planning to use Google Forms to prepare a pre-interview questionnaire for job applicants. You have created a form and it has all the standard fields where candidates can fill-in their name, email address, phone number, zip code and other information. The form has been prepared but before you make it live, how would you ensure that candidates have entered data in the correct format? And even if the format is proper, is the data itself valid? Can you add a CAPTCHA to Google forms to prevent spam bots? Can you…
The number for Facebook in India is 9232232665. That may sound a bit complex but it’s actually very easy to remember because if you break it down, the last eight digits of the phone number would spell as ‘facebook’. Therefore, you can simply dial 92facebook using the standard key pad of any mobile phone or landline phone and your message will reach Zuckerberg’s server. What does this phone number spell? When you are applying for a new phone number, the telecom company will almost always provide you with a series of numbers from where you can pick one of your…