...
V Options | Lookup options |
|
|---|---|---|
LEFT CHAIN | This means that this option is only to be shown if the value selected in the Look-Back option matches it. | So if LEFT CHAIN (not case sensitive) was chosen in the previous option then Stainless Steel will be in the dropdown for them to choose. |
|Stainless Steel | This is the text that will be presented in the list to the person entering the item. | |
|OPCHASSTL | Inventory Code for pricing. This is the second option for L or third for V is used. | To indicate the inventory code to be used to look up pricing add the pipe character "|" followed by the inventory code in capitals that is to be looked up for price. This is not validated so if price does not appear check the code is correct and exists in Inventory Maintenance. |
In the example below the PELRETURN is activated for all answers to PELWIDTH but because the No|+4 in PELTYPE causes it to skip 4 columns the PELRETURN will not be available if No is selected. Note that the options under PELRETURN all have | with nothing to the left of it so the V uses any answer provided it doesn’t skip this column.
- Look back at BUZ Column Name - PELWIDTH is looking back at the PELTYPE and if the answer is "Yes" in PELTYPE then is makes the PELWIDTH avilable to answer
- Value applies to Price from Related Option Name - This means that the value of the selection in PELWIDTH is coming from the answer in PELTYPE
- Related Column Data Field - adding ITEMWIDTH here means that this column is being treated as an ITEMWIDTH and the price can use this field to calculate the Width price
| BUZ Unique Option Name as at 9/8/13 | PELTYPE | PELWIDTH | PELRETURN | PELRETURNSIZE |
| Inventory Code for Pricing | ||||
| Value applies to Price from Related Option Name | PELTYPE | |||
| Related Column Data Field | ITEMWIDTH | |||
| Related Column is Add to else Set to | ||||
| Look Back @ BUZ Column Name | PELTYPE | PELRETURN | ||
| Question Heading | Pelmet | Pelmet Width | Pelmet Return | Return Size |
| Option Type | L | & | L | & |
| Is Required | Y | |||
| Can Mass Update | ||||
| Clear value when Copied to new item | ||||
| Is Not for Online Wholesale Ordering | ||||
| Use First valid Answer as default | ||||
| Help Message | ||||
| Picture URL | ||||
| Answers from here down | Yes|OPPELYes | YES| | Both | BOTH| |
| Answers from here down | No | Left Only | LEFT ONLY| | |
| Answers from here down | Right Only | RIGHT ONLY| | ||
| None | ||||
...