Thanks a lot Ivan.
On reflection I think my ‘locations’ example may be misleading, as addresses are a specific use case that may be handled better in another way. I don’t want to be limited to tagging a particular level in the hierarchy - I’d like to be able to enter a city or a borough in the ‘Street’ field, but still be able to find any visits to Europe.
Let me try and explain another example. This would be a broader unlimited system of nested tags, similar to a folder structure. Say these are my tags, with the indentations representing the hierarchy:
I want to tag records with these tags at any level. Say I use the tag “Flights” from the example above - that record should then be visible when I filter for Holidays.
My idea to achieve this was with two tables:
Columns TAGNAME, and PARENT
(As I mentioned, this works really well in the Org Chart block, it will visualise the structure of the tags perfectly)
Then Table DIARY
Columns TEXT, and TAGS (linked to the TagName column in the Tags table)
“text entry”, Hotel
“text entry”, France
“text entry”, Work
The challenge is then how to filter the DIARY table by all records tagged to “Holidays”. We know from the tags hierarchy that this should include the first two entries, because “Hotel” sits under “France”, and “France” sits under “Holidays”.
Any more help much appreciated! Best.