Author: admin

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…

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 in Google Sheets are internally stored as numbers and the value is equal to the number of days since 30th December 1899, midnight. The time values are stored as a fractional number. For instance, if the date in a cell is Jan 1 1990, Google Sheet will store the cell value as 2. If the date has a time component, say Jan 1 1900 6 PM, the internal date value will be 2.75. The date and time values in Google Sheets are commonly displayed in the dd/mm/yyyy format, depending on your Spreadsheet locale, but this display format can be…

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

All email messages in your Gmail inbox have a permanent web address and you can add this URL to your bookmarks to quickly access that message in the future. You can save these message links in your task list or your meeting notes as they provide important context to the conversation. The URL of any email message is Gmail follows a standard format: https://mail.google.com/mail/u/<<UserId>>/#label/<<Label>>/<<UniqueId>> The UserId is the sequential ID of the currently-logged Gmail account (default is 0). The Label is the name of the Gmail label that the message is in (or use all). The UniqueId is a unique…

There are quite a few way by which you can create multiple email addresses in Gmail. For instance, if your email address is hello@gmail.com, any email that’s addressed to either he.ll.o@gmail.com or hello+world@gmail.com will also be delivered to your main inbox since Gmail ignores dots and anything that’s after the plus symbol in email usernames. Therefore, theoretically speaking, you get an unlimited number of email addresses with one Gmail account. This gets even more interesting if you are using Gmail with GSuite, formerly known Google Apps. Gmail Email Aliases In the case of GSuite or Google Apps, you can assign…