##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Time
#!/usr/bin/env ruby | |
# Speedtest cli to ifttt.com wrapper | |
# based on https://github.com/HenrikBengtsson/speedtest-cli-extras | |
# More: https://www.iamyourfather.de/dsl-speedtest-mit-dem-raspberry-pi (german) | |
# Original: http://makezine.com/projects/send-ticket-isp-when-your-internet-drops/ | |
require 'json' | |
secret_key = "XXXXXXXXXXX" | |
speedtest = `/usr/local/bin/speedtest-cli --share` |
##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Time