InsertFiles function

Applies to JungleDocs for Office 365.
For a similar tutorial for JungleDocs for SharePoint 2010-2019, click here.

This article describes the formula syntax and usage of the InsertFiles function in JungleDocs for Office 365.

Description

Resolves specified documents and imports their content into a JungleDocs for Office 365 template.

Syntax

InsertFiles(recordSet; [updatable]; [clearFormatting]; [keepFormatting])

The InsertFiles function syntax has the following arguments:

• recordSet   Required. Any function that returns a recordset with items.
• updatable   Optional. A Boolean value. Makes the content control updatable, False by default. 
• clearFormatting   Optional. A Boolean value. Clears inline font and font size, leaves other formatting intact. False by default.
• keepFormatting   Optional. A Boolean value. Retains most formatting, paragraph and table styles, document theme and style set of the source document. It adjusts and copies all needed styles from source document to target, renaming duplicate styles. False by default.

Remarks

• The function is only supported in Word documents and only works with Word document content.
• The function must be placed at the root level of the document template; it is not supported in tables.
• If you set the function to be updatable, you will be able to use the Update document content action in JungleDocs for Office 365 to synchronize any later changes in the document or its metadata with the generated document. Otherwise, the content control is removed from the generated document after the initial content has been imported.

Examples

InsertFiles(GetView("Documents"; "All Documents"))

Inserts document content from the Documents library, All Documents view.

InsertFiles(GetView("Documents"; "All Documents"; true))

Inserts document content from the Documents library; the document is updatable.

InsertFiles(GetView("Documents"; "All Documents"; true; true))

Inserts document content from the Documents library; the document is updatable; the inline font and font size is cleared.

InsertFiles(GetView("Shared%20Documents/ImportFiles";"AllItems"); true; true)

Inserts document content from the Shared Documents library, ImportFiles folder; the document is updatable; the inline font and font size is cleared.

InsertFiles(GetView("SmallParts/Styles";"AllItems"); true; false; true)

Inserts document content from SmallParts library, Styles folder; the document is updatable, source document formatting is retained.

InsertFiles(GetItemByUrl("Shared%20Documents/ImportFiles/First%20Document.docx"))

Inserts the document named First Document from the Shared Documents library, ImportFiles folder.

InsertFiles(DocumentLookup; Updatable; ClearFormatting)

Inserts document content from lookup column in the SharePoint list (current list for New and Reports rules or target list for From Existing rules); the document is updatable; the inline font and font size is cleared.