Applying Macros to Columns

Macros are easily applied to columns in a table via the context menu or Column List dialog.

Applying macros to columns via the context menu

Select one or more columns of the same data type, right-click on your mouse and then select Macros > <data type> Macro.

The macro type that displays depends on the data type of the column(s) you selected. You cannot apply macros to columns of different data types.

 

The changes you specified in your macro are applied to your column(s).

 

Applying macros to columns via the Column List dialog

Macros can also be applied via the Column List dialog. Launch the Column List dialog from any column in your table. Your available macros, both Personal and Shared, display at the bottom of the dialog.

 

Select a column in your table to which a suitable macro (i.e., a numeric macro for a numeric field) should be applied and then click the Apply button to the right of the macro type to apply. The macro is applied to all columns with the same data type as the column you selected, and the Data Preview displays the results of your macro.

 

Select OK to save your column changes.