Well, I have not tried that, but I think there are solutions. Not sure but I have read threads here discussing export/import csv.
Best wishes Mohammad On Sun, Jan 24, 2021 at 6:03 PM 'JWHoneycutt' via TiddlyWiki < [email protected]> wrote: > OMG - it is embarrassing to learn that clicking the column header sorts > the whole table. I should have tried that first. > > Thank you Mohammad for creating this great solution. Is there a way to > export to spreadsheet format (or CSV) for others (non TW5 users) to add to? > > JWHoneycutt > On Saturday, January 23, 2021 at 9:58:07 PM UTC-5 Mohammad wrote: > >> Note, the table is created from a filter. It i s the main input >> parameter. It makes the rows. After creating the table, you can click on >> the sort (field) column you made to sort the table based on that field. >> By the way, dynamic tables have the feature to sort by each column >> (field), so it does not make sense to use the sort filter operator with >> input filter. >> >> Hope this helps >> >> >> >> Best wishes >> Mohammad >> >> >> On Sun, Jan 24, 2021 at 1:05 AM 'JWHoneycutt' via TiddlyWiki < >> [email protected]> wrote: >> >>> Now my macro is: >>> >>> <<table-dynamic filter:"[tag[Ayacucho]tag[Owner]tag[Person]]" >>> fields:"tbl-expand sort title lot name corp_name corp_number email phone" >>> caption:"''Ayacucho Lot Owners''" sortOp:"nsort" class:"w-100 >>> table-hover-cyan table-center thead-dark" footerRows:"0" stateTiddler:"" >>> editButton:"yes">> >>> >>> It is still sorting the filtered records by tiddler title (but I want it >>> sorted by sort field), because there is no place where I have told it to >>> "nsort[sort]" - right? >>> On Saturday, January 23, 2021 at 3:00:09 PM UTC-5 Mohammad wrote: >>> >>>> See https://kookma.github.io/TW-Shiraz/#demo%2Fdynamic-table-macro >>>> >>>> and study the sortOp. >>>> >>>> >>>> Best wishes >>>> Mohammad >>>> >>>> >>>> On Sat, Jan 23, 2021 at 9:47 PM 'JWHoneycutt' via TiddlyWiki < >>>> [email protected]> wrote: >>>> >>>>> I love Mohammad's solution for dynamic-tables, (Shiraz plugin version >>>>> 2.1.2) but... >>>>> >>>>> I need a little more help making a dynamic table sort correctly. >>>>> >>>>> I created a numeric "sort" field. Entries are (in order) 01, 021, >>>>> 022, 03, 071, 101, 102, 11, etc. >>>>> >>>>> My current best guess still does not work: >>>>> ``` >>>>> <<table-dynamic filter:"[tag[Ayacucho]tag[Owner]tag[Person]]" >>>>> fields:"tbl-expand title lot name corp_name corp_number email phone" >>>>> caption:"''Ayacucho Lot Owners''" class:"w-100 table-hover-cyan >>>>> table-center thead-dark" footerRows:"0" >>>>> stateTiddler:"$:/keepstate/dynamictables/$(sort)$" editButton:"yes">> >>>>> >>>>> ``` >>>>> >>>>> I first assumed I could just make my filter: >>>>> "[tag[Ayacucho]tag[Owner]tag[Person]sort[sort]]" and leave >>>>> stateTiddler:"" (blank), but it does not sort by the "sort" field. >>>>> >>>>> Next try is filter:"[tag[Ayacucho]tag[Owner]tag[Person]" and >>>>> stateTiddler:"sort", still fails. >>>>> How do I get the table to sort by the "sort" field? >>>>> >>>>> (The sort order can be permanent.) - Do I insert this lingo here? >>>>> $:/keepstate/dynamictables/$(currentTable)$ >>>>> >>>>> JWHoneycutt >>>>> >>>>> -- >>>>> >>>> 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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/tiddlywiki/79389ea1-4cff-45b1-b8bf-d50d016c4ac2n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/tiddlywiki/79389ea1-4cff-45b1-b8bf-d50d016c4ac2n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> 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 [email protected]. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/tiddlywiki/be262d4b-3b07-4717-8d3d-bc0160fdd165n%40googlegroups.com >>> <https://groups.google.com/d/msgid/tiddlywiki/be262d4b-3b07-4717-8d3d-bc0160fdd165n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/tiddlywiki/4ce751df-cdc3-4073-9807-4061cc3831b2n%40googlegroups.com > <https://groups.google.com/d/msgid/tiddlywiki/4ce751df-cdc3-4073-9807-4061cc3831b2n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/CAAV1gMA4M10s3c8xqJ0Xn%3DdpTfd7KhSYY2mWwxOiJv-%3DKRs--Q%40mail.gmail.com.
