WEBMERGE INVOICE: 1 click creation (non-uri request / no size limit)

API & Customization
1

$(document).on('knack-scene-render.scene_404', function(event, scene) {

// link hander: send invoice to webmerge, create a form in Knack with no fields, locate in chrome dev tools
$('#view_719').submit(function(event) {
event.preventDefault();


// get data, on my sheet 708 was header, 721 was footer, 705 is the table loop
var data_view_708 = Knack.models['view_708'].toJSON();
var data_view_721 = Knack.models['view_721'].toJSON();
var data_view_705 = Knack.models['view_705'].data.toJSON();

//url = 'https://www.webmerge.me/merge/ABCDEF';

url = 'download=1';

url += '&clientname=' + encodeURI(data_view_708.field_895);
url += '&clientpoc=' + encodeURI(data_view_708.field_644);
url += '&clientaddress=' + encodeURI(data_view_708.field_549);
url += '&clientpocemail=' + encodeURI(data_view_708.field_648);
url += '&clientpocnumber=' + encodeURI(data_view_708.field_720);
url += '&projectname=' + encodeURI(data_view_708.field_692);
url += '&projectaddress=' + encodeURI(data_view_708.field_549);
url += '&retainerdue=' + encodeURI(data_view_708.field_772);
url += '&retaineramount=' + encodeURI(data_view_708.field_773);
url += '&invoicenumber=' + encodeURI(data_view_708.field_580);
url += '&invoicedue=' + encodeURI(data_view_708.field_719);
url += '&agreedamount=' + encodeURI(data_view_721.field_899);
url += '&applieddiscount=' + encodeURI(data_view_721.field_900);
url += '&discountedtotal=' + encodeURI(data_view_721.field_901);
url += '&regulatedservice=' + encodeURI(data_view_721.field_902);
url += '&specialtyrisk=' + encodeURI(data_view_721.field_903);
url += '&recoveryfee=' + encodeURI(data_view_721.field_904);
url += '&salestax=' + encodeURI(data_view_721.field_905);
url += '&totalamount=' + encodeURI(data_view_708.field_893);

// this is the items in your table replace each field # with invoice columns using chrome dev tools
for(x = 0; x < data_view_705.length; x++){
item = data_view_705[x];
url += '&items[' + x + '][startservice]=' + encodeURI(item.field_85);
url += '&items[' + x + '][item]=' + encodeURI(item.field_326);
url += '&items[' + x + '][position]=' + encodeURI(item.field_401);
url += '&items[' + x + '][endservice]=' + encodeURI(item.field_196);
url += '&items[' + x + '][qty]=' + encodeURI(item.field_197);
url += '&items[' + x + '][rate]=' + encodeURI(item.field_194);
url += '&items[' + x + '][contractrate]=' + encodeURI(item.field_277);
url += '&items[' + x + '][discounted]=' + encodeURI(item.field_286);
url += '&items[' + x + '][amount]=' + encodeURI(item.field_287);
}

// make sure you swap your webmerge address below
//window.location = url;

$.post('https://www.webmerge.me/merge/ABCDEF', url, function(){
alert('Contract Created!');
Knack.hideSpinner();
});
});

$('select[name="limit"]').val('1000').change();
});

2

thank you for this!!