Replacing values in choices

When you change a value in a choice list, values in a database are not modified. To help dealing with data we’ve added the Replace button to the Column Properties Form of the text columns with choices.

To replace values in a Text column with choices:

Click the Setup link at the top right corner of the window.

Select a table you need.

From the setup menu select Columns > Customize existing columns. The system will display the Columns form.

Select Column for Replace

On the Columns form click a necessary column name and the Column Properties Form will be displayed.

Replace Button

After clicking the Replace button TeamDesk will prompt you to select an original value from a database and a replacement value from the list of choices.

Replace Variants

When you click on the Replace button all values indicated in the Find what field will be replaced with the value indicated in the Replace with field.