AX2299

Using named action tag pairs

When using action code processing, you can define names for action tags to create explicit matching pairs of tags. You may wish to name action tags if there are many action tags in the sheet, and you want to ensure that only certain combinations of those tags match up within the sheet.

To define a name for an action tag, append the name to the tag using a colon. For example:

This tag now only matches with other tags that contain the text [Copy:Actuals]. If the tag intersects with a regular copy tag ([Copy]), or with a copy tag with a different name ([Copy:Budget]), that intersection is not considered an action tag pair and is ignored.

NOTE: The purpose of named action tag pairs is different than named ActionCodes tags. Named action tag pairs provide a way to prevent accidental matches within the sheet. Named ActionCodes tags provide a way to process only the action codes within that particular ActionCodes control row and control column, on demand. For more information, see Defining the ActionCodes tag.

In the following screenshot, the only action cells are F8 and N9. Because the tag in F4 contains the name "Actuals," it only matches with the corresponding tag in C8. F9 and N8 are not action cells, because their tag names do not match.

If you had a multi-row calc method where you needed to perform a different copy action in the same column but in a different row, you could name the second copy action and combine the action tags like so:

Now cell F4 contains the named tags for both copy actions. The Copy:Actuals action is performed on cell F8, and the Copy:Calc action is performed on cell F9. In this particular example, you could get around the need to name the actions by moving the copy definitions to the control column instead of the control row, like so:

Now the definitions are per row instead of per column, and both match with the "simple" tag in F4. You could decide to use either setup, depending on what other actions you need to accomplish in this sheet.