On this page we will explain Row 6 - Look Back @ BUZ Column Name
For this example you can Ignore the data in rows 2-5 and 9-16
The scenario for this is that depending on the type of system that is selected in Column B "SYS" then opens or closes the answers that can be selected furth on
Rows 17 and below list options for both ‘L’ and Look-Back commands. These can consist of up to 3 sections separated the vertical line (Known as the Pipe character| ) The parameters are explained using the following example:- LEFT CHAIN|Stainless Steel|OPCHASSTL
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. |
Until "Price On" is answered the following questions do not have any available answers
If "Standard Matrix" is selected "S40" and "S60" are available
But if "Upgrade to S60" only "S60" is available
To make this possible we have to set up the answers in a way that restricts the outcomes depending on the answer
The first thing to look at here is that the "HEADINGS" and the "Look Back @BUZ Column Name"
I have highlighted the matching cells in Red, Green and Yellow to show how they connect, but note that the HEADING must be on the left of any look backs, you cannot have the Question after the look back
| A | B | C | D | E | F | G | H | |
| 1 | Roller Blind 14/08/2019 | Unique Option Name | SYS | SIZES | SYSREQ | BOTTOMTRIM | RAILCOLOUR | CONTROLS | CONTROLOPTION |
|---|---|---|---|---|---|---|---|---|
| 2 | Inventory Code for Pricing | |||||||
| 3 | Value applies to Price from Related Option Name | |||||||
| 4 | Related Column Data Field | |||||||
| 5 | Related Column is Add (Y) to else Set to (N) | |||||||
| 6 | Look Back @ BUZ Column Name | SYS | SYS | SYS | BOTTOMTRIM | SYS | CONTROLS | |
| 7 | Question Heading | Price On | Opening/Make Size | System | Bottom Rail Type | Rail Colour | Control | Control Option / Colour |
| 8 | Option Type | L | L | L | L | L | L | L |
| 9 | Is Required | Y | Y | Y | Y | Y | Y | Y |
| 10 | Can Mass Update | |||||||
| 11 | Clear value when Copied to new item | |||||||
| 12 | Is Not for Online Wholesale Ordering | |||||||
| 13 | Is Not for Shopping Cart Ordering | |||||||
| 14 | Use First valid Answer as default | Y | Y | Y | Y | |||
| 15 | Help Message | Any Rollers over 3000mm Must use Box90 | ||||||
| 16 | Picture URL | |||||||
| 17 | Answers from here down | Standard Matrix|OPSTMATX | STANDARD MATRIX|Opening | STANDARD MATRIX|S40 | STANDARD MATRIX|Oval|OPBTOVAL | OVAL|Clr Anod | STANDARD MATRIX|Left Chain | LEFT CHAIN|Silver Metal|OPCHAIN |
| 18 | Answers from here down | Upgrade to S60|OPRL60UPX | STANDARD MATRIX|Make | STANDARD MATRIX|S60 | STANDARD MATRIX|Premium|OPRLBRAILLGX | OVAL|White | STANDARD MATRIX|Right Chain | LEFT CHAIN|Beige |
| 19 | Answers from here down | Box70 Blackout Sys|OPRLPELBOX70X | UPGRADE TO S60|Opening | UPGRADE TO S60|S60 | UPGRADE TO S60|Oval|OPBTOVAL | OVAL|Black | STANDARD MATRIX|Link Left Chain | LEFT CHAIN|Birch White |
| 20 | Box90 Blackout Sys|OPRLPELBOX90X | UPGRADE TO S60|Make | BOX70 BLACKOUT SYS|S40 | UPGRADE TO S60|Premium|OPRLBRAILLGX | OVAL|Birch | STANDARD MATRIX|Link Right Chain | LEFT CHAIN|Black | |
| 21 | BOX70 BLACKOUT SYS|Opening | BOX90 BLACKOUT SYS|S40 | BOX70 BLACKOUT SYS|Blackout Sys|OPBOSYS | OVAL|Chrome | STANDARD MATRIX|Link Left Slave | LEFT CHAIN|White | ||
| 22 | BOX90 BLACKOUT SYS|Opening | BOX90 BLACKOUT SYS|Blackout Sys|OPBOSYS | STANDARD MATRIX|Link Right Slave | RIGHT CHAIN|Silver Metal|OPCHAIN | ||||
| 23 | PREMIUM|White | STANDARD MATRIX|Link Middle Slave | RIGHT CHAIN|Beige | |||||
| 24 | PREMIUM|Black | STANDARD MATRIX|Left Motor | RIGHT CHAIN|Birch White | |||||
| 25 | BLACKOUT SYS|Clr Anod | STANDARD MATRIX|Right Motor | RIGHT CHAIN|Black | |||||
| 26 | BLACKOUT SYS|White | STANDARD MATRIX|Link Left Motor | RIGHT CHAIN|White | |||||
| 27 | BLACKOUT SYS|Black | STANDARD MATRIX|Link Right Motor | LINK LEFT CHAIN|Silver Metal|OPCHAIN | |||||
| 28 | UPGRADE TO S60|Left Chain | LINK LEFT CHAIN|Beige | ||||||
| 29 | UPGRADE TO S60|Right Chain | LINK LEFT CHAIN|Birch White | ||||||
| 30 | UPGRADE TO S60|Link Right Chain | LINK LEFT CHAIN|Black | ||||||
| 31 | UPGRADE TO S60|Link Left Slave | LINK LEFT CHAIN|White |