Dynamic Keyword Links
I was asked to introduce a wiki like experience to our legacy content management system to create dynamic page links from a list of keywords, alternative terms and URL's.
I authored an Excel macro that reformatted and saved an Excel spreadsheet as JSON to a secured location, this was then read by Javascript via an API that was given a content scope, format options such as case sensitivity and html tag exclusion (like headings and existing links).
Dynamically created anchor links were than created from the keywords that met the scope and had matches
This is a test piece of text that contains the keywords in my array like Photos, Google, Github, Portfolio, Instagram, email and Simon Philpott, ignoring the keywords if they're in
Portfolio headings
or if they are existing
Simon Philpott links.
Filterable, sortable tables
This project goal was to extend the user interaction for data tables on a legacy content management system, with very minimal administration required. Requirements were to allow staff to quickly find (in the case of business use)
documents contained within a table and apply filters to the table based on a series of meta data fields. Specification stated the use of vanilla ES5 Javascript with no reliance on libraries and with all environmental requirements
like the checkboxes to be dynamic
Extension to this functionality later included sortable columns, specific special character/keyword handling, URL pre-filtering on page loading and the requirement to port this functionality over to a future platform
| First Name |
Last Name |
Skills |
Location |
| John |
Doe |
Hula hooping |
Scotland |
| Sue |
Doe |
Juggling / Karate |
Scotland |
| Mary |
Moe |
Juggling / Frisbee |
Australia |
| Julie |
Dooley |
Singing |
America |