Pre populated answers
- Alex Morrisson
Some questions will always have the same answer, there are other options just incase but instead of having to select the popular option you can have it populate automatically.
Just because it loads automatically doesn't mean that it cant be changed, the other options are still there if needed.
Setup
If you input a Y into row 14,
The answer in row 17 will automatically populate when an order is raised.
This also means that you need to arrange the answers with the preferred as the first answer, all other answers can be in any order.
| A | J | K | L | M |
1 | Roller Blind 21/08/2021 | Unique Option Name | SIZES | SYSREQ | BOTTOMTRIM | RAILCOLOUR |
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 |
|
|
|
|
7 | Question Heading | Opening/Make Size | System | Bottom Rail Type | Rail Colour |
8 | Option Type | L | L | L | L |
9 | Is Required | 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 |
|
|
|
|
16 | Picture URL |
|
|
|
|
17 | Answers from here down | Opening | S40 | Oval | Clr Anod |
18 | Answers from here down | Make | S60 | Premium | White |
19 | Answers from here down |
|
| Blackout Sys | Black |
20 |
|
|
|
| Birch |
21 |
|
|
|
| Chrome |
Example
