Overview

MergeUp offers a dynamic and flexible approach to template document creation by allowing the seamless integration of JavaScript code within your templates. This powerful feature empowers advanced template creators to process, reformat, filter, and manipulate data as they see fit. MergeUp enables you to create custom functions, declare variables, and access data throughout the entire template document. In this article, we will explore the purpose, key functionalities, and next steps for utilizing JavaScript within MergeUp template documents.

Purpose

The purpose of incorporating JavaScript into MergeUp template documents is to expand the possibilities of what you can achieve with your templates. While MergeUp already provides robust data retrieval through queries, JavaScript integration takes your template documents to the next level. You can now apply complex data processing, implement custom logic, and create dynamic content, limited only by your JavaScript skills and creativity.

Key Functionalities

1. Processing Data: JavaScript integration allows you to process data within your template documents efficiently. Whether you need to perform calculations, manipulate strings, or apply conditional logic, JavaScript empowers you to do so seamlessly. For example, you can calculate totals, averages, or other derived data directly within your templates.
2. Custom Functions and Variables: You can seamlessly create custom functions and declare variables, all of which can be utilized throughout the entire template. This approach centralizes logic and preprocessing, enhancing template readability and maintainability.

3. Data Accessibility: MergeUp treats data from queries as standard JavaScript objects. This means you can easily access, modify, and manipulate query data using JavaScript. Whether you're filtering records, sorting data, or applying transformations, JavaScript integration ensures you have full control over how your data is presented. Here is a skeleton structure of how to visualize the data that comes in from queries:

   {
       "baseQueryName": {
           "field1": "value",
           "field2": "value",
           "alias1": "value",
           "alias2": "value",
           "childQueryName1": [
               {
                   "childField1": "value",
                   "childField2": "value",
                   "grandChildQueryName1": []
               },
               {
                   "childField1": "value",
                   "childField2": "value",
                   "grandChildQueryName1": []
               }
           ],
           "childQueryName2": []
       }
   }
           

Next Steps

• EXEC Command - Check out how to use JavaScript in the template using the EXEC template command: About EXEC

• Learn JavaScript - If you're not already proficient in JavaScript, invest time in learning the language. Understanding JavaScript fundamentals will enable you to leverage its power effectively within MergeUp.

• Master Custom Functions - Explore how to create and utilize custom functions within your template documents. This is a key aspect of optimizing your template's logic and organization.

• Experiment and Iterate - Don't be afraid to experiment with your templates. Test different JavaScript code snippets, functions, and data manipulations to see what works best for your specific use case.