Validate Input in Form

Author: Kepion Product Team

Introduction

You can add validation rules to forms using the Cell Attributes feature. Here we will create a validation rule to warn users if they enter a value that's lower than expected. Should such a value be entered, a warning icon and message will appear.

Example

To set up input validation, right-click on a cell and select Add Cell Attributes.

We'll set the scope of this definition to only the Salaries member of the Account dimension. We could also include other members to limit our scope further, but for this example it won't be necessary.

On the VALIDATION tab, check the Validation check-box at the bottom and click Add. Here, we've defined the condition such that when the value is less than 100,000, we will get a warning icon and a message.

If we checked the Disallow Post check-box as well, it would prevent users from posting values that broke this validation rule. As the rule we're creating is only a warning, we'll leave this un-checked.

Click Next and then Finish. Now if we enter any Salary that is less than 100,000, we get a message warning us to double-check our entry.