Why not to attach a Google sheet to demonstrate the procedure! --Mohammad
On Wednesday, July 17, 2019 at 11:31:09 PM UTC+4:30, A Gloom wrote: > > Insert this in one of your sheets or all... > > After each " (cell #) - " is the text to enter into that cell > > (row 1) > (cell/col 1) - WIKI SEARCH > > (row 2) > (cell 1) - Enter search term below (an external link will appear on the > right, it will open a new browser tab with all pages containing that term) > > (row 3) > (cell 1) - (bordered cell, no text- this is the "search box") > (cell 2) - =concatenate(A4,A3,B4) > > // NOTE: cell 2 is a formula and its contents will change as cell 1's > contents change // > > (row 3) *(the "template" that is to be used by the formula) > > (cell 1) - wiki url#:[!is[system]search[ > (cell 2) - ]] > > NOTES: > > Modify the formula rows/column numbers to match your set up. > > Hide the 3rd row (right click on that rows number, select "Hide row"). > > The formula takes the typed in search term and combines it with the > "template" cells to construct a url which will with hover over the cell, > display a link that will open a new browser tab with all pages containing > the search term. > > Make sure you don't put this in a published Google sheet if the wiki being > searched is meant to be private. > -- 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/9efb037e-78b1-4d0b-9772-2490b3f5603e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.