Available from Tables 2027.3.
Many columns in Tables come with a selection list: Revit parameters such as a type or a material, and every column that you gave a selection source from an external datasource. With Validate from Datasource these lists turn into a data validation as you know it from Excel:
- The cells of the column show a dropdown arrow. Click it to pick a value instead of typing it.
- A typed value that is not in the list is rejected, so spelling mistakes and outdated values do not reach the model.
Switch the validation on
- Select one or more cells in the columns you want to validate. You can select several columns at once.
- On the Data tab, click Validate from Datasource in the Data Tools group.
"Validate from Datasource" on the "Data" tab, here for the column "Finish"
The button stays highlighted while the cursor is in a validated column. To switch the validation off again, select the column and click the button once more.
If a selected column has no selection list, Tables tells you which columns it could not validate and leaves them unchanged. The button is not available in read-only workbooks and for columns that accept several values in one cell.
Pick a value from the list
Select a cell of the column and click the arrow next to it, or press Alt+Down. Choose the value from the list.
The dropdown offers the values of the column's selection list
The new value is written to Revit with Apply, as with any other change.
Typing a value that is not in the list
You can still type into the cell. If the value is not in the list, Tables shows the message Invalid value. Click Retry to correct the entry or Cancel to keep the previous value.
"Metal" is not one of the door finishes, so the entry is rejected
Good to know
- The list follows the model. Every Reload reads the selection lists again, so new types, materials or entries of an external datasource appear in the dropdown without any further step.
- Lists that depend on the row. If a selection source narrows the values per row (join rules), the dropdown offers all values of the source. To pick from the values that fit the row, right-click the cell or use the Value list command.
- Saved with the workbook. The validation is stored in the workbook and also works when the file is opened in Excel. Tables keeps the lists on a hidden worksheet named PX_ValueLists; do not use this name for a sheet of your own.
- Removing a table also removes its validations and lists.
- Excel's own Data Validation command next to it still works for any other check you set up yourself; Tables leaves such validations untouched.
Comments
0 comments
Please sign in to leave a comment.