Formula to count the blank cells in excel

When I was working on some data calculations in a excel sheet, we had a situation to count the blank number of cells in a range of rows. There are lot of statistical formulas available in excel

Here is the one formula which can be used to achieve this. and We can see how can use this.

We can use COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.

Syntax
COUNTBLANK(Range)
 
The COUNTBLANK function syntax has the following arguments:
 
Range    Required. The range from which you want to count the blank cells.
 
Remark
Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

Example:

Hope this helps!

How to add email and phone link in shopify

 While working with Shopify themes, somebody was asking me how to make by clicking on email, it should automatically open the installed email client and add the email address to field. This is very simple to do.

1. Name the link "Email us" or whatever content you want your clients to see.

2. Put "mailto:name@example.com" in the Link box.

3, Replace the placeholder email address with your email address

Similarly you can add a telephone number with the prefix "tel:+xxxxxxxxxx" .. And link it. It automatically opens the dialer.

Click Add, then Save, and you're finished. 

WhatsApp, dialer and email integration for a flutter WebView application

Recently we were working on an E-commerce website. Then we have decided to build a webview flutter application.  We built it successfully and was working fine. But in the website we have a feature to interact with the customer care executive through WhatsApp. But this did not work in the flutter app. But works very well from the browser on the desktop.  However, because WhatsApp and our flutter app are separate applications, this did not work or we were unable to activate WhatsApp through our application. 

In mobile, we get the below error when we try to click on the whatsApp button in the application: 

ERR_UNKNOWN_URL_SCHEME Error

The url_launcher module in Flutter can be used to incorporate WhatsApp into a Flutter webview application.

1. Add the url_launcher dependency to your pubspec.yaml file:

dependencies:

  url_launcher: ^6.0.9

2.  Import the url_launcher package in your Dart file:

        import 'package:url_launcher/url_launcher.dart';

3.  In your webview widget, add an onPageFinished callback that gets triggered when the page finishes loading. Inside this callback, you can use url_launcher to launch WhatsApp:

WebView(

  initialUrl: 'https://example.com',

  onPageFinished: (String url) {

    if (url.contains('whatsapp://send')) {

      launch(url);

    }

  },

)

or: 

navigationDelegate: (NavigationRequest request) {

            if (request.url.contains('api.whatsapp.com')) {

              launch(request.url); //This is where Whatsapp launches

              return NavigationDecision.prevent;

            }

In the above code, we check if the URL contains whatsapp://send. If it does, we use launch to open the URL in the system's default browser, which will launch WhatsApp if it is installed.
Note that this will only work on devices that have WhatsApp installed. If WhatsApp is not installed, the URL will not be opened.

Same thing we can do for a dialer and email integrations: Here is the code for that

 if (request.url.contains('mailto:')) {

              launch(request.url);

              return NavigationDecision.prevent;

            }

            if (request.url.contains('tel:')) {

              launch(request.url);

              return NavigationDecision.prevent;

            }

In some cases, the other urls apart from this may not work so, you  need to add NavigationDecision.Navigate option as shown in the below code:

 if (request.url.contains('wa.me')) {

              launch(request.url); //This is where Whatsapp launches

              return NavigationDecision.prevent;

            }

            if (request.url.contains('mailto:')) {

              launch(request.url);

              return NavigationDecision.prevent;

            }

            if (request.url.contains('tel:')) {

              launch(request.url);

              return NavigationDecision.prevent;

            }

            return NavigationDecision.navigate;

          },

Hope this helps. 

How to Change Version Code and Version Name in Flutter

We released a flutter application on the Play Store, and now I want to submit a new version of the application. We are attempting to alter the version number using the below command in Visual Studio Code:

flutter build apk --build-name=1.3.0 --build-number=3

or alterring the local.properties like this (through Android Studio or Visual Studio Code)

 

 flutter.versionName=1.3.0

 flutter.versionCode=3

 flutter.buildMode=release

 

With these changes when we build the apk bundle and try to release it in Google play store, We get the below error from play store:

You must use a different version code for your APK or your Android App Bundle because code 1 is already assigned to another APK or Android App Bundle. 

The Solution for this is as below: 

1. Go to build.gradle and the change the flutterVersionCode and flutterVersionName  as below

        

def flutterVersionCode = localProperties.getProperty('flutter.versionCode')
if (flutterVersionCode == null) {
    flutterVersionCode = '1.3.0'
}

def flutterVersionName = localProperties.getProperty('flutter.versionName')
if (flutterVersionName == null) {
    flutterVersionName = '3.0'
}

2. Go to pubspec.yaml file and add the versionCode and versionName as below:

version: 1.4.0+4

environment:
  sdk: ">=2.12.0 <3.0.0"

Update version:A.B.C+X in pubspec.yaml.

For Android:

A.B.C represents the versionName such as 1.0.0.

X (the number after the +) represents the versionCode such as 1, 2, 3, etc.

Do not forget to execute flutter build apk or flutter run after this step, because: When you run flutter build apk or flutter run after updating this version in the pubspec file, the versionName and versionCode in local.properties are updated which are later picked up in the build.gradle (app) when you build your flutter project using flutter build apk or flutter run which is ultimately responsible for setting the versionName and versionCode for the apk.

For iOS:

A.B.C represents the CFBundleShortVersionString such as 1.0.0.

X (the number after the +) represents the CFBundleVersion such as 1, 2, 3, etc.

Do not forget to execute flutter build ipa or flutter run after this step

Happy Coding 

Top 10 Coding Languages to Learn to Work in Technology in 2023

Programming languages are obviously very important to software engineers. Programming languages have not only made it simpler for coders to finish their work, but they have also made it possible for organizations to accomplish their objectives in the most effective way possible. 

You've come to the correct spot if you're curious about the programming languages that software developers use the most.

Python - Python is an easy-to-learn, high-level programming language that is widely used in web development, data analysis, machine learning, artificial intelligence, and scientific computing. Python is a high-level, interpreted programming language that is widely used for various purposes, including web development, scientific computing, data analysis, artificial intelligence, machine learning, automation, and more. Here are some key details about Python: 

Python was first released in 1991 by Guido van Rossum and has since become one of the most popular programming languages in the world.  Python is known for its simple and easy-to-learn syntax, which makes it an ideal language for beginners. Python supports multiple programming paradigms, including object-oriented, functional, and procedural programming.

Python has a vast standard library that provides a wide range of modules and functions for various tasks, from file I/O to web development. Python is an interpreted language, which means that the code is executed line by line rather than being compiled into machine code beforehand. Python is highly extensible and can be easily integrated with other languages like C and C++. Python has a large and active community of developers who contribute to its development and create a wide range of third-party libraries and frameworks.

Overall, Python is a versatile and powerful programming language that can be used for a wide range of tasks, from simple scripts to complex applications.

 

JavaScript and TypeScript - JavaScript is the programming language of the web and is widely used in front-end web development, creating dynamic user interfaces, and building web applications. TypeScript is a superset of JavaScript that adds static typing to the language. It is popular for building large-scale applications. 

JavaScript and TypeScript are both programming languages that are widely used for web development. Here are some key details about each language.

JavaScript: 

 

• JavaScript is a high-level, dynamic programming language that is used primarily for front-end web development. It is supported by all modern web browsers and is used to create dynamic and interactive user interfaces. 
• JavaScript is often combined with HTML and CSS to create dynamic web pages and web applications. 
• JavaScript is an interpreted language, which means that the code is executed in the web browser rather than being compiled into machine code beforehand.
• JavaScript has a vast ecosystem of third-party libraries and frameworks, including React, Vue, and Angular, which make it easier to develop complex web applications.

 TypeScript:

• TypeScript is a superset of JavaScript that adds static typing and other features to the language. It is often used for larger-scale web applications that require more structure and maintainability.  
• TypeScript is designed to be easy to read and understand, with a syntax that is similar to JavaScript.
• TypeScript is compiled into JavaScript before it is executed, which means that it can be used in any browser that supports JavaScript.
• TypeScript has a strong type system that helps catch errors before runtime, making it easier to maintain and debug code.
• TypeScript is often used with popular front-end frameworks like Angular and React, but it can also be used on the back-end with Node.js.

Overall, both JavaScript and TypeScript are important languages for web development, with JavaScript being more widely used for front-end development and TypeScript being used for larger-scale applications that require more structure and maintainability.

 

Java - Java is a versatile programming language that is used to develop applications for desktops, mobile devices, and the web.

Java is a popular programming language that is widely used for developing a variety of applications, from desktop and mobile applications to web-based applications and enterprise-level systems. Here are some key details about Java:

• Java was first released in 1995 by Sun Microsystems and has since become one of the most popular programming languages in the world.
• Java is a high-level, object-oriented programming language that is designed to be platform-independent, which means that it can run on any platform that has a Java Virtual Machine (JVM). 
• Java is strongly typed, which means that it requires variable declarations and is less prone to type errors.
• Java has a large standard library that provides a wide range of functions and utilities for various tasks, from file I/O to network programming.
• Java is often used in enterprise-level systems and web development, with popular frameworks like Spring and Struts.
• Java is known for its security features, which make it a popular choice for developing applications that require a high level of security, such as banking and financial systems.
• Java is also widely used for Android app development, with Android Studio being the primary development environment for Android applications.

Overall, Java is a versatile and powerful programming language that can be used for a wide range of applications, from desktop and mobile applications to web-based and enterprise-level systems. Its platform independence, strong typing, and large standard library make it a popular choice for developers of all levels.

 

Kotlin - Kotlin is a modern, concise programming language that is designed to be more readable and efficient than Java. It is widely used in Android app development. Kotlin is a modern programming language that is designed to be a more concise, expressive, and safe alternative to Java. It is an open-source language developed by JetBrains, the company behind popular IDEs like IntelliJ IDEA and Android Studio. Here are some key details about Kotlin:

• Kotlin is a statically typed language that is fully interoperable with Java, which means that it can be used alongside Java in existing projects.
• Kotlin is designed to be more concise than Java, with a syntax that is more expressive and readable. It also eliminates a lot of the boilerplate code that is required in Java.
• Kotlin is an object-oriented language that supports functional programming constructs like lambdas, higher-order functions, and coroutines.
• Kotlin is designed to be safe, with features like null safety and type inference that help prevent common errors and improve code quality.
• Kotlin is often used for developing Android applications, with Google officially supporting Kotlin as a first-class language for Android development.
• Kotlin also has a growing ecosystem of libraries and frameworks, including popular frameworks like Spring Boot and Ktor.

 Overall, Kotlin is a modern and powerful language that offers many advantages over Java, including increased productivity, better readability, and improved safety. Its interoperability with Java also makes it an attractive choice for developers who want to migrate to a more modern language without having to rewrite their entire codebase.

 

Swift - Swift is the primary programming language used to develop applications for iOS and macOS devices. It is a fast and powerful language that is easy to learn. Swift is a modern programming language developed by Apple for developing applications for iOS, macOS, watchOS, and tvOS. Here are some key details about Swift: 

• Swift was first introduced by Apple in 2014 and has since become the primary language for iOS app development.
• Swift is designed to be a fast and safe language, with a syntax that is easy to read and write.
• Swift is a strongly typed language that supports both object-oriented and functional programming paradigms.
• Swift offers a number of features that make it easier to write safe and reliable code, including optionals, type inference, and automatic memory management.
• Swift is open-source, which means that it is free to use and can be used on platforms other than Apple's.
• Swift has a growing ecosystem of third-party libraries and frameworks, including popular frameworks like SwiftUI and Combine.

Overall, Swift is a powerful and modern language that offers many advantages over Objective-C, the previous primary language for iOS app development. Its focus on safety and reliability, combined with its ease of use and growing ecosystem, make it an attractive choice for developers who want to build high-quality iOS, macOS, watchOS, and tvOS applications.

 

Rust - Rust is a systems programming language that is designed to be fast, secure, and reliable. It is used to build applications that require high performance and low-level control. It was created by Mozilla and released in 2010, and has since gained popularity among developers for its unique features and capabilities. Here are some key details about Rust:

• Rust is a statically typed language that is designed for systems programming, which means that it is intended for low-level programming tasks like writing operating systems, device drivers, and high-performance applications.  
• Rust offers a number of features that make it easier to write safe and reliable code, including memory safety guarantees, zero-cost abstractions, and pattern matching.
• Rust has a syntax that is similar to C++, but with a number of modern features that make it easier to write and maintain code.
• Rust is designed to be a fast language, with performance comparable to C and C++.
• Rust has a growing ecosystem of third-party libraries and frameworks, including popular frameworks like Rocket and Actix.
• Rust has a strong focus on community and open-source development, with a large and active community of developers contributing to the language and its ecosystem.

Overall, Rust is a powerful and unique language that offers many advantages over traditional systems programming languages like C and C++. Its focus on safety and reliability, combined with its modern features and growing ecosystem, make it an attractive choice for developers who want to build high-performance systems-level applications.

 

Go - Go is a programming language developed by Google that is used to build scalable, high-performance applications. It is popular for building web servers and networking applications. Go, also known as Golang, is a modern programming language developed by Google in 2007. It was designed to be a simple, efficient, and scalable language that is easy to learn and use. Here are some key details about Go: 

• Go is a statically typed language that is designed for concurrency and multi-core processing, which means that it is optimized for running on modern hardware.
• Go offers a number of features that make it easy to write simple, efficient, and maintainable code, including garbage collection, automatic memory management, and a syntax that is similar to C. 
• Go has a large standard library that provides a wide range of functions and utilities for various tasks, from network programming to web development.
• Go is often used for developing server-side applications, with popular frameworks like Gin and Echo. 
• Go has a growing ecosystem of third-party libraries and tools, including popular tools like Docker and Kubernetes.
•  Go is open-source, which means that it is free to use and can be used on platforms other than Google's.

Overall, Go is a powerful and efficient language that offers many advantages over traditional programming languages like C and Java. Its focus on simplicity, efficiency, and concurrency, combined with its growing ecosystem, make it an attractive choice for developers who want to build high-performance server-side applications.

C++ - C++ is a high-level programming language that is widely used for developing applications in a variety of domains, including system programming, game development, and scientific computing. It is an extension of the C programming language, with added features that make it more powerful and flexible. Here are some key details about C++:

• C++ is a statically typed language, which means that types are checked at compile-time, resulting in faster code execution.
• C++ is an object-oriented language, which means that it supports features like classes, inheritance, and polymorphism.
• C++ provides low-level programming constructs like pointers and memory management, which makes it useful for system programming.
• C++ is often used for developing games, as it provides powerful graphics and audio APIs.
• C++ is also used in scientific computing, as it provides access to high-performance libraries like the Boost C++ Libraries and the Armadillo library.
• C++ has a large and active community, with many third-party libraries and frameworks available for various tasks.

Overall, C++ is a powerful and flexible language that is suitable for a wide range of applications. Its low-level programming constructs, object-oriented features, and support for high-performance computing make it an attractive choice for developers who want to build robust and high-performance applications. However, its syntax can be complex and difficult to learn for beginners, and it requires careful attention to memory management to avoid bugs and crashes.

 

Ruby - Ruby is a dynamic, object-oriented programming language that is popular for building web applications, especially with the Ruby on Rails framework. This was created by Yukihiro "Matz" Matsumoto in 1995. It is known for its simplicity, flexibility, and ease of use. Here are some key details about Ruby: 

• Ruby is a dynamically typed language, which means that it does not require explicit type declarations for variables.
• Ruby is designed to be easy to read and write, with a syntax that is similar to natural language.
• Ruby is an object-oriented language, which means that everything in Ruby is an object.
• Ruby has a large and vibrant community, with many third-party libraries and frameworks available for various tasks, including popular frameworks like Ruby on Rails.
• Ruby is often used for developing web applications, but it can also be used for other tasks like automation, scripting, and data analysis.
• Ruby has a strong focus on developer happiness, with a philosophy that emphasizes the importance of making programming enjoyable and fun.

Overall, Ruby is a popular and powerful language that offers many advantages over other programming languages. Its simplicity, flexibility, and ease of use make it an attractive choice for developers who want to build high-quality web applications or other software.

Laravel- Laravel is a popular PHP Web application framework that is widely used in web development. It provides elegant syntax and a set of tools and features that make it easy to build scalable and maintainable web applications. 

Laravel is a free and open-source PHP web application framework that was created by Taylor Otwell in 2011. It is designed to simplify the development of web applications by providing an elegant syntax, a range of tools, and a wide variety of features. Here are some key details about Laravel:

• Laravel is built on top of the PHP language, which is widely used for web development.
• Laravel follows the Model-View-Controller (MVC) architectural pattern, which separates the application's concerns into three distinct components.
• Laravel provides a range of features, including built-in authentication, database migrations, task scheduling, and unit testing.
• Laravel has a simple and elegant syntax that is easy to read and write, which makes it a popular choice for developers who want to build web applications quickly.
• Laravel has a large and active community, with many third-party packages and libraries available for various tasks.
• Laravel is often used for developing web applications, including e-commerce platforms, content management systems, and social networking sites.

Overall, Laravel is a powerful and flexible web application framework that is suitable for a wide range of applications. Its elegant syntax, rich feature set, and active community make it an attractive choice for developers who want to build high-quality web applications quickly and efficiently.

Disclaimer: The information provided in this article is solely the author's opinion and not an investment advice – it is provided for educational purposes only. By using this, you agree that the information does not constitute any investment or financial instructions by the author.