---
url: /modelling-guides/creating-a-travel-planning-model/adding-data-validation.md
description: >-
  Within the Trip Planning View workview, we can now make drop lists which
  restrict what options users have when editing Text fields.
---

# Adding Data Validation

Within the **Trip Planning View** workview, we can now make drop lists which restrict what options users have when editing Text fields. First, we will make the **Type** field provide the user with only **International** and **Domestic** options. Then we will make the **Destination** field restrict input based on the selected **Type**.

Select a white cell under the **Type** measure.

Click on the **Data Validation** toolbar icon.

![Data Validation](/travel-planning-model-figures/data-validation.png)

The Data Validation window will show for the Measure **Type**. Note: This represents the entire column, not the single cell.

Within the validation field select the **Destination** dimension and **Default** hierarchy as the basis for Validation. Leave the other settings on their default values.

Click **Save Validation**.

![Data Validation Window](/travel-planning-model-figures/data-validation-window.png)

Test the Data Validation by Double Clicking on a white cell under **Type**

![Testing Validation 1.1](/travel-planning-model-figures/testing-the-validation-1.1.png)

Select a white cell under the **Destination** measure. Click on the **Data Validation** toolbar icon

![Destination measure Data Validation](/travel-planning-model-figures/destination-measure-data-validation.png)

Since we want to restrict Destinations based on the value in the **Type** column. Set the **Level** field to **Top Level -1** (which means one level below the topmost elements). In the **Parent Measure** field, set the value to **Type** (since this is the name of the Measure we are filtering on). Click **Save Validation**.

![Type Parent Measure](/travel-planning-model-figures/type-parent-measure.png)

Test the Data Validation by Double Clicking on a white cell under **Destination** where the **Type** column is not empty.

Note: if the corresponding **Type** cell is empty then no filtering will be done. The **Destination** list will show all destinations.

![Testing Validation 1.2](/travel-planning-model-figures/testing-the-validation-1.2.png)

Enter some numbers into the **No People** and **No Nights** measures. We will use these to test the calculations we are about to add.

![Entering Data into Workview 1.1](/travel-planning-model-figures/entering-information-1.1.png)

Pressing the left and right arrow while entering values will start editing the corresponding cell however the data is not saved to the MODLR Cube until you conclude editing a field with the **Enter** key.

![Entering Data into Workview 1.2](/travel-planning-model-figures/entering-information-1.2.png)