Dev LabelCompany2009 Page Display Numbers

Label Company Proposal 2009 - Home

Summary

To incorporate a formula to decide what to apply it to for display on the entity pages.

This will automatically decide what number/s to choose to use to list the release under on the entity pages (the display number).

Method For Choosing Display Numbers And Shadow Numbers For Entity Pages

With the new and more versatile entity / number system, we can make a mechanism to decide what number to display / use on the entity pages. The basic example would be the same as the current system; one catalog number and one label, so that catalog number is used on the label page. However, since we will have more numbers to choose from, and also more entities to apply them to, we want a system that can choose a number from a priority list, so there will always be a number displayed on the release page (unless there are no numbers at all attached to the release). So, for example, if there is no catalog number, but there is a barcode, then the system uses the barcode on the label page

The order of priority for choosing the number to use as a label page display / sorting / reference number is:

  • Catalog Number
  • Matrix Number
  • Barcode
  • Other Number

The following process is followed for every entity on the release:

If Then
IF cat# = present AND cat#_description = "" OR cat#_description contains entity_name$ OR cat#_description does not contain any of the other entity_name$ entered on the release, use that cat# as the entity_name display_number and entity_name shadow_number REPEAT for each cat# entered If there is a catalog number there, and the description is empty, the description contains the entity name, or the description doesn't contain any of the other entity names, use that catalog number
ELSE IF we didn't find a usable cat# for the entity, but there is a cat# or cat#s entered, use that / them anyway If we didn't find a usable cat# for the entity, but there is a cat# entered, use that anyway
ELSE IF matrix# = present AND matrix#_description = "" OR matrix#_description contains entity_name$ OR matrix#_description does not contain any of the other entity_name$ entered on the release, use that matrix# as the entity_name display_number and entity_name shadow_number REPEAT for each matrix# entered If we can't find any cat# to use, the same formula is repeated, replacing cat# with Matrix Number
ELSE IF... etc repeat for Barcode, and Other Number, in that order.
ELSE use "none" If we can't find anything, display 'none'