Merge and store documents using Zoho Writer
You can now use template functions to merge and store documents using Zoho Writer. The document template is built using the fields being merged from Zoho Sprints. The in-built deluge functions deliver the values to the merge fields in the document, enabling you to create new Writer file while updating or creating respective Sprints modules. Learn about custom functions.
Prerequisites: Merging documents comes with a few prerequisites:
- You need to create writer template from scratch to facilitate the merge. Learn how to create writer template
- You need to add Zoho Writer as a connection in Zoho Sprints and Zoho Sprints as a connection in Zoho Writer to establish a secure interaction between the two applications. Learn how to add connection
This capability is supported in the following modules:
- Project
- Sprint
- Epic
- Release
- Item
The pre-built template functions provide you with the necessary script to set up merging document. The following are the available template functions:
- Generate project document: Create a new writer document while creating or updating a Project
- Generate sprint document: Create a new writer document while creating or updating a Sprint
- Generate epic document: Create a new writer document while creating or updating an Epic
- Generate release document: Create a new writer document while creating or updating a Release
- Generate work item: Create a new writer document while creating or updating a Work Item
Note: This is only for document creation and not for updating existing documents in Zoho Writers.
Example
Let's assume you are an online course creation platform and for each course your team creates a project. At the start of the project, you need to prepare a course outline and contents document with your team. Both your project creation and document creation process can be unified and the effort halved with the help of the merge document functions. All you need to do is, add Zoho Writer connection, create a writer template from scratch, select automate option, and use the gallery function in the Zoho Sprints. This will automate your document merge process.
Create Writer Template
You need to create a writer template from scratch to facilitate the merge document process. Add Zoho Sprints connection in your Writer to allow the interaction between the two.
To create writer template:
- Open Zoho Writer.
- Click the Create New button.
- Select Merge Template. Learn more
- Select Create from Scratch. A template will be created.
- Enter document name. The Automate option in the left navigation panel will be enabled.
- Select Automate.
- Click Add data source link. The data sources will be listed.
- Select Custom Data Sources.
- Select Gallery Function. The Sprint Functions will be listed.
- Click the Use button against the required function. The gallery function will appear.
- Click the Save and Link button. The required module will be linked to the template. The Manage Fields section will display the fields linked from the respective Zoho Sprints module.
The modules are linked as Main Fields and Subforms:
- Projects
Main Fields: Project Module
Subforms: Release, Sprint, Epic and Project users - Release
Main Fields: Release Module
Subforms: Work Items - Epic
Main Fields: Epic Module
Subforms: Work Items
- Sprints
Main Fields: Sprint Module
Subforms: Work Items, Meetings, and Sprint Users - Work Items
Main Fields: Item Module
Subforms: Sub Items, Linked Items, Checklists, Meetings, and Log Hours
Merge document template function
To merge document using template gallery functions:
- Click on the setup icon to navigate to the Setup page.
- Select Automation .
- Select Custom Functions.
- Click the dropdown arrow on the Function button.
- Select Gallery Function.
- Hover on the required function.
- Click the Create button. The Create Custom Function window will appear.
- Enter Display Name
- Enter Function Name.
Note: According to the general naming convention, function name cannot contain spaces. - Select Category as Automation.
Note: - The Module, Description, Parameter Names, and Parameter Values are predetermined based on the logic of the probable scenarios. You can edit them if necessary.
- A parameter is a variable assigned to a value in a function.
- The parameter value is the information passed in the function. In other words, the parameter name is the container and the parameter value is the information contained in it. These allow you to build a logical script into which actual input data can be passed when the function is invoked.
- Replace file Name (Document Name), Template ID (Document Template ID), and Folder ID (Workdrive Folder ID). These are mandatory parameters under the custom parameters section.
Template ID is the last part in the document URL (Example: https://writer.zoho.com/writer/open/t9j5a34906fe4d05640be97ec702cf1c4d6f)
Folder ID is the last part in the folder URL (Example: https://workdrive.zoho.com/home/6oq3d00e1e07d58c64077b4f1ca4a777/teams/folders/0kfnse1e2feb6cc894c2eb49dc4d1d3b1987f) - Select the Trigger Event at which the function needs to be executed. The trigger events are dependent on the module selected.
- Edit the existing script in the Deluge script builder to suit your requirement.
- Click Save to complete creating the function, or click Save and Execute to complete creating the function and execute it. The Zoho Writer document will be created in the respective Workdrive folder.
Note: Replace the writerconnection and the sprintconnection in the script with the respective connection link names within double quotes.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
About custom functions
Zoho Sprints comes with the capability for you to create custom functions and automate your business process. A Custom Function is composed of a group of deluge statements that are combined to perform a certain task. This function can be invoked ...Manage custom functions
You can perform the following actions for functions: Create function Edit function Delete function Create function from gallery Create function To create custom function: Click the gear icon at the top-right. The settings window will appear. Select ...Execute standalone functions
Use standalone functions to process data that are operated by external parameters. Zoho Sprints provides the ability to create functions and use REST APIs to execute them to arrive at simple business solutions. These functions can be triggered from ...Data Encryption in Zoho Sprints
Encryption is primarily used to safeguard the content of a message so that only the intended recipients can read it. This is done by replacing the content with unrecognizable data, which can be understood only by the intended recipient. Encryption ...Zoho Sprints GDPR Compliance
Data privacy and security are the core elements that every business should guarantee its customers with. Keeping this in mind, the European Union's General Data Protection Regulation (GDPR) came into discussion. It enforces all the businesses across ...
New to Zoho LandingPage?
Zoho LandingPage Resources