Relational Domino Example Database
As some of you have already noticed I published a new article yesterday. Well what kind of friend would I be if I didn't back it up with this demo application?
If you haven't already, I suggest you read the article to see what the demo is trying to achieve. Then create a new article. Give it a title and use the "Add Link..." button to add links to some related articles before you click Submit. Now edit the title of one of the article you linked to and return to your original. Notice the title has updated. Delete an article you linked to and see how it's no longer in your list of links. After deleting an article, put you original in edit mode and notice you are prompted to remove the ID of the article that no longer exists.
Note: You might have worked out that you've got edit and delete rights to this database. Please don't abuse this and go deleting everything. You just spoil it for the rest of us! Please don't write anything untoward either as I will have to delete it and I've got better things to do.
If this technique does nothing else it will no doubt create discussion. As some of you have pointed out there are other ways of achieving the same thing using "standard" Notes elements. I knew this. What I always try to do is show as many different approaches to problems as possible. We all know the normal ways. How about "thinking different" for a change?
Jake -
The way I would probably attack this issue is to categorize each article, then add an embedded, single category HTML view at the bottom of the form which displayed the related articles for the designated category. This is a simple solution that becomes more complex when you want to start assigning multiple keywords to an article, but it's a start!
-- Mike
Hate to be a pain... but the links on your blog return an error. It's appending the apps/db to the base href.
Thought you'd like to know ;-)
-Chris
Mike. That works but how do you know that somebody wants all article in a certain category to be deemed related. Surely it's better to have the ability to list any or all articles as needed.
Thanks Chris. You're right, I do link to know. Fixed now.
More is better! ;->
Seriously, I think it can be done by utilizing categories and subcategories, especially by building in functionality that allows articles to span multiple categories/subcategories. As a developer, I would rather code more in the backend to eliminate the need of maintenance further down the road, whether it be design maintenance or the users of the app having to scrub the data.
-- Mike
Kake
any plans to allow us to download the demo application? One would find this extremely useful. Thank you kind sir. Charles
The download will be attached to the next article that completes the "series". Probably some time within the next month.
You shouldn't really need it though! You've got the @formula you need and all the JavaScript is available in the source HTML of the demo. Plug it all together and you've got the solution...