Search the Community
Showing results for tags 'categoryfield'.
-
Is it possible in ProcessWire to 'construct' a text output from fields on different pages in different categories that are linked by a relational ID as in a relational database? Sample of text output: 495 YEARS AGO - on Sunday 29 September 1518 (+) Artist Tintoretto originally Jacopo Comin aka Il Furioso, is born in Venice, Italy. ------------------------------------------------------------------------------------------------- Where "495 years ago" is calculated from the date field in the 'event' page (the one that gathers information from other 'related' pages), "Artist", "Tintoretto", "Jacopo Comin" and "Il Furioso" are fields (occupation, lastname, original, alias,....) in a 'name' page, and "Venice" and "Italy" are fields in a 'location' page. The 'name' and 'location' pages would all have a unique ID linked to the 'event' page (with a unique ID as well) to get the related fields. This would also allow the page "Tintoretto" to list all 'event' pages that are related to Tintoretto and the page "Venice, Italy" to list all the events that happened in Venice. The data is now stored in a Filemaker database and I'm looking for a convenient solution to transfer it to a website. In the meantime a html-export version can be found at http://www.birthfactdeathcalendar.net. There are over 10000 events and 4000 names. The 'Scyscrapers' sample website comes close to what I'm after but when digging in deeper I guess I need some extra skills in defining what goes where (categorisation) and how to bring it together (relation). Any help or guidance is mostly welcomed.