=iferror(sum(query(Transactions!$A:$F,"select D where B contains '"&$A11&"' and A = date '"&text(F$1,"yyyy-mm-dd")&"'")))
View worker.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
addEventListener('fetch', event => { | |
event.respondWith(handleRequest(event.request)) | |
}) | |
async function handleRequest(request) { | |
const pageURL = new URL(request.url); | |
return Response.redirect(`${pageURL.protocol}//${String(pageURL.host).substring(4)}${pageURL.pathname}${pageURL.search}`) | |
} |
View how.md
View gist:89476f18fbb6a3f4c6ed0190e2e28395
https://web.archive.org/web/*/URL/*
e.g.,
https://web.archive.org/web/*/https://github.com/NetoECommerce/Skeletal/*
View gist:8e9b40a4be8462e0c68452adc4835404
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
=date(year(edate(today(),-1)),MONTH(edate(today(),-1)),1) | |
// assumes date in cell is the 1st |
View how.md
formatNotes()
Pass commit data into this function to format a markdown commit note. Data structure is based on what Github's compare endpoint returns.
This is useful for generating a changelog for release notes based on git activity.
Example data:
Based on response from Github's compareCommits endpoint.
View how.md
generateVersionNumber()
This function generates a date-based version number. Year + Month + Iteration
So, the first release in March 2017 will be 17.3.0
If multiple releases occur in a month, the final number will increase. Otherwise, an entirely new verion number will be generated.
i.e.
View demo.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Run on page load | |
$('input').on('focus blur',function(e){ | |
performance.mark(e.type+ ' ' + e.target.name) | |
}); | |
// Run to see results | |
console.table(performance.getEntriesByType('mark')) |
View gist:8aa77c4b061287e437a9beaec0a3b210
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var observer = new MutationObserver(function(mutations) { | |
mutations.forEach(function(mutation) { | |
console.log(mutation.type); | |
}); | |
}); | |
observer.observe(document.getElementById('bill_selector'), { | |
attributes: true, | |
childList: true, | |
characterData: true |
View 1.how.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<div class="modal fade" id="shipCountryModal" tabindex="-1" role="dialog" aria-labelledby="shipCountryModalLabel"> | |
<div class="modal-dialog" role="document"> | |
<div class="modal-content"> | |
<form method="post" action="[@url@]"> | |
<div class="modal-header"> | |
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> | |
<h4 class="modal-title">Hello, international shopper!</h4> | |
</div> | |
<div class="modal-body"> | |
<p>It looks like you're not shopping from Australia, where we are based—select your country below and we'll ensure you're not seeing prices which include Australia-specific taxes.</p> |
NewerOlder