=iferror(sum(query(Transactions!$A:$F,"select D where B contains '"&$A11&"' and A = date '"&text(F$1,"yyyy-mm-dd")&"'")))
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="panel panel-default" id="shipbox"> | |
<div class="panel-heading"> | |
<h3 class="panel-title">Calculate Shipping</h3> | |
</div> | |
<div class="panel-body"> | |
<div class="row btn-stack"> | |
<div class="col-xs-12 col-md-3"> | |
<input type="number" name="input" id="n_qty" value="[@qty@]" size="2" class="form-control" placeholder="Qty"> | |
</div> | |
<div class="col-xs-12 col-md-3"> |
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}`) | |
} |
<script src="//js.maxmind.com/js/apis/geoip2/v2.1/geoip2.js" type="text/javascript"></script>
<script type="text/javascript">
var queryCountry = (function () {
var onSuccess = function (geoipResponse) {
var popupstatus = $.cookie('popupstatus')
var country = geoipResponse.country.iso_code
if(popupstatus != 'popped' && country != 'AU'){
https://web.archive.org/web/*/URL/*
e.g.,
https://web.archive.org/web/*/https://github.com/NetoECommerce/Skeletal/*
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 |
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
// If country is AU, do nothing. | |
// If country is NZ, a NZ-specific pop-up | |
// If any other country (not AU or NZ), a generic international pop-up | |
var nzPopup = function() { | |
// Code to pop up the NZ popup | |
}; | |
var internationalPopup = function() { | |
// Code for everyone else | |
}; |
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
[%set [@hasimage@]%][%asset_url type:'content' id:'[@content_id@]' default:''/%][%/set%] | |
[%if [@hasimage@]%][%asset_url type:'content' id:'[@content_id@]' default:''/%][%/if%] |
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.
Based on response from Github's compareCommits endpoint.
NewerOlder