Setting up questions another way
We are not telling you that one way is better than another.
Purpose
On this page will be a few examples of question layouts that can be helpful
Example 1
First example is long hand version, each question is basic
Roller Blind 21/10/2020 | Unique Option Name | CONH | CONTROLS | CONTROLSIDE | CHLENG | CHCOL | MOT | REMCH | REMCOL |
Inventory Code for Pricing |
|
|
|
|
|
|
|
|
Value applies to Price from Related Option Name |
|
|
|
|
|
|
|
|
Related Column Data Field |
|
|
|
|
|
|
|
|
Related Column is Add (Y) to else Set to (N) |
|
|
|
|
|
|
|
|
Look Back @ BUZ Column Name |
|
|
|
|
|
|
| REMCH |
Question Heading | Controls | Control | Control side | Chain length | Chain colour | Motor Type | Remote Channels | Remote Colour |
Option Type | H | L |
|
|
|
|
|
|
Is Required |
| Y |
|
|
|
|
|
|
Can Mass Update |
|
|
|
|
|
|
|
|
Clear value when Copied to new item |
|
|
|
|
|
|
|
|
Is Not for Online Wholesale Ordering |
|
|
|
|
|
|
|
|
Is Not for Shopping Cart Ordering |
|
|
|
|
|
|
|
|
Use First valid Answer as default |
|
|
|
|
|
|
|
|
Help Message |
|
|
|
|
|
|
|
|
Picture URL |
|
|
|
|
|
|
|
|
Answers from here down |
| Chain | Left | 500 | Silver Metal|OPCHAINMETAL | Somfy LT50 | 16 Channel Remote | 16 Channel Remote|Pure |
Answers from here down |
| Motor | Right | 750 | Beige | Somfy Altus 40RTS | 4 Channel Remote | 16 Channel Remote|Silver |
Answers from here down |
|
|
| 1000 | Birch White | Somfy Altus 50RTS | 6 Channel Timer Remote | 4 Channel Remote|White |
|
|
|
|
| Black | Acmeda Low Voltage |
| 4 Channel Remote|Black |
|
|
|
|
| White | Acmeda AC 240v |
| 6 Channel Timer Remote|Pure |
|
|
|
|
|
| Acmeda Battery Powered |
| 6 Channel Timer Remote| Silver |
Example 2
This table has the same information but uses it differently to reduce the amount of questions, but can be tricky to setup as you need to reference other columns to make this work
Roller Blind 21/10/2020 | Unique Option Name | CONH | CONTROLS | CHAINLENGTH | CONTROLOPTION | REMOTEOPTION |
Inventory Code for Pricing |
|
|
|
|
|
Value applies to Price from Related Option Name |
|
|
|
|
|
Related Column Data Field |
|
|
|
|
|
Related Column is Add (Y) to else Set to (N) |
|
|
|
|
|
Look Back @ BUZ Column Name |
|
| CONTROLS | CONTROLS | CONTROLOPTION |
Question Heading | Controls | Control | Chain Length | Control Option / Colour | Remote Type |
Option Type | H | L | L | L | L |
Is Required |
| Y | Y | Y |
|
Can Mass Update |
|
|
|
|
|
Clear value when Copied to new item |
|
|
|
|
|
Is Not for Online Wholesale Ordering |
|
|
|
|
|
Is Not for Shopping Cart Ordering |
|
|
|
|
|
Use First valid Answer as default |
|
|
| Y |
|
Help Message |
|
| Standard length is 1500mm |
|
|
Picture URL |
|
|
|
|
|
Answers from here down |
| Left Chain | LEFT CHAIN|500|OPCHN500 | LEFT CHAIN|Silver Metal|OPCHAINMETAL | LEFT MOTOR|16 Channel Remote - Pure|REM16CHPURE |
Answers from here down |
| Right Chain | LEFT CHAIN|750|OPCHN750 | LEFT CHAIN|Beige | LEFT MOTOR|16 Channel Remote - Silver|REM16CHSILV |
Answers from here down |
| Left Motor | LEFT CHAIN|1000|OPCHN1000 | LEFT CHAIN|Birch White | LEFT MOTOR|4 Channel Remote - Pure|REM04CHPURE |
|
| Right Motor | LEFT CHAIN|1250|OPCHN1250 | LEFT CHAIN|Black | LEFT MOTOR|4 Channel Remote - Silver|REM04CHSILV |
|
|
| LEFT CHAIN|1500|OPCHN1500 | LEFT CHAIN|White | LEFT MOTOR|6 Channel Timer Remote - Pure|REM06CHPURE |
|
|
| RIGHT CHAIN|500|OPCHN500 | RIGHT CHAIN|Silver Metal|OPCHAINMETAL | LEFT MOTOR|6 Channel Timer Remote - Silver|REM06CHSILV |
|
|
| RIGHT CHAIN|750|OPCHN750 | RIGHT CHAIN|Beige | LEFT MOTOR|Single Remote - Pure|REMSIGLPURE |
|
|
| RIGHT CHAIN|1000|OPCHN1000 | RIGHT CHAIN|Birch White | LEFT MOTOR|Single Remote - Silver|REMSIGLSILV |
|
|
| RIGHT CHAIN|1250|OPCHN1250 | RIGHT CHAIN|Black | RIGHT MOTOR|16 Channel Remote - Pure|REM16CHPURE |
|
|
| RIGHT CHAIN|1500|OPCHN1500 | RIGHT CHAIN|White | RIGHT MOTOR|16 Channel Remote - Silver|REM16CHSILV |
|
|
|
| LEFT MOTOR|Somfy LT50|MOTSOMLT50 | RIGHT MOTOR|4 Channel Remote - Pure|REM04CHPURE |
|
|
|
| LEFT MOTOR|Somfy Altus 40RTS|MOTSOMALT40 | RIGHT MOTOR|4 Channel Remote - Silver|REM04CHSILV |
|
|
|
| LEFT MOTOR|Somfy Altus 50RTS|MOTSOMALT50 | RIGHT MOTOR|6 Channel Timer Remote - Pure|REM06CHPURE |
|
|
|
| LEFT MOTOR|Acmeda Low Voltage|MOTACMLV | RIGHT MOTOR|6 Channel Timer Remote - Silver|REM06CHSILV |
|
|
|
| LEFT MOTOR|Acmeda AC 240v|MOTACM240AC | RIGHT MOTOR|Single Remote - Pure|REMSIGLPURE |
|
|
|
| LEFT MOTOR|Acmeda Battery Powered|MOTACMBATT | RIGHT MOTOR|Single Remote - Silver|REMSIGLSILV |
|
|
|
| RIGHT MOTOR|Somfy LT50|MOTSOMLT50 |
|
|
|
|
| RIGHT MOTOR|Somfy Altus 40RTS|MOTSOMALT40 |
|
|
|
|
| RIGHT MOTOR|Somfy Altus 50RTS|MOTSOMALT50 |
|
|
|
|
| RIGHT MOTOR|Acmeda Low Voltage|MOTACMLV |
|
|
|
|
| RIGHT MOTOR|Acmeda AC 240v|MOTACM240AC |
|
|
|
|
| RIGHT MOTOR|Acmeda Battery Powered|MOTACMBATT |
|
Feedback, questions or other solutions, feel free to email support@buzsoftware.com.au