Skip to content

Instantly share code, notes, and snippets.

View oscarb's full-sized avatar

Oscar Björkman oscarb

8 followers · 6 following
View GitHub Profile
@oscarb
oscarb / README.md
Last active March 27, 2024 19:56
Formula to check if URL in cell A1 in a Google Spreadsheet is valid HTML, using the W3C HTML Checker API

Validate URL in a Google Spreadsheet

Formula to check if URL in cell A1 in a Google Spreadsheet is valid HTML, using the W3C HTML Checker API

Formula

=IF(A1<>"", IF(INDEX(IMPORTDATA("https://validator.w3.org/nu/?out=json&doc=" & A1), 0, 2) = "messages:[]}", "✓", "✗"), "")

Output

@oscarb
oscarb / ikea_tradfri_e1743_light.yaml
Last active January 2, 2024 19:10
Home Assistant Blueprint: IKEA E1743 Trådfri on/off switch (ZHA)
blueprint:
name: IKEA E1743 Trådfri on/off switch (ZHA)
description: Dim or turn on/off a light using the IKEA Trådfri E1743 switch remote. Works with ZHA.
author: oscarb
domain: automation
input:
light:
name: Light
description: Entiy ID of light to control
@oscarb
oscarb / readme.md
Last active August 9, 2023 13:53
URL to movie
@oscarb
oscarb / reminders.txt
Created July 27, 2022 11:33
todos/personal.txt,todos/work.txt,reminders.txt
‎‎​
@oscarb
oscarb / google-weather-icons.md
Last active July 19, 2022 21:07 — forked from 1a57danc3/google-weather-icons
@oscarb
oscarb / api.md
Last active July 15, 2020 07:36
API:er
@oscarb
oscarb / testing.md
Last active February 1, 2020 21:00

  1. Do stuff

  2. Do stuff with code

     sudo do more stuff
    1. Do stuff with the stuff

  3. Go back to doing the first stuff

@oscarb
oscarb / table.md
Last active November 8, 2016 23:52
Free webprototyping tools with building blocks and mobile interface

Prototyping tools

Requirements

  • Web
  • Free
  • Building tools/blocks
  • View on mobile

Table

@oscarb
oscarb / keybase.md
Created October 17, 2016 11:09
Proving GitHub identity

Keybase proof

I hereby claim:

  • I am oscarb on github.
  • I am oscarb (https://keybase.io/oscarb) on keybase.
  • I have a public key whose fingerprint is CC21 B826 1C12 C9F6 D7E6 A107 1741 150B 1F6E DED3

To claim this, I am signing this object:

@oscarb
oscarb / activity.java
Created October 4, 2016 11:54
Log Android activity cycle
public void onStart()
{
super.onStart();
Log.d(TAG, "In the onStart() event");
}
public void onRestart()
{
super.onRestart();
Log.d(TAG, "In the onRestart() event");