Merge and store documents using Zoho Writer | Custom Functions | Zoho Sprints Help

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.

Notes
Prerequisites: Merging documents comes with a few prerequisites:
  1. You need to create writer template from scratch to facilitate the merge. Learn how to create writer template
  2. 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:
  1. Project
  2. Sprint
  3. Epic
  4. Release
  5. Item
The pre-built template functions provide you with the necessary script to set up merging document. The following are the available template functions:
  1. Generate project document: Create a new writer document while creating or updating a Project
  2. Generate sprint document: Create a new writer document while creating or updating a Sprint
  3. Generate epic document: Create a new writer document while creating or updating an Epic
  4. Generate release document: Create a new writer document while creating or updating a Release
  5. Generate work item: Create a new writer document while creating or updating a Work Item
Notes
Note: This is only for document creation and not for updating existing documents in Zoho Writers.

Example

Info
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:
  1. Open Zoho Writer.
  2. Click the Create New button.
  3. Select Merge Template. Learn more

  4. Select Create from Scratch. A template will be created.
  5. Enter document name. The Automate option in the left navigation panel will be enabled.

  6. Select Automate.

  7. Click Add data source link. The data sources will be listed.

  8. Select Custom Data Sources.
  9. Select Gallery Function. The Sprint Functions will be listed.
  10. Click the Use button against the required function. The gallery function will appear.

  11. 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:
  1. Projects
    Main Fields: Project Module
    Subforms: Release, Sprint, Epic and Project users

  2. Release
    Main Fields: Release Module
    Subforms: Work Items

  3. Epic
    Main Fields: Epic Module
    Subforms: Work Items
  1. Sprints
    Main Fields: Sprint Module
    Subforms: Work Items, Meetings, and Sprint Users

  2. 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:
  1. Click on the setup icon to navigate to the Setup page.
  2. Select Automation .
  3. Select Custom Functions.
  4. Click the dropdown arrow on the Function button.
  5. Select Gallery Function.
  6. Hover on the required function.

  7. Click the Create button. The Create Custom Function window will appear.
  8. Enter Display Name
  9. Enter Function Name.
    Note: According to the general naming convention, function name cannot contain spaces.
  10. Select Category as Automation.
    Note:
    1. The Module, Description, Parameter Names, and Parameter Values are predetermined based on the logic of the probable scenarios. You can edit them if necessary.
    2. A parameter is a variable assigned to a value in a function.
    3. 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.
    4. 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)

  11. Select the Trigger Event at which the function needs to be executed. The trigger events are dependent on the module selected.
  12. Edit the existing script in the Deluge script builder to suit your requirement.

  13. 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.

Notes
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 CRM Training
        Redefine the way you work
        with Zoho Workplace

          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 CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            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.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • 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 ...
                                                                                                              • 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 ...
                                                                                                              • 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 HIPAA Compliance Guide

                                                                                                                The Health Insurance Portability and Accountability Act (including the Privacy Rule, Security Rule, Breach notification Rule, and Health Information Technology for Economic and Clinical Health Act) ("HIPAA"), requires Covered Entities and Business ...
                                                                                                              • Zoho Sprints Quickstart Guide

                                                                                                                Zoho Sprints is a project management tool that functions on the principles of Agile Scrum methodology. Here, each project is divided into multiple phases. Each phase comprises select work items for the team to complete. When those work items are ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources