AX1443

ManagePlanFileAttachments function

Opens a dialog that allows the user to add, edit, or delete an attachment. This function can be used in an Axiom file to provide an alternate method of managing plan file attachments.

NOTE: ManagePlanFileAttachments is not for use in Axiom forms. For more information, see Using file attachment features in an Axiom form.

Syntax

ManagePlanFileAttachments("DisplayText", "FileGroupName", PlanFileCode)

Parameter Description

DisplayText

Parameter	Description
DisplayText	The text to display in the cell. This text displays as normal text in the cell. If you want the text to appear like a hyperlink on a web page, you must manually apply the font formatting to the cell. This parameter supports use of the variable `{count}`, which can be used to display the count of attachments for the plan file.
FileGroupName	The name of the file group that the plan file belongs to. A file group alias name can also be used.
PlanFileCode	The plan file code for which you want to manage attachments, such as 21000.

The text to display in the cell.

This text displays as normal text in the cell. If you want the text to appear like a hyperlink on a web page, you must manually apply the font formatting to the cell.

This parameter supports use of the variable {count}, which can be used to display the count of attachments for the plan file.

FileGroupName

The name of the file group that the plan file belongs to. A file group alias name can also be used.

PlanFileCode

The plan file code for which you want to manage attachments, such as 21000.

All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell. However, the Boolean values TRUE and FALSE do not need to be in quotation marks.

Remarks

Users must have read/write access to the plan file in order to manage attachments. If the user has read-only access to the plan file, then the Browse Attachments dialog opens instead, so that the user can open existing attachments (same as when using GetPlanFileAttachment). If the user has no access to the plan file, then an error message is shown.
ManagePlanFileAttachments is a non-volatile function. This means that if the {count} variable is used, it will not automatically update when the count changes—the sheet must be refreshed in order to update the function.

Examples

=ManagePlanFileAttachments("Manage Attachments for Dept 21000","Budget 2020",21000)

This example opens the Manage Attachments dialog so that the user can add, edit, or delete attachments for plan file 21000 in file group Budget 2020.

=ManagePlanFileAttachments("Manage Attachments for Dept 21000","Current Budget",21000)

This example is the same as the first example, except that this time a file group alias name is used. When the alias is edited to point to a different file group, the function will update as well. In this case, the plan file codes should be queried dynamically and then referenced in the function, to ensure that the function is using the correct codes for the current file group.