logo

New Response

« Return to the main article

You are replying to:

  1. Great article, I've referenced it about 3 or 4 times now in performing my daily duties.

    A thought though on point number 5.

    Adding fields to the form to calculate some of the information is a great idea, especially if all of the information in that field pertains ONLY to the document.

    With a URL, you're taking now the server name and the file path / db file name and storing it, at calculation time, into the document.

    As soon as the database is migrated to another server, you'll need to refresh all of those documents. You can either bear that in mind and build in a tool for it, or you can simply leave the URL code up in the view column, where it will be freshly calculated each time.

    Either approach has it's advantages, but it seems to me that a good rule of thumb is only calculate and store those things the document is accountable for in its own right. Information external to that should likely be considered volatile.

    Cheers,

    Jerry

Your Comments

Name:
E-mail:
(optional)
Website:
(optional)
Comment: