Posted on

Unleashing Greatness: Alexander the Great’s Journey With Generative AI

Alexander the Great’s Greatness Is a Subject of Fascination and Admiration for Several Reasons

Alexander, by age 30, created a vast empire from Greece to India, showcasing tactical brilliance and leadership. His conquests led to the Hellenistic era, blending Greek culture with conquered regions impacting art, science, and philosophy. A student of Aristotle, he valued intellectual pursuits and founded cities of learning. Alexander's visionary leadership aimed at a unified world empire, and he showed tolerance towards conquered people's customs, facilitating cultural assimilation. His legacy persisted through the Diadochi, spreading Hellenistic culture and influencing future leaders.

Aristotle's Role in Mentoring Alexander the Great

Aristotle served as Alexander's tutor, shaping his education and influencing his intellectual and leadership development. Key areas of impact include philosophy and ethics, where Aristotle fostered critical thinking and ethical values. Exposure to Greek literature and poetry contributed to Alexander's appreciation for culture and the arts. Aristotle's teachings on science and natural philosophy provided a foundation for Alexander's interactions with diverse cultures. While not a conventional political mentor, Aristotle's insights on governance informed Alexander's leadership and strategies. Aristotle's emphasis on critical thinking played a role in Alexander's military strategy, and his rigorous teaching methods instilled discipline and intellectual rigor in Alexander's pursuit of knowledge.

Posted on

Using PostgreSQL® JSON Functions To Navigate Reviews of Restaurants in India

The original idea behind relational databases was "structure, then data": you needed to define what the data looked like before being able to insert any content. This strict data structure definition helped keeping datasets in order by verifying data types, referential integrity, and additional business conditions using dedicated constraints.

But sometimes, life can't be predicted, and data can take different shapes. To enable some sort of flexibility, modern databases like PostgreSQL® started adding semistructured column options JSON, where only a formal check on the shape of the data is done.

Posted on

A September Of Never Ending Adventures (2023 Wallpapers Edition)

September is just around the corner, and that means it’s time for some new wallpapers! For more than twelve years already, our monthly wallpapers series has been the perfect occasion for artists and designers from all across the globe to challenge their creative skills and dive into a little project just for fun. Telling the stories they want to tell, using the tools they love. This always makes for an inspiring and unique collection of wallpapers each month anew, and, of course, this month is no exception.

In this post, you’ll find wallpapers for September 2023, created by the community for the community. The designs come in versions with and without a calendar and can be downloaded for free. As a little bonus goodie, we also compiled some timeless favorites from past September editions at the end of this post. Maybe you’ll spot one of your almost-forgotten favorites in there, too? A big thank-you to everyone who shared their artwork with us — this post wouldn’t exist without you!

  • You can click on every image to see a larger preview,
  • We respect and carefully consider the ideas and motivation behind each and every artist’s work. This is why we give all artists the full freedom to explore their creativity and express emotions and experience through their works. This is also why the themes of the wallpapers weren’t anyhow influenced by us but rather designed from scratch by the artists themselves.
  • Submit a wallpaper!
    Did you know that you could get featured in our next wallpapers post, too? We are always looking for creative talent.
Palette Of Autumn

“The stunning transformation of nature during the fall season, with its rich hues and textures, served as a primary inspiration. Capturing the essence of autumn’s beauty in a digital format was a central goal.” — Designed by Farhan Srambiyan from India.

Rainy Flowers

Designed by Teodora Vasileva from Bulgaria.

Science Is Magic

“Science is like magic, except it’s real.” — Designed by Bhabna Basak from India.

Get Fired

Designed by Ricardo Gimenes from Sweden.

Made In China

Designed by Ricardo Gimenes from Sweden.

National Lazy Mom’s Day

“Because every now and then, we deserve the right to enjoy a lazy day! No chores, just a day to oneself.” — Designed by Storyville Tales from the United Kingdom.

Oldies But Goodies

Whether it’s memories of summer vacation, the approach of fall, or, well, cats — below you’ll find a selection of September goodies from our wallpapers archives that are just too good to be forgotten. Please note that these designs don’t come with a calendar. Enjoy!

Autumn Rains

“This autumn, we expect to see a lot of rainy days and blues, so we wanted to change the paradigm and wish a warm welcome to the new season. After all, if you come to think of it: rain is not so bad if you have an umbrella and a raincoat. Come autumn, we welcome you!” — Designed by PopArt Studio from Serbia.

Terrazzo

“With the end of summer and fall coming soon, I created this terrazzo pattern wallpaper to brighten up your desktop. Enjoy this month!” — Designed by Melissa Bogemans from Belgium.

Funny Cats

“Cats are beautiful animals. They’re quiet, clean, and warm. They’re funny and can become an endless source of love and entertainment. Here for the cats!” — Designed by UrbanUI from India.

Cacti Everywhere

“Seasons come and go, but our brave cactuses still stand. Summer is almost over, and autumn is coming, but the beloved plants don’t care.” — Designed by Lívia Lénárt from Hungary.

Stay Or Leave?

Designed by Ricardo Gimenes from Sweden.

Listen Closer… The Mushrooms Are Growing

“It’s this time of the year when children go to school and grown-ups go to collect mushrooms.” — Designed by Igor Izhik from Canada.

Flower Soul

“The earth has music for those who listen. Take a break and relax and while you drive out the stress, catch a glimpse of the beautiful nature around you. Can you hear the rhythm of the breeze blowing, the flowers singing, and the butterflies fluttering to cheer you up? We dedicate flowers which symbolize happiness and love to one and all.” — Designed by Krishnankutty from India.

Summer Ending

“As summer comes to an end, all the creatures pull back to their hiding places, searching for warmth within themselves and dreaming of neverending adventures under the tinted sky of closing dog days.” — Designed by Ana Masnikosa from Belgrade, Serbia.

Hungry

Designed by Elise Vanoorbeek from Belgium.

Never Stop Exploring

Designed by Ricardo Gimenes from Sweden.

Bear Time

Designed by Bojana Stojanovic from Serbia.

Geometric Autumn

“I designed this wallpaper to remind everyone that autumn is here.” — Designed by Advanced Web Ranking from Romania.

Maryland Pride

“As summer comes to a close, so does the end of blue crab season in Maryland. Blue crabs have been a regional delicacy since the 1700s and have become Maryland’s most valuable fishing industry, adding millions of dollars to the Maryland economy each year. With more than 455 million blue crabs swimming in the Chesapeake Bay, these tasty critters can be prepared in a variety of ways and have become a summer staple in many homes and restaurants across the state. The blue crab has contributed so much to the state’s regional culture and economy, in 1989 it was named the State Crustacean, cementing its importance in Maryland history.” — Designed by The Hannon Group from Washington DC.

Batmom

Designed by Ricardo Gimenes from Sweden.

Still In Vacation Mood

“It’s officially the end of summer and I’m still in vacation mood, dreaming about all the amazing places I’ve seen. This illustration is inspired by a small town in France, on the Atlantic coast, right by the beach.” — Designed by Miruna Sfia from Romania.

Long Live Summer

“While September’s Autumnal Equinox technically signifies the end of the summer season, this wallpaper is for all those summer lovers, like me, who don’t want the sunshine, warm weather, and lazy days to end.” — Designed by Vicki Grunewald from Washington.

Lucha Libre

“This month is Mexico’s independence day and I decided to illustrate one of the things Mexico’s best known for: the Lucha Libre.” — Designed by Maria Keller from Mexico.

Early Autumn

“September is usually considered as early autumn so I decided to draw some trees and leaves. However, nobody likes that summer is coming to an end, that’s why I kept summerish colors and style.” — Designed by Kat Gluszek from Germany.

Wine Harvest Season

“Welcome to the wine harvest season in Serbia. It’s September, and the hazy sunshine bathes the vines on the slopes of Fruška Gora. Everything is ready for the making of Bermet, the most famous wine from Serbia. This spiced wine was a favorite of the Austro-Hungarian elite and was served even on the Titanic. Bermet’s recipe is a closely guarded secret, and the wine is produced by just a handful of families in the town of Sremski Karlovci, near Novi Sad. On the other side of Novi Sad, plains of corn and sunflower fields blend in with the horizon, catching the last warm sun rays of this year.” — Designed by PopArt Studio from Serbia.

The Rebel

Designed by Ricardo Gimenes from Sweden.

National Video Games Day Delight

“September 12th brings us National Video Games Day. US-based video game players love this day and celebrate with huge gaming tournaments. What was once a 2D experience in the home is now a global phenomenon with players playing against each other across statelines and national borders via the internet. National Video Games Day gives gamers the perfect chance to celebrate and socialize! So grab your controller, join online and let the games begin!” — Designed by Ever Increasing Circles from the United Kingdom.

Posted on

Finding The Balance (September 2022 Desktop Wallpapers Edition)

Lush green slowly turning into yellows, reds, and browns in the Northern hemisphere; nature awakening from its slumber in the Southern part of the world: September is a time of change. A chance to leave old habits behind and embrace the beginning of something new. And, well, sometimes it only takes a small change in routines to spark fresh inspiration and, who knows, maybe even great ideas.

With that in mind, we embarked on our monthly wallpapers challenge more than eleven years ago, and since then, artists and designers from all across the globe have accepted the challenge and submitted their designs to it to cater for a bit of variety on your desktop and mobile screens. Of course, it wasn’t any different this time around.

This post features their wallpapers for September 2022. All of them come in versions with and without a calendar, so it’s up to you to decide if you want to have the month at a glance or keep things simple. As a little bonus goodie, we also collected some timeless favorites from past September editions at the end of this post. A big thank-you to all the artists who have submitted their wallpapers. This post wouldn’t exist without you.

  • You can click on every image to see a larger preview,
  • We respect and carefully consider the ideas and motivation behind each and every artist’s work. This is why we give all artists the full freedom to explore their creativity and express emotions and experience through their works. This is also why the themes of the wallpapers weren’t anyhow influenced by us but rather designed from scratch by the artists themselves.
  • Submit a wallpaper!
    Did you know that you could get featured in our next wallpapers post, too? We are always looking for creative talent.
Cultivating Community

“Climate action, peace, justice, and inclusive societies — we’re proud to be aligning our volunteer goals with the 2030 Agenda for Sustainable Development. Mad Fish Digital encourages team members to recognize the non-profit organizations they care about by giving their time throughout the year. We encourage you to look to your community for volunteer opportunities and use your skills and passion to make a positive difference!” — Designed by Mad Fish Digital from Portland, OR.

Autumn Foliage

“‘Autumn is a second spring when every leaf is a flower.’ (Albert Camus) Our September calendar aims to make you feel the autumn coziness through your desktop. The warm tones of autumn leaves, the wet raincoat, and squeaky rain boots are the first signs that autumn is knocking at our doors.” — Designed by PopArt Studio from Serbia.

Sweet Dreams

Designed by Ricardo Gimenes from Sweden.

A Cozy Evening

“The leaves are changing their colors now, but the nights are still warm. There’s something different tonight… do you feel it? It’s like the air tastes like a soft marshmallow and you’re sitting by a warm fire in the middle of the forest, while the nature that surrounds you is transforming. It’s ok, small changes are normal and all you can do is sit back, look at the stars and embrace the world that evolves around you.” — Designed by Creative Pinky from The Netherlands.

The Rebel

Designed by Ricardo Gimenes from Sweden.

The First Harbinger of Autumn

“Autumn is an incredibly beautiful time — its aromas are so bright that they easily come to mind. One of the brightest autumn aromas is the smell of fallen oak leaves. It inspired our designers to create this calendar. More free calendars can be found in our post.” — Designed by MasterBundles from Ukraine.

Oldies But Goodies

Below you’ll find a selection of September wallpapers from our archives that are just too good to be forgotten. Please note that these designs don’t come with a calendar. Enjoy!

Wine Harvest Season

“Welcome to the wine harvest season in Serbia. It’s September, and the hazy sunshine bathes the vines on the slopes of Fruška Gora. Everything is ready for the making of Bermet, the most famous wine from Serbia. This spiced wine was a favorite of the Austro-Hungarian elite and was served even on the Titanic. Bermet’s recipe is a closely guarded secret, and the wine is produced by just a handful of families in the town of Sremski Karlovci, near Novi Sad. On the other side of Novi Sad, plains of corn and sunflower fields blend in with the horizon, catching the last warm sun rays of this year.” — Designed by PopArt Studio from Serbia.

Sunny September

“September greets us and invites us to enjoy warm and sunny days.” — Designed by LibraFire from Serbia.

Go Bananas

Designed by Ricardo Gimenes from Sweden.

Terrazzo

“With the end of summer and fall coming soon, I created this terrazzo pattern wallpaper to brighten up your desktop. Enjoy this month!” — Designed by Melissa Bogemans from Belgium.

Funny Cats

“Cats are beautiful animals. They’re quiet, clean, and warm. They’re funny and can become an endless source of love and entertainment. Here for the cats!” — Designed by UrbanUI from India.

Cacti Everywhere

“Seasons come and go, but our brave cactuses still stand. Summer is almost over, and autumn is coming, but the beloved plants don’t care.” — Designed by Lívia Lénárt from Hungary.

Long Live Summer

“While September’s Autumnal Equinox technically signifies the end of the summer season, this wallpaper is for all those summer lovers, like me, who don’t want the sunshine, warm weather and lazy days to end.” — Designed by Vicki Grunewald from Washington.

Listen Closer… The Mushrooms Are Growing

“It’s this time of the year when children go to school and grown-ups go to collect mushrooms.” — Designed by Igor Izhik from Canada.

Autumn Rains

“This autumn, we expect to see a lot of rainy days and blues, so we wanted to change the paradigm and wish a warm welcome to the new season. After all, if you come to think of it: rain is not so bad if you have an umbrella and a raincoat. Come autumn, we welcome you!” — Designed by PopArt Studio from Serbia.

Maryland Pride

“As summer comes to a close, so does the end of blue crab season in Maryland. Blue crabs have been a regional delicacy since the 1700s and have become Maryland’s most valuable fishing industry, adding millions of dollars to the Maryland economy each year. With more than 455 million blue crabs swimming in the Chesapeake Bay, these tasty critters can be prepared in a variety of ways and have become a summer staple in many homes and restaurants across the state. The blue crab has contributed so much to the state’s regional culture and economy, in 1989 it was named the State Crustacean, cementing its importance in Maryland history.” — Designed by The Hannon Group from Washington DC.

Stay Or Leave?

Designed by Ricardo Gimenes from Sweden.

Flower Soul

“The earth has music for those who listen. Take a break and relax and while you drive out the stress, catch a glimpse of the beautiful nature around you. Can you hear the rhythm of the breeze blowing, the flowers singing, and the butterflies fluttering to cheer you up? We dedicate flowers which symbolize happiness and love to one and all.” — Designed by Krishnankutty from India.

Colors Of September

“I love September. Its colors and smells.” — Designed by Juliagav from Ukraine.

Red Beetle

Designed by Oxana Kostromina from Russia/Germany.

Still In Vacation Mood

“It’s officially the end of the summer and I’m still in vacation mood, dreaming about all the amazing places I’ve seen. This illustration is inspired by a small town in France, on the Atlantic coast, right by the beach.” — Designed by Miruna Sfia from Romania.

Summer Is Leaving

“It is inevitable. Summer is leaving silently. Let us think of ways to make the most of what is left of the beloved season.” — Designed by Bootstrap Dashboards from India.

Office

“Clean, minimalistic office for a productive day.” — Designed by Antun Hiršman from Croatia.

Viva Mexico

“This month is Mexico’s independence day and I decided to illustrate in my wallpaper one of the things Mexico’s best known for: the Lucha Libre.” — Designed by Maria Keller from Mexico.

Finding The Balance

“One evening last week I felt a little stressed, so I decided to have a short walk outside. When I went out of the door, I saw two young hares jumping around, and a bat which flew just over my head. I sat down on a garden chair and watched while Jupiter slowly rose above the trees. The crisp air of the autumn night reminded me of how the seasons keep changing. Here in Finland the differences between seasons are extremely large, as both the temperatures and the duration of sunlight vary a lot. However, twice a year on the equinoxes everything is in balance. I hope we all can find the same balance in our own lives.” — Designed by Tuomas Karjalainen from Finland.

Weekend Relax

“I’m looking forward for the weekend to enjoy drinks with friends!” — Designed by Robert from the United States.

Batmom

Designed by Ricardo Gimenes from Sweden.

#Spring

“Such a lovely time of the year in Melbourne!” — Designed by Tazi from Australia.

Posted on

Make A Wish (May 2022 Desktop Wallpapers Edition)

We always try our best to challenge your creativity and get you out of your comfort zone. In all these years we’ve been running it, our monthly wallpapers series has turned out to be the perfect occasion to do just that: to put your creative skills to the test, try out a new technique you haven’t tried before, tell a story that matters to you, or indulge in a little project just for fun. And well, the wallpaper submissions that reach us every month, always make for a unique collection of community artworks, ready to adorn desktop and mobile screens. It wasn’t any different this time around.

Created with love by designers and artists from across the globe, the wallpapers in this collection all come in versions with and without a calendar for May 2022. As a little bonus goodie, we also compiled some favorites from past May editions at the end of this post. Thank you to everyone who took on the challenge and shared their wallpapers with us — you’re smashing!

  • You can click on every image to see a larger preview,
  • We respect and carefully consider the ideas and motivation behind each and every artist’s work. This is why we give all artists the full freedom to explore their creativity and express emotions and experience through their works. This is also why the themes of the wallpapers weren’t anyhow influenced by us but rather designed from scratch by the artists themselves.
  • Submit a wallpaper!
    Did you know that you could get featured in our next wallpapers post, too? We are always looking for creative talent.
Kira

“On April 23, in Odesa, a random Russian missile killed three-month old Kira Glodan, her mother Valerie and grandmother, destroying their home while her father was out buying products. During war, many such tragedies happen, sometimes every day. And many of these tragedies do not hit media. Still, I felt I had to respond, it is the least I can do — help spread the word. War, please stop.” — Designed by Vlad Gerasimov from Georgia.

Hello May

“The longing for warmth, flowers in bloom, and new beginnings is finally over as we welcome the month of May. From celebrating nature on the days of turtles and birds to marking the days of our favorite wine and macarons, the historical celebrations of the International Workers’ Day, Cinco de Mayo, and Victory Day, to the unforgettable ‘May the Fourth be with you’. May is a time of celebration — so make every May day count!” — Designed by PopArt Studio from Serbia.

The Impenetrable Wall Of Love

“I was trying to draw a simple picture, with people made of cardboard. But I guess my thoughts of war leak through. War, please stop.” — Designed by Vlad Gerasimov from Georgia.

The Monolith

Designed by Ricardo Gimenes from Sweden.

Blooming May

“In spring, especially in May, we all want bright colors and lightness, which was not there in winter. Our designers decided to convey these feelings in the May calendar. We have collected more variety of calendars here. They are free to download. :)” — Designed by MasterBundles from Ukraine.

Toucan’t

Designed by Ricardo Gimenes from Sweden.

Looking For The Treasure

“This month we embark on an adventure to find the treasure island. Do you come with us?” — Designed by Veronica Valenzuela Jimenez from Spain.

Tree Colors

“During spring, trees awake from the cold season. With this desktop wallpaper I want to think about nice colors of flowers and leaves. It’s time to get outside!” — Designed by Philippe Brouard from France.

Oldies But Goodies

So many beautiful and inspiring designs have seen the light of day since we embarked on this wallpapers journey more than eleven years ago. And since they are just too good to be forgotten deep down in the archives, we compiled some timeless wallpaper favorites below. Please note that these designs don’t come with a calendar.

Sweet Lily Of The Valley

“The ‘lily of the valley’ came earlier this year. In France, we celebrate the month of May with this plant.” — Designed by Philippe Brouard from France.

Understand Yourself

“Sunsets in May are the best way to understand who you are and where you are heading. Let’s think more!” — Designed by Igor Izhik from Canada.

Poppies Paradise

Designed by Nathalie Ouederni from France.

Spring Gracefulness

“We don’t usually count the breaths we take, but observing nature in May, we can’t count our breaths being taken away.” — Designed by Ana Masnikosa from Belgrade, Serbia.

From Nope To Hope

“Hope helps us define what we want in our futures and is part of the self-narrative about our lives we all have running inside our minds. Whether we think about it or not, hope is a part of everyone’s life. Everyone hopes for something. It’s an inherent part of being a human being.” — Designed by Hitesh Puri from Delhi, India.

Geo

Designed by Amanda Focht from the United States.

Lake Deck

“I wanted to make a big painterly vista with some mountains and a deck and such.” — Designed by Mike Healy from Australia.

Be On Your Bike!

“May is National Bike Month! So, instead of hopping in your car, grab your bike and go. Our whole family loves that we live in our bike-friendly community. So, bike to work, to school, to the store, or to the park — sometimes it is faster. Not only is it good for the environment, but it is great exercise!” — Designed by Karen Frolo from the United States.

Who Is Your Mother?

“Someone who wakes up early in the morning, cooks you healthy and tasty meals, does your dishes, washes your clothes, sends you off to school, sits by your side and cuddles you when you are down with fever and cold, and hugs you when you have lost all hopes to cheer you up. Have you ever asked your mother to promise you never to leave you? No. We never did that because we are never insecure and our relationship with our mothers is never uncertain. We have sketched out this beautiful design to cherish the awesomeness of motherhood. Wishing all a happy Mothers Day!” — Designed by Acodez IT Solutions from India.

Make A Wish

Designed by Julia Versinina from Chicago, USA.

Enjoy May!

“Springtime, especially Maytime, is my favorite time of the year. And I like popsicles — so it’s obvious isn’t it?” — Designed by Steffen Weiß from Germany.

The Green Bear

Designed by Pedro Rolo from Portugal.

Add Color To Your Life!

“This month is dedicated to flowers, to join us and brighten our days giving a little more color to our daily life.” — Designed by Verónica Valenzuela from Spain.

Lookout At Sea

“I wanted to create something fun and happy for the month of May. It’s a simple concept, but May is typically the time to adventure out into the world and enjoy the best of Spring.” — Designed by Alexander Jubinski from the United States.

The Off-Hours Guardian

“In May, we are marking Labour Day, the international holiday celebrating workers’ achievements and urging fair pay and better working conditions. But for many, this day will be a reminder of countless hours of overtime, stress, and strain caused by tight deadlines, lack of workers’ rights for freelancers, and a paycheck that covers just the basics. Our thoughts are with all of you who will spend International Workers’ Day at their jobs, with freelancers fighting for their rights, and with anyone who feels difficulty maintaining their work-life balance.” — Designed by PopArt Studio from Serbia.

Magical Sunset

“I designed Magical Sunset as a friendly reminder to take a moment and enjoy life around you. Each sunset and sunrise brings a new day for greatness and a little magic.” — Designed by Carolyn Warcup from the United States.

Tentacles

Designed by Julie Lapointe from Canada.

Field Wild Flowers

“Springtime festival celebrated with May blossoms.” — Designed by Richard George Davis from South Africa.

Game Boy

Designed by Sander Geenen from Belgium.

May The Force Be With You

“Yoda is my favorite Star Wars character and ‘may’ has funny double meaning.” — Designed by Antun Hirsman from Croatia.

Posted on

How to Generate Dynamic QR Codes to Collect Payments through UPI

The BHIM UPI payment system has transformed the way we pay for goods and services in India. You scan a QR Code with your mobile phone, enter the secret PIN and the money gets instantly transferred from your bank account to the merchant’s bank account. There’s no transaction fee, the money is transferred in real-time and no data of the payer is shared with the payee.

Our online store initially accepted payments through credit cards only but after we added the UPI QR Code on the checkout page, more that 50% of customers in India are making payments through UPI. Other than instant payouts, the big advantage of UPI is that the merchant need not pay any transaction fee to PayPal or Stripe.

UPI QR Code

Create Dynamic UPI QR Codes

When you sign-up for any UPI app, be it PhonePe, Paytm, Google Pay, WhatsApp, Amazon Pay or any other BHIM UPI app, they will all provide you with a downloadable QR Code that you can attach in emails, invoices, embed on your website or print and paste near your billing counter. Customers will scan this QR Code, enter the billing amount, and confirm the payment.

The QR code provided by UPI apps are static and thus do not include the amount that has to be paid by the customer. Our UPI QR Code generator is designed solve this problem. It generates a dynamic QR Code that includes the amount and thus the merchant can control how much the customer has to pay after scanning the QR code.

Visit labnol.org/upi to generate dynamic QR codes for UPI payments. The website does not collect, store or process any of the data you enter in the QR Code form.

UPI QR Code in Google Sheets

If you are using Document Studio to generate customer invoices inside Google Sheets, you can write a simple function to embed the payment QR code in your PDF invoices. QR Codes can be added in emails as well that are sent through Gmail Mail Merge

QR Code in Google Sheets

Go to your Google Sheet, click the Extensions menu and choose Apps Script Editior from the dropdown. Copy-paste the UPI function inside the script editor and save your project.

/**
 * Create a UPI QR Code for payments
 *
 * @param {29.99} amount The amount requested in INR
 * @param {"xyz@upi"} merchant_upi UPI address of the merchant
 * @param {"Blue Widgets"} merchant_name Full name of the payee
 * @param {"250"} size The size of the QR image in pixels
 * @return The QR Code
 * @customfunction
 */

function UPI(amount, merchant_upi, merchant_name, size) {
  if (amount.map) {
    return amount.map(function (amount2) {
      return UPI(amount2, merchant_upi, merchant_name, size);
    });
  }

  const googleChart = `https://chart.googleapis.com/chart?cht=qr&choe=UTF-8`;
  const upiData = `upi://pay?pn=${merchant_name}&pa=${merchant_upi}&am=${amount}`;
  return `${googleChart}&chs=${size}x${size}&chl=${encodeURIComponent(upiData)}`;
}

Now you can add the QR code to any cell in the Google Sheet by using the UPI function in combination with the IMAGE function as shown in the following example:

=IMAGE(UPI("19.95", "digitalinspirationindia@icici", "Digital Inspiration", "200"))

How UPI QR Codes are Generated

Internally, the QR Code for UPI payments contains the merchant’s UPI ID, the amount to be paid and the payee name in the following format:

upi://pay?pa=<merchant_upi_id>&pn=<payee_name>&am=<amount>&tn=<transaction_notes>

If the am parameter is not provided in the UPI url, the customer will have to manually enter the amount in the UPI app before confirming the payment. The UPI deeplink specs also recommend using the mam (minimum amount) parameter to specify the minimum amount that the customer has to pay. Set its value to “null” so that the customer cannot pay less than the specified amount.

You may also include custom notes in the QR code and these will be sent to you in the transaction history of your bank statement.

Posted on

India’s CoWIN Portal Adds New Vaccination Status Look-Up API

CoWIN, a portal for COVID-19 vaccination registration created by the Indian Ministry of Health and Family Welfare, has been updated to include a new API that will allow businesses to look up the vaccination status of customers and clients. The tool allows individuals to authorize access to this health data on behalf of businesses.

Posted on

Web development company in India

Login2Design Technologies is one of the top mobile app development companies and
best web development companies in Jaipur.
We provide Ui/UX Design Services, Graphic Design Services, Landing Page Design, PHP development,
AngularJS Frontend Development, Logo Design Services, Ios app development, Android app development,
Mobile app development, HTML5, node js development, hybrid app development, CakePHP web development, Web Development Services, Bootstrap Framework, Laravel Development Services, etc.
Get services from the best web design and development company in Jaipur.
We provide the best web development service near you.
For more details visit us at- https://cutt.ly/4nVAzmD

Posted on

QuickBooks vs TallyPrime

Overview

It's no secret that both QuickBooks and TallyPrime software are key dominant players in the Indian market. QuickBooks is a cloud-based accounting software from Intuit, with provisioning for Indian currency, Indian tax regulations, and automatic synchronization of QuickBooks accounting information with the Company’s bank transaction information. The best thing is its UI which is way better and is a monthly payment software, making it more convenient for SMEs. Tally Prime, on the other hand, is basically a one-time payment software and is especially for the Indian market, keeping in mind that the Indian enterprise-level organizations need a regulatory regime.

Evolution

QuickBooks was founded in 1983, and it has slowly but steadily climbed the ranks in order to become the giant it is today. Although it was founded in 1983, it took about 19 years to release the first version of QuickBooks. But, after the QuickBooks release, it went through a lot of changes and is still changing to this day; its software has evolved, adding more features and functionality. QuickBooks, at present, is available on a wider international scale throughout the globe. Tally, on the other hand, released its new version TallyPrime, which empowers business owners to be more efficient. Like QuickBooks, Tally has also gone through a lot of changes for the past 30 years, and at present, their newest version TallyPrime is on the Indian market.

Posted on

Hi everyone, I’m lwalidjind

Hey all members,
My name is Lwalidjind amd I am from India. I just found this community and it looks nice with great content and expert members. So, i did not make any delay to register here.

Posted on

HELLO IAM Ronkey

Hey all members,
My name is Kapil amd I am from India. I just found this community and it looks nice with great content and expert members. So, i did not make any delay to register here

Posted on

How Businesses can Check Health Status of Employees with Aarogya Setu

Aarogya Setu

The Government of India has recently introduced an “open API” for Aarogya Setu, the world’s most popular contact tracing app that has more than 110 million users across the Android and iOS platform. The Aarogya Setu API, in simple English, will help organizations automatically check the health status of their employees.

Currently, when an employee enters his or her office, they are required to show their Aarogya Setu app at the reception and are allowed entry only if the status is green meaning they haven’t been in proximity of an infected person. With the API in places, business can automatically know the risk level of their employees.

This could save some effort since the HR department can create a Google Sheet with the phone numbers of all employees and a Google Script can automatically get the health status of each number in that list. The script can then email the list of employees who are at moderate or high risk for further action.

Also see: Covid-19 India Tracker

How to Use the Aarogya Setu API

You can sign-up for the API at openapi.aarogyasetu.gov.in. This isn’t a straightforward process - you have to send an email and approval is granted only if your business has more than 50 employees. Assuming your business has been granted access to the API, here’s how you can use it with Google Sheets and Google Scripts.

class AaryogyaSetu {
  constructor({ apiKey, userName, password }) {
    this.apiKey = apiKey;
    this.userName = userName;
    this.password = password;
    this.api = "https://api.aarogyasetu.gov.in";
    this.token = null;
  }

  /* Get the authorization token for the header
     The token is valid for 1 hour */
  getToken() {
    if (this.token === null) {
      const { token } = this.fetch("/token", {
        username: this.userName,
        password: this.password,
      });
      this.token = token;
    }
    return this.token;
  }

  /* Request Aarogya Setu status of a
     user using phone number of the user */
  getUserStatus(phone_number) {
    const { request_id, request_status } = this.fetch("/userstatus", {
      phone_number,
    });
    return request_status !== "Approved";
  }

  fetch(endpoint, payload) {
    const mimeType = "application/json";
    const headers = {
      Accept: mimeType,
      "Content-Type": mimeType,
      "x-api-key": this.apiKey,
    };
    if (endpoint !== "/token") {
      headers["Authorization"] = this.getToken();
    }
    const options = {
      method: "POST",
      contentType: mimeType,
      headers: headers,
      payload: JSON.stringify(payload),
    };
    const url = `${this.api}${endpoint}`;
    const response = UrlFetchApp.fetch(url, options);
    return JSON.parse(response.getContentText());
  }
}

/* The API key can be found in your Aarogya Setu dashboard */
const main = () => {
  const aarogyasetu = new AaryogyaSetu({
    apiKey: "xyz1234",
    username: "amit@labnol.org",
    password: "India1234",
  });

  const phoneNumber = "9760008500";
  const userStatus = aarogyasetu.getUserStatus(phoneNumber);
  if (!userStatus) {
    console.log(`The Aarogya Setu status of ${phoneNumber} was denied`);
  }
};

When you make a request to the Aarogya Setu API requesting the risk status of an employee identified by their phone number, a notification is sent to the Aarogya Setu user. If they approve the status (or if they have pre-approved the request earlier), a POST request is made to your callback URL with the help status of the user.

The Google Script can be published as a web app with the doPost method and that be used as a callback URL for the Open API.

Posted on

Hi everyone, I’m mooweb96

Hello to every one,
I an individual from India. I am planning to start my own startup based on digitial marketing. As we all know the future is digital. Because of covid-19 most of the businesses are moving into the world of business. I am looking a great potenitial in near future for the digital marketers. I am working on my personal website, it will be online vaery-soon. So I request you to all, please shares yours experiences or your stories, so that I can lesrm from all of you. Thank YOU.