Text, checkbox & date
In addition to number and dropdown input columns, you can also use columns of types text, checkbox and date to capture manual data.
Let's cover them one by one.
If you are using Inforiver Enterprise, you need to sign in to start inserting a number column.
1. Text
Text columns or measures can be inserted to capture text.
a) Select 'Text' from the Data Input dropdown.
b) The text column side panel is shown in the image below.
You can choose to insert as a visual measure or column. Text entry can be enabled or disabled in the total/subtotal rows using the 'Allow entry on total/subtotal rows' checkbox. Input access can be configured using the 'Allow input' option. You can also set field validations which will be discussed later in this section.
Click 'Create'.
c) The text column gets inserted. Double-click on any of the cells and start typing the text in the editor. Press Enter to commit the text entry.
Word wrap
Inforiver provides an option to wrap the text for long entries that get truncated.
Click on the word wrap icon in the Home ribbon to wrap text as per the width of the field.
Text validations
Inforiver provides the ability to add data validations for text inputs. You can add validations to check the length, and data type (numeric/text/alphanumeric).
You can also enforce that a text entry should be an email or URL or even provide a regular expression using the Custom option.
For example, if you choose email as Field Validation and the data entered is not a valid email ID, Inforiver will generate a pop-up error notification.
2. Checkbox
Checkbox columns or measures can be inserted to capture binary inputs. Click on 'Checkbox' in the 'Data input' dropdown.
The checkbox column side panel is shown in the below image.
You can choose to insert as a visual measure or column. Entry can be enabled or disabled in the total/subtotal rows using the 'Allow entry on total/subtotal rows' checkbox. Input access can be configured using the 'Allow input' option.
Click 'Create'.
Click on any of the cells to check the checkbox.
3. Date
a) Date columns or measures can be inserted by clicking on 'Checkbox' in the 'Data input' dropdown.
b) The date column side panel is shown in the below image.
You can choose to insert as a visual measure or column. Entry can be enabled or disabled in the total/subtotal rows using the 'Allow entry on total/subtotal rows' checkbox. Input access can be configured using the 'Allow input' option.
c) The date format can be changed by clicking on the 'Format' dropdown. Choose the desired format.
d) You can also define minimum and maximum date ranges for the date input. Click on the calendar icon and choose a date.
e) After selecting the date ranges (these are optional fields), click 'Create'.
f) The date column gets inserted. To enter data, double-click on a cell. Select a date from the calendar/date picker.
g) The date gets captured in the chosen format.
h) A date can also be entered in the fields directly instead of navigating using the calendar.
In the next section, we'll be covering the data input features available only in Inforiver Enterprise.
Last updated
