teleren/devto huggingface dataset:
Why Shopify? - dev edition
Tags: showdev, shopify, webdev
Published: 2020-10-30 12:09:31

At over 820,000 merchants ([source](https://twitter.com/intred/status/1141527349193842688)) Shopify is becoming the go-to solution for upcoming e-commerce brands.

So why should you, as a developer, care about it?

> *Sutton’s law #1: Go where the money is*

As mentioned Shopify currently has more than 500,000 active store owners, accounting for more than $200 billion (yes with a B) in platform sales. 

That's 500,000 potential customers in need of improvements / features / additions to their websites. With the average hourly rate for Shopify developers being between $50-200/hour depending on your capabilities. 

---

To get some things clear, **is Shopify the most exciting platform to work on in 2020**? 

Not really no. 

Unless you're building custom apps or headless stores, you'll mostly be writing HTML/CSS/JS (or jQuery) creating custom themes / improving existing ones.

**Is it boring?** Not by a longshot. 

There is always something new being added to the platform, or your client has a brilliant new idea to implement that doesn't really work with Shopify, but with their extensive API, there are very few things you won't be able to achieve.

Also, I don't know about you, but seeing your customers' conversion rate going up as a result of your work/idea is one of the best feelings you can have as a freelancer. 

---

I've been working almost exclusively with Shopify for the better part of the last three years, and it's still forcing me to learn something new almost every week.

So feel free to reach out if you have any questions or just want to chat, I'll also be creating some more Shopify related content in the upcoming weeks, so stay tuned for that :blush:

---

*PS. If you're already working with Shopify, or starting to get into it, I've recently created a builder for Shopify Schema -> [Scheemy](https://scheemy.com/), cause nothing is worse then writing JSON by hand* :smile:
JavaScript quick tips: filter arrays
Tags: javascript
Published: 2020-10-30 12:07:26

Filter only numbers in an array,

```js
const myArray = [1, "const", 2, 3]
myArray.filter(Number); // 1, 2, 3
```

Remove all falsy values in an array

```js
const myArray = [1, "const", 2, 3, undefined, null]
myArray.filter(Boolean); // 1, "const", 2, 3
```
Formulas for counting the cells that contain Errors in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-10-31 11:48:52

---
title: Formulas for counting the cells that contain Errors in Excel Office 365!!
published: true
date: 2020-10-30 12:01:37 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-the-cells-that-contain-errors-in-excel-office-365/
---

Here, we will show the **Formulas for counting the number of cells that contain errors in Excel Office 365** with its basic syntax and explanations. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count cells that contain errors](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formulas-to-count-cells-that-contain-errors.png)](https://geekexcel.com/formulas-for-counting-the-cells-that-contain-errors-in-excel-office-365/formulas-to-count-cells-that-contain-errors/#main)<figcaption id="caption-attachment-16561">Formulas to count cells that contain errors</figcaption>
## General Formula:

- To count the number of cells that contain error values in Excel, use the below formula.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–[ISERROR](https://geekexcel.com/how-to-use-iserror-function-in-microsoft-excel-365/)(range))**

## Explanations for Syntax:

- **SUMPRODUCT** – In Excel, this function helps to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).**
- **ISERROR** – The [**ISERROR Function**](https://geekexcel.com/how-to-use-iserror-function-in-microsoft-excel-365/) will return TRUE when Excel generates any type of errors.
- **Range** -It represents an input range given in a worksheet.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus operator (-)** – This symbol helps to subtract two numbers or arrays.

## Example:

- Let’s consider the below image to count the cells that contain errors.
- First, you need to enter the input values.
- Then apply the given formula in the selected area.
- After entering the formula it will count the errors from your input and returns a number.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-44.png)<figcaption id="caption-attachment-16560">Example</figcaption>

## Bottom-Line:

From this article, you can get to know the **Formulas for counting the number of cells that contain any type of Errors in Excel Office 365** with a suitable example. Hope that this article is useful to you. If you have any suggestions, don’t forget to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**
Daily Developer Jokes - Friday, Oct 30, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-10-30 12:00:11

---
title: "Daily Developer Jokes - Friday, Oct 30, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Friday%2C%20Oct%2030%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e1258b057385.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ Why did the functions stop calling each other?

___A:___ Because they had constant arguments.
 -->
Formulas for Counting Cells that Begin with Some Value in Excel!!
Tags: excelformula, excelformulas
Published: 2020-10-31 11:48:39

---
title: Formulas for Counting Cells that Begin with Some Value in Excel!!
published: true
date: 2020-10-30 11:59:55 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-cells-that-begin-with-some-value-in-excel/
---

In this tutorial, we will guide you to learn the **Formulas for counting cells that begin with some values in Excel Office 365** with its brief explanation. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count cells that begin with some values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/EXCEL_5RDULFRf6c.png)](https://geekexcel.com/?attachment_id=16578#main)<figcaption id="caption-attachment-16578">Formulas to count cells that begin with some values</figcaption>
## General Formula:

- To count the number of cells that have values begin with given things or values in Excel, use the below formula.

**=COUNTIF(range,”text\*”)**

## Syntax Explanations:

- **COUNTIF** – The Excel COUNTIF Function will help to count the number of cells that match a single condition or criteria.
- **Range** -It represents an input range given in a worksheet.
- **Text** – It is the criteria to count the cells that should begin with particular values.
- **Asterisk (\*)** – It is a wildcard in Excel that means  “match any number of characters”.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below screenshot, we will enter the input values in **Column B**.
- Then, apply the formula in the formula bar section.
- After entering the formula, it displays the results in **Cell E5** as shown below.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-42.png)<figcaption id="caption-attachment-16523">Example</figcaption>

## Summary:

From this tutorial, we explained the **Formulas to count the number of cells contains the value that begins with particular values in Excel Office 365**. You can also learn its basic syntax and explanation with its best example. Hope that this article is useful to you. Kindly, drop your **feedback** in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**
Hacktoberfest! Level 3!
Tags: opensource
Published: 2020-10-30 06:03:35

If you have read my previous posts, I am celebrating Hacktoberfest which is about to end in a couple of days. This post is about my third PR. In which, I helped translate README.md into my first language. You can check out my [PR](https://github.com/trybick/issue-collab/pull/75#event-3935750838).	

[issue-collab](https://github.com/trybick/issue-collab) is a project that helps people who want to get involved with open source but got no ideas how to start. It allows people to find issues without getting overwhelmed. I have to admit I find it one of the most useful projects during Hacktoberfest.

Back to what I was working on. I am fully aware of the fact that translating is not as big as fixing a bug or something. But in comparison of my previous PR in which I only helped translate a minor file, I do make a progress this time.

The more I am working with open source, the more I am enjoying it. It has given me a sense of contribution which helps build my self confidence since I am kind of introverted while working with other people due to my lack of experience.

But whatever, thanks you guys for spending time my thoughts. I truly appreciate. Happy Coding!!!!
Ball or bald? Neural networks don't care
Tags: neutralnetworks, machinelearning, coding, games
Published: 2020-10-30 11:56:36

I'll start posting here with a very funny news that I learned yesterday evening.

Some sports teams broadcast their matches using smart cameras that track the ball and keep it in frame at all times. It's cheaper than hiring operators. During one of the football matches in Scotland, the camera stopped monitoring the game, staring at the side judge - the machine vision algorithm confused his bald head with the ball.

Such a device costs about $ 1000 and an annual subscription to software that can track the movements of individual players and automatically generate cuts will cost $1100-1500 . Leaving out the bugs with bald judges, it's a useful thing for sports clubs.
Grab your user's attention with the :focus-within CSS selector
Tags: css, html, webdev, beginners
Published: 2020-10-30 11:52:10

Here's a neat little trick:

You can use the `:focus-within` selector to style the parent of a focused element.

![An example of how on focus overlay works](https://dev-to-uploads.s3.amazonaws.com/i/0lja1zmk1zynjzdkr7d7.gif)

That allows you to create some interactive form UI without a single line of JavaScript. Try the example below:

{% codesandbox ubhp7 %}

This demo uses `:focus-within`, plus the `::before` pseudo-selector and some absolute positioning magic. We'll go through the details but you can check the full source below.

{% codesandbox ubhp7 view=editor %}

## `:focus-within` selector + `::before` pseudo-elements + absolute positioning

All in a single declaration block! Let's have a look at the most important part of this example.

```css
body:focus-within::before {
  content: "";
  position: absolute;
  top: 0;
  left: 0;
  width: 100%;
  height: 100%;
  background-color: rgba(0, 0, 0, 0.7);
}
```

### `body:focus-within`

This selector will apply styles whenever there is **focus**... **within** the body!

Oh, and `:focus-within` works with any element. We're sticking with `body` only for this example. 

You can be creative and come up with `.literallyAnyElement:focus-within` and use this selector as you please.

### `body:focus-within::before` + absolute positioning

In our example, that means that whenever any field is focused on the body, a `::before` pseudo-element will be created with those styles:

```css
content: "";
position: absolute;
top: 0;
left: 0;
width: 100%;
height: 100%;
background-color: rgba(0, 0, 0, 0.7);
```

The `content: ''` property is required for pseudo-elements and everything else are properties used to create a dark, transparent overlay that fills the whole screen!

### Extra stuff to make it work properly

Keep in mind that you still need to make a couple of tweaks to make the overlay work perfectly.

```css
html,
body {
  height: 100vh;
}
```

This makes sure that the overlay fills the whole screen even if there isn't enough content on the page.

```css
form {
 position: relative;
```

This `position: relative;` ensures that the overlay renders below the form.

---

And that's it for this week's neat little trick. Thanks for reading!

Make sure the check the other tricks in the series and [follow me on Twitter](https://twitter.com/paladini_dev) if you found any of my articles helpful 😄

---

EDIT: Make sure to check Andrew's suggestion in the comments below!

---

Photo by [Stefan Cosma](https://unsplash.com/@stefanbc) on Unsplash
Free HTML5 CSS3 Landing Page Template 2021 🚀
Published: 2020-10-30 11:12:40

Hi guys!

Start 2021 with a blast by using my free landing page template called Appy made with HTML5 and SASS. Can be used for e.g. SaaS software or app.

**[Checkout the live demo](https://sanderdebr.github.io/html-sass-landing-template/)**

**[Download](https://github.com/sanderdebr/html-sass-landing-template/raw/master/html-sass-landing-template.rar)**

This layout is [custom designed](https://dribbble.com/shots/14445192-Landing-page-template) and built by me, free for commercial and personal use!

### Techniques
* HTML5 & CSS3 with animations
* BEM CSS conventions
* Independent components
* Fully responsive
* CSS Flexbox & Grid
* Pure CSS menu toggle
* Mobile first
* 0.6s load time

This template is using SASS so make sure to have node.js installed on your machine, see the repo for instructions:

**[Checkout the repository](https://github.com/sanderdebr/html-sass-landing-template)**

If you would like to see more of these free templates, please let me know!
My in-browser search with IndexDB and WebWorkers
Tags: javascript, react, machinelearning
Published: 2020-10-30 11:44:53

Hi,
I'm new to Dev, thanks for checking out my first post. 
I'm a data scientist doing data products for actual humans. I want my users to get to wow fast, and I want to develop fast. 

You know what gets in my way ? Servers. Writing a server, integrating with a server, authenticating a user on a server and persisting data on a server all stand between me and my goal. 

Recently I wanted to let my user upload a csv with a text, give them full text search over that, make some annotations on the text and have the result saved for later. 

Back in the day I would have set up a python server, a postgres database, connected them and then tried to get my webapp to talk to the python.

That's annoying because it's a lot of setup for me, and some setup and waiting for my users. It's 2020 no-one has any patience. Let's see how we can get the time to wow down to something a millennial or genexer like me can stomach:



So here's what I did. 
* Moved the heavy computation (building the index and search) in a [WebWorker](https://developer.mozilla.org/en-US/docs/Web/API/Web_Workers_API/Using_web_workers) .  
* Wrapped the worker in a class that gives the main thread a promise when it searches. 
* Used [react-query](https://github.com/tannerlinsley/react-query) to delegate away the request/response state management instead of having a mountain of Redux code. 
* Used the [Dexie library](https://dexie.org/) to store the users data in Indexedb so thay can come back and pick up with they left off. 
* And I used [ndx](https://github.com/ndx-search/ndx) which is a really nice in JS full text search implementation. 

The end result looks like this, granted the design is rough but a satisfying POC of an inbrowser search engine 
![In browser search](https://dev-to-uploads.s3.amazonaws.com/i/3tjo1y825vga49w8uq2h.gif)


This is all going open source soon and I have a lot to share about each of these steps, but I'm not sure if this is interesting and exciting or kind of meh. Let me know what you think and I'll be glad to share more!
Tal
Academic Survey about Configuration Errors in Software Development
Tags: help, computerscience, discuss
Published: 2020-10-30 11:30:51

Hey fellow software developers!

I created a short (~5 min) survey about configuration errors in software development for my bachelor thesis. The data is gathered anonymously and will only be used for my thesis paper.
https://survey.sogosurvey.com/r/mxHLjP

By answering this survey you will help a lot with research in this field, thank you in advance!
Getting started with DynamoDB
Tags: dynamodb
Published: 2020-10-30 11:05:55

---
title: Getting started with DynamoDB
published: true
description: A beginner guide to AWS Dynamodb
tags: dynamodb
//cover_image: https://direct_url_to_image.jpg
---
AWS DynamoDB is a document-based key-value paired single-digit latency database from AWS.

It is a fully serverless database from AWS which can be used in any kind of OLTP application.

In this article, I've covered everything you need to know about DynamoDB to get started. Link:https://bit.ly/3eckZv3
String in Kotlin
Tags: kotlin, android, codenewbie
Published: 2020-10-30 11:04:41

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/0a97dg68xtcpz7u30tnp.jpeg)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/m7zbfw1sz8p4y7em5w2u.jpeg)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/214pg3q95rfur08h8yb0.jpeg)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/0xk3j3sokjyt78ychiv5.jpeg)
How to Populate Metadata When Converting Markdown to HTML in ASP.NET
Tags: webdev, dotnet, html, tutorial
Published: 2020-10-30 11:00:09

...Using a JSON Metadata file, a single view and a dynamic action method to pass metadata into Markdown converted HTML pages.

In a [previous blog post](https://www.xten.uk/technical-blogs/converting-markdown-docs-to-html), I explained how I used a Markdown to HTML conversion tool to turn our Markdown files into HTML webpages for the Aireforge documentation. In summary, all Markdown files were routed through a single dynamic action method with the markdown filename passed as an input parameter. The action method then extracted the content of the Markdown file, converted it to HTML and used a single view to generate each file’s content as and when it was called.

Typically, action methods represent one page, and as such any metadata for a given page (title, metadescription, request path) is hard-coded within the action method..

[Read the full blog](https://www.xten.uk/technical-blogs/populating-metadata-for-markdown-to-html)
All About Code
Tags: hacktoberfest
Published: 2020-10-30 10:33:49

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### [Intro Heading]
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and decided to participate in Hacktoberfest this year.  --> 
### Background

<!-- Are you brand new to open source? What about coding in general? Tell us about how you got here →

### Progress

<!-- Share a bit about where you’re at in your Hacktoberfest journey. What stage are you at? How has the process been?  -->

### Contributions

<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->


### Reflections
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->
If a team member gets hit by a bus, would that destroy your software project ?
Published: 2020-10-30 10:50:05

---
title: "If a team member gets hit by a bus, would that destroy your software project ?"
published: true
description: A dark question I know, but what fundamental concept this question teaches us about managing a software project ?
tags: 
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/zqsa8tbgfgidyq9ewyf3.png
---

In the software development business, there exists many risks that endanger not the only the success of a project, but even its survival. One of the roles of a good project manager is to take those risks into account, and be able to measure them. As one of my teachers in engineering school always stressed, a metric that can't be measured can't be controlled nor dealt with. 

And one of the most important metrics in a software project is the *Bus Factor*.

## What's the concept ?

When designing scalable and reliable software, one of the first questions we should ask ourselves is **what is the single point of failure of the system ?** And it is a very important one, since as you already know, it can easily cause a bottleneck and therefore stop the whole application. 

Well the *Bus Factor* tries to ask the same question, but this time about the development team. The question of *What is the minimum number of team members that should get hit by a bus before we loose a necessary knowledge about the project*. (It's a very dark question to ask !)

Although having many members of your team getting hit by a bus is statistically very unlikely, however having some of them leave the team unexpectedly, either because of a new job, new lifestyle, new family situation, etc..., is highly probable. And it is precisely for this reason that this factor is very important. 

## How do we measure it ?

Let's take for example that a project is composed of three distinct entities: the Front End team composed of 5 people, the Back End team of 10 people, and the DevOps team of 3. Let's assume that every team member perfectly knows about what its team is working on only. 

In that case we can see that if the three members of the DevOps team get suddenly hit by a bus, we loose the ability to work on the project. And therefore you can guess that the *Bus Factor* of this team is 3.

## How do we deal with it ?

The reason we decide to measure the *Bus Factor* is to try to maximize it. The higher the *Bus Factor* is, the lower we are exposed to an unexpected loss of knowledge. Ideally we should aim for ideal number which is the number of our team members. On the contrary, a lower *Bus Factor* means a higher exposure, and the closer we are to 0, the worse we are. 

> You should always share knowledge between your team members to have the highest *Bus Factor* possible !

In the midst of excitement when working on a new Software project, we often forget some basic project management concepts. And best practices are here to make sure we don't forget some of them like the *Bus Factor*. This shows the importance of practices like Code Review or pair programming that take into account this kind of factor, and help prevent a low metric.