Fixing Error of Metronic Theme PagedList component


Metronic Theme have PagedList component which provide users prepare paged list quickly. However, it have a issue: When user clicks the number of active page link number page thwors error. Because link of active page misdefined. To fix this I’ve prepared a jquery patch. $(document).ready(function () { //fixing pagedlist bug-patch s.atan $(“.pagination > .active >… Read More Fixing Error of Metronic Theme PagedList component

Google Spreadsheet Query Function Makes your Spreadsheets DB which SQL-ready


When you want to make complex queries over Excel sheet that is almost impossible. Yet by Google Docs Spreadsheet Query() function you  can write SQL and retrieve whatever you want. For instance: =query(A2:I1000;“select sum(H)  WHERE D=‘mrkt’”)  Gets only expenditures which about ‘mrkt’ (market) from A2:ı10000 TABLE then gets sum. When you write function by this way,… Read More Google Spreadsheet Query Function Makes your Spreadsheets DB which SQL-ready