how to

How to Extract an Integer from a Text String in Excel

Excel and Google Sheets offer you several functions to extract a fragment from a text string. The other day we needed to take ID numbers from a list of URLs and sum up pageviews of links by ID. We exported the report from Google Analytics directly to Google Sheets and used the following function. Suppose that cell A1 has the following text string: https://www.weareevermore.eu/en/news/some-slug/23 First we replace every occurrence of / with 100…

Keep Reading by Balázs Szabolcska Balázs Szabolcska

How does Evermore hire people

We are looking for bright people from all across the world to work with, so our entire hiring process is digital. This means we don’t insist on meeting in person before we hire you. So let’s see how this process goes. 1. The Search Right after we decide to add some new talent to our team, we get in touch with Galina Ilieva, our headhunter for the last few years. We are very happy with our ongoing collaboration. First we talk to her and explain…

Keep Reading by Avi Barouh Avi Barouh

Handling async tasks with Elixir

As web developers we often experience the need to do something asynchronously — like processing large data sets, communicating with external API's or waiting for a blocking operation to finish. In this article I'm going to show you how you can handle async tasks with the help of Elixir. What I like the most in Elixir is that it's concurrent by nature. It comes with number of abstraction that makes writing asynchronous code pretty easy. Elixir is…

Keep Reading by Zlatan Zlatanov Zlatan Zlatanov

How to add HTTP Basic Authentication to your Rails application

From time to time, it's good to deploy an early version of your application, so the client can take a look. With services like Heroku, it's super easy to deploy, but it's not good to leave the application visible to the public. HTTP Basic Authentication to the rescue Most of the PaaS providers abstract the web server from you, but even you have access to it, you can use Rails to setup basic authentication. First, create a new concern in your cont…

Keep Reading by Mirko Akov Mirko Akov

How to add Facebook like button that works with Turbolinks

After finding a solution to add Google Analytics tracking code, once again I had to face a problem that came with Turbolinks. I was not able to load the facebook script in the head of the page, to prevent it from being loaded with every single request. That's why, I decided to combine my research into a helpful CoffeeScript class. To be able to use it, you need to require the file in your application script and load them in the head section of th…

Keep Reading by Mirko Akov Mirko Akov

How to add Google Analytics tracking that works with Turbolinks

Turbolinks is a really nice way to improve your Rails 4 application's speed. It uses AJAX to load the pages and just replace the body element of your page. The official Google Analytics tracking code does not play nice with this approach, but we can easily make it work. The following code snippet is a nice and clean solution for a couple of reasons: It works nicely with Turbolinks Degrades to work even without Turbolinks enabled Uses the new trac…

Keep Reading by Mirko Akov Mirko Akov