-
New Feature
-
Resolution: Unresolved
-
Normal
-
None
-
None
-
None
-
None
Like googlespreadsheet: https://developers.google.com/chart/interactive/docs/querylanguage
Spreadsheet acts like a DB, say, having 10,000 rows table in zk spreadsheet( lets call spreadsheet-1) table-a which contains in sheetA, where table looks like,
date::account head::amount
Allowing you to perform query in a different sheet with something like select from spreadsheet1!sheeta A1:M where account is "Laundry"