I make apps, take a look 👇

Timeless' app icon


Reduce time anxiety and stay focused

Timeless is a subtle clock replacement. It helps you feel less anxious about the time and more focused on how you should be spending it.

  • Google Apps Script: TTResponds


    TTResponds is a Google Apps Script that allows you to automatically send a confirmation to people who’ve filled out a Google Form.

    It’s been available for a while in the Script Gallery, but I haven’t gotten around to write about it. The reason I’m doing so right now, is because I’ve received a couple of returning questions that I can probably better answer right here.


    First login to your Google Docs environment, and Google Apps both work fine. After that, choose to create a new Form.

    New form

    This will present you with a pop-up that allows you to customize the fields. For basis functionality it should at least contain a name field first and an email address second. After that you can add anything you want.

    Setup form

    Clicking save will send you to the Spreadsheet, setup to receive form submissions. The next step is to add TTResponds. You can do so by clicking ‘Tools’ and then ‘Script gallery…’.

    Script gallery

    Search for ‘TTResponds’ and click install.

    Find TTResponds

    Authorize the script to read your Spreadsheet and send out emails.


    A new menu item called ‘TTResponds’ just appeared. Click it and select ‘Create config’. This should add an extra sheet called ‘TTRespondsConfig’, you can change the properties to provide a more relevant response. After you’re done, make sure all ‘Triggers’ are setup correctly by clicking ‘Tools’ and after that ‘Script editor…’.

    Script editor

    In the pop-up select ‘Triggers’ and then ‘All your triggers…’.


    Make sure your setup looks like the image above. If it doesn’t, click ‘Add a new trigger’ and set it to ‘onFormSubmit’, ‘From spreadsheet’ and ‘On form submit’. That’s it! Fill out your own form and you’ll receive a confirmation automatically!

    HTML Email

    Per default the script sends text-only emails. You can change this to HTML email pretty easily (I’ll probably add it as an option in an update). First open the script editor again and navigate to line 119.

    HTML email

    You’ll see that is says:

    { name: _config.from }

    Change it to this:

    { name: _config.from, htmlBody: _config.body }

    The script will now send the confirmation as HTML, allowing you to send a fancier response .


    I’ve created a GitHub repo for TTResponds. If you’re adding features, or fixing bugs, please fork the project and send me a pull request.

    Let me know

    It would be awesome if you let me know if you use and/or like the script through the comments, thanks!

  • Omniauth + Facebook = OpenSSL::SSL::SSLError

    I’ve run into this issue twice and now I’m writing down the solution. When authenticating with Facebook via Omniauth, my server always fails with the following error:

    OpenSSL::SSL::SSLError (SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed):

    This is easily fixed by adding the following to one of the initializers:


    It’s probably not the best solution, as this turns off SSL peer verification..

    A better solution:

  • Hip Like Heroku

    Usually I deploy projects on my physical server, located at the server park called “former bedroom at my parents’”. This allows me to see how a project develops and migrate to a better server (which costs more money) if it’s successful. This is also the case for

    I’ve been deploying a couple of experiments to Heroku and the platform really appeals to me. Deploying itself is a breeze and the “add-ons” model is pretty cool. Also, it’s free if you can manage with a 5mb database, 1 dyno en 0 workers. Projects in a developing stage usually do. I’ve never launched a project from it though. Primarily because I don’t want the to run into insane hosting costs if something like Please Rob Me happens. In any case the ability to scale a project and not worrying about server setup and stuff is awesome.

    Hip Like Japie hasn’t really took off (yet?), but is doing mildly ok with a bunch of visitors every day. It being a finished product made it interesting for me to see how well it would deploy.

    I’ve got Heroku’s command line tool installed, but if you haven’t install it like this:

    $ sudo gem install heroku

    Next you need to setup a Git repository for your project if you haven’t already.

    $ git init
    $ git add .
    $ git commit -m 'initial import'

    Let Heroku add it’s remote.

    $ heroku create

    Login with your Heroku credentials and you’re done setting up!

    This would usually be the point where you start developing your application, but Hip Like Japie being already done allows me to skip directly to deploying.

    $ git push heroku master

    Did you see what they did there? They just added a new remote, super nice. Anyway, this should start deploying the app. After it’s done, migrate the database.

    $ heroku rake db:migrate

    I thought about looking online for correct settings to Heroku’s database setup, but decided to just run rake and see what happens. Turns out that Heroku just made it work. My production setup was set to use Sqlite3, but Heroku automatically changed it to their PostgreSQL database.

    Technically I was done, but opening the website would give me an error. Crap, something went wrong. You can check the server’s log by issuing the following command:

    $ heroku logs

    This showed me that a database query failed, due to running on PostgreSQL instead of Sqlite3. I applied a dirty little patch.

    if ActiveRecord::Base.connection.instance_values["config"][:adapter] == 'postgresql'
      @comparisons = Comparison.find_by_sql(
          "SELECT * FROM (SELECT DISTINCT ON (username) * FROM comparisons ORDER BY username, id DESC) foo ORDER BY id DESC LIMIT 10"
      @comparisons = Comparison.all(
          :order => "id DESC", :limit => 10, :group => 'username'

    After that the site worked fine: There’s an add-on that allows you to hook up your custom domain name to the project. It’s conveniently called “Custom Domains” and can be used via the command line.

    $ heroku addons:add custom_domains

    This may prompt you to verify your account, by entering your creditcard details (on Heroku’s website, not the command line). After that you’re ready to add your domain names.

    $ heroku domains:add
    $ heroku domains:add

    I added both the domain and the www. sub-domain. To activate this, you need to change your domain’s DNS settings. It comes down to adding three A records and a CNAME.

    @ A
    @ A
    @ A
    www CNAME

    That’s it, points directly to Heroku, awesome!


    The website failed if the worker would spin down. The error logs showed that Compass couldn’t compile the Sass files. Which is obvious as Heroku is read-only. This line in config/environments/production.rb fixes it:

  • Improve Javascript code quality with JSLint

    Created a tiny project on GitHub with a simple piece of Javascript to see what JSLint does.

    “JSLint is a JavaScript program that looks for problems in JavaScript programs. It is a code quality tool.” –

    Pretty cool and something I’ll definitely incorporate in deploy scripts. Checkout the example website here and the GitHub repo here.

  • When POSTs suddenly turn into 301 redirects in Rails

    Everything worked fine in my development environment, but when I ran the application from my server every POST would just show the page it was suppost to POST to via GET. Displaying a 301 redirect in Chrome’s developers tools.

    After some fiddling around, I commented line 351 in the .htaccess file:

    <IfModule mod_rewrite.c>
      RewriteCond %{REQUEST_FILENAME} !-f
      RewriteCond %{REQUEST_URI} !(\.[a-zA-Z0-9]{1,5}|/|#(.*))$
      #RewriteRule ^(.*)$ /$1/ [R=301,L] # <-- this one

    After that everything worked as expected. Weird..

I make apps, take a look 👇

Pipvid's app icon


Snaps videos to any corner

Adds a picture-in-picture mode to VLC and QuickTime. Ideal for watching videos in the corner of your screen while you work on something else.