Inputs
Spreadsheets help Inputs from jquery.sheet interface
A | B | C | D | E | F | G | H | |
1 | Inputs are for capturing fixed data, such as a drop down list (INPUT.SELECT), or a checkbox (INPUT.CHECKBOX) | |||||||
2 | Input Type | Example | Data Number | Data String | ||||
3 | Select List | "=INPUT.SELECT(D3:D10)" | 34 | Lorem | ||||
4 | Radio List | "=INPUT.RADIO(E3:E10)" | Lorem
Proin Aliquam Quisque Aliquam Vivamus Etiam Donec |
-20 | Proin | |||
5 | Checkbox | "=INPUT.CHECKBOX(E3)" | Lorem | 123 | Aliquam | |||
6 | Get Select List Value | "=INPUT.SELECTVAL(C3)" | 4 | 123 | Quisque | |||
7 | Get Radio List Value | "=INPUT.RADIOVAL(C4)" | Donec | 4 | Aliquam | |||
8 | Get Checkbox Value | "=INPUT.CHECKBOXVAL(C5)" | Lorem | 534456 | Vivamus | |||
9 | Detect if Checkbox is Checked | "=INPUT.ISCHECKED(C5)" | FALSE | 3 | Etiam | |||
10 | 1 | Donec |