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 [email protected].
To post to this group, send email to [email protected].
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/b5d00198-85c6-4063-8b35-bce7828d2be0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to