Hey, Tony — I'm not an impatient reader. :)
I've added a Date type in my working copy, based on JavaScript's built-in Date (which is reasonably feature-rich). TiddlyWiki has some functions for date formatting in core, too. Libraries like moment.js offer a "kitchen sink" of features but I'm not sure if that's necessary at the moment. Probably my next step will be to add a basic date parser and some utility functions (convert timestamps, convert with string, construct and decompose dates). *Is there value sharing what I find, or do you have it covered?* > If you find something interesting, sure, share it. But given that there's standardized support for basic date processing in JavaScript itself I'm going to try to steer clear of libraries. *May I ask how you use the results TRUE and FALSE in wikitest once > calculated?* > Right now, the best use of these is in Formulas' logical functions, like IF and IFS. In the future I might implement a $formula-if widget that works a little like the reveal widget. Expect a new update tomorrow or so. On Saturday, 16 December 2017 19:17:24 UTC-6, TonyM wrote: > > Evan, > > Very exciting, date manipulation is timely for me, rather than wait I will > look into some existing options. *Is there value sharing what I find, or > do you have it covered?* > > On multidimensional, I am not so much looking for array manipulation. > Tiddlywiki and your solution already meets my requirements. Imagin a large > 2d spreadsheet with 3 columns containing unique keys (or missing keys) even > including date/time. If you choose a key and sort on it before you > manipulate a 2D array you are effectively looking at the data in another > dimension. This is very easy for TiddlyWiki. > > *May I ask how you use the results TRUE and FALSE in wikitest once > calculated?* > > Do you use it in filters etc? > > Regards > Tony > > On Sunday, 17 December 2017 03:20:17 UTC+11, Evan Balster wrote: >> >> Question: do you have or are you planning any rounding or averaging >>> functions? >> >> >> There are rounding functions in there now. See "Functions" and >> "FormulaWidget" in the doc wiki. No averaging yet, but that's a popular >> function I'll replicate at some point soon. (My last round of functions >> was ). >> >> I did find that the rounding functions fail when a second parameter is >>> provided, so I submitted an issue on Github. >> >> >> Ah, I'll fix those then. Good catch. >> >> >> I am very interested in "Multidimensional" arrays. >> >> >> From what I can tell Excel and Sheets can do 1D and 2D arrays, and these >> may be internally represented as selection sets. Anyway, there's a lot of >> flexibility in what "value" types could be added (especially with >> extensions) but I'll probably imitate spreadsheet conventions and functions >> to begin with. >> >> >> One question: Could this be made to work with date and time? >> >> >> Yes, I'll be adding support for a date/time datatype. There's a long >> history of date/time functionality in Excel/Sheets and there are some >> standard TiddlyWiki/javascript functions that can be built upon. >> >> >> Reverse polish notation https://tid.li/tw5/hacks.html >> >> >> Useful reference. Before I was driven to implement this plugin I >> experimented various macro-based solutions (including some homemade ones). >> I even have an accounting wiki built around a sum macro. It was my >> conclusion that the $set/$vars/$macrocall boilerplate makes recursive JS >> macros a bit too unwieldy compared to a dedicated formula syntax. A widget >> also has more potential for caching/optimization/efficiency in the long >> term. >> >> >> >> On Saturday, 16 December 2017 04:29:18 UTC-6, ste...@gmail.com wrote: >>> >>> This looks very good, especially since it is incredibly easy to set up >>> and use! One question: Could this be made to work with date and time? >>> >>> Cheers, >>> >>> Stef >>> >>> On Friday, December 15, 2017 at 5:37:26 AM UTC+1, Evan Balster wrote: >>>> >>>> >>>> Introducing the *Formula plugin*: >>>> http://evanbalster.com/tiddlywiki/formulas.html (version 0.1.0 at >>>> time of posting) >>>> >>>> >>>> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/42170fa5-5674-4b8a-bbaf-e9c89f51fec5%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
