Say hello to an improved way to merge documents!

Say hello to an improved way to merge documents!

Automating all your documents from start to finish is now easier than ever with Writer's new merge tools.
 
If you haven't seen it yet, you can read the main announcement here.
Here is the full list of the features we've rolled out:

1. Dynamic Table Headers and repeated blocks
After listening to our latest user feedback, we knew these two features were a must-have.

Subform creation
Subforms are field groups that mostly denote choices, transactions, and other activities registered under a single record. With Writer, you can now create such field groups within a record that, when merged, will dynamically grow based on the records in your data source.  
 
For example: Say you want to keep track of the products purchased by a certain customer. In this case, "Customer" is a record, and "the products they purchased" are recorded as a subform under their name.
 
Subforms can be mapped to a related subform in a data source, like Zoho Creator, Zoho CRM, and more.
 


Repeating blocks
You can now repeat blocks as a paragraph, a table row, a table cell, or a table column. For instance, if you're listing the names of books, their authors and descriptions, you can just use the Repeat option of your choice, select the merge fields that carry those details, and insert it into the document.

The selected blocks with all the information you need would then automatically be repeated for each book in your data source.




2. New field types
You can now choose from a variety of different field types to up your template-creation game.

Same field, different configurations 
In case you would want the settings of a field to be different in one or a few places alone, we added a new "change for this instance" option. This way, you can tweak format, output type, and other value settings for a particular instance of a field without affecting other parts of the document where the same field is used.



Repeated blocks? Auto-number it!
If you're working with repeated blocks using the repeat field or subform fields, you can assign auto-increment serial numbers by simply inserting the new "Auto-number" field before them.
  


Embed fields to make documents more interactive
Here's something to make your templates more personalized for each of your recipients: You can now add unique, interactive elements for each of them using an Embed field. This makes it easier to add map locations for each of your records or add contextual video links to guide them.
 


Placeholder images in templates
You can now apply custom placeholder images to image fields in Writer based on the type of document you're working with.
 
In addition to giving your template designers better layout control over the template, placeholder images also let the user know the type of image to be inserted or attached.




3. Tools to format those field types
What's the point of so many different field types if you can't adjust them to your liking? That's exactly what we did.

Shortened field names
There could be fields in your data source whose names are way too long, making your templates look untidy or unclear. Long field names could also denote that your content might look drastically different if the values those fields have are usually much shorter.
 
To tackle this, we're introducing a provision in which you can shorten the names of fields in your merged documents.




Formula that output!
Know that feeling when you have everything ready and merged in your output document except for the final cost of your products? That's why we've introduced formulas in merge fields: so you no longer have to calculate your figures manually. You can now use formulas to calculate your merged output using the desired functions.



Personalized date formats
Certain documents require dates to be written in a certain format. For instance, formal letters require the date to be written in full with the day, month, followed by a comma and the year. With Writer's new update, you can now change the format of the merged date to suit your purpose.




Display past or future dates
The date field provides an easy way to display the current date, but what about when you want to display a past or future date?
For instance, if you're sending renewal reminders and the renewal date is 3 months from the subscription date, you can simply add "3" in the months option or add the number of days for the interval in the days field, and Writer will automatically calculate and enter the renewal date in the field. Similarly, you can do the same to enter dates that are even prior to the subscription date.
  


Rich text
The fields in your data source may carry links, or even have different styles. Merge fields in Writer are now enabled with rich text to retain the style and  format of the fields from your data source after merge.




Number and currency field formatting
Just like how you can change the format of date fields, you can also do the same with number and currency fields. Legal documents, for instance, require values to be presented in the correct decimal and currency format. In such cases, all you have to do is simply change the format of the merged values by using the number formatting option.




4. Other handy merge upgrades
We didn't just stop there. Here are three more upgrades we think will enhance the way you work with your documents pre- and post-merge.

Customize merge docs with sign settings
Create sign-ready, customized documents for specific clients that your colleagues can check, change a few things if needed, and then send for sign immediately with the configuration you've set for them. This gives you that final layer of review and confirmation before sending out a contract to clients.
 


Detailed merge reports
Now, stay on top of your merged emails by tracking when they have been viewed or read by your recipients and how they are interacting with your links.


Lastly, the automation panel gets a new look!
That's right. Based on what some of you told us, we've improved the automation panel by making it easier for you to access "Prepare" and "Run Merge" steps distinctly from the panel at any time.


That's all for now. Let us know what you think of these updates in the comments below.

Read the main announcement here.

Happy merging!

    • Sticky Posts

    • Easily perform calculations using dates with the new DATEDIF function

      Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

    • Date-based conditions and filters

      Configure conditions with date  Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the

    • Introducing group by, aggregation, and repeating regions in mail merge templates

      Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now

    • Say hello to an improved way to merge documents!

      Automating all your documents from start to finish is now easier than ever with Writer's new merge tools.   If you haven't seen it yet, you can read the main announcement here. Here is the full list of the features we've rolled out: 1. Dynamic Table Headers

    • Introducing Org Fonts in Zoho Writer

      Hey Zoho Writer users! We're excited to share that you can now add custom fonts (from web fonts with publicly accessible URLs) using Zoho Writer's Org Fonts. This option allows all users across your organization to use the custom font without the hassle

    • Recent Topics

    • Regarding GST Report Issue in Zoho Books

      Hi, Right now, the very important point from my end is this Zoho Books issue. Here, you can see that we have created the invoice with the items of account sales and expenses. The journal is also correct. The profit and Loss statement is also correct.

    • Default Ship To Address on Purchase Orders cannot be different than Organization Address

      Our organization address is not where we want shipments delivered, it is just a mailing address. We would like to change the Ship To address on our PO's so that by default it is our warehouse (not the mailing address). I understand that when creating

    • Function #57: Automatically group items in invoices based on categories

      Hello everyone, and welcome back to our series! As a business expands and new product lines are launched, it becomes important to organize the items for better inventory management. The Category field in Zoho Books helps here by allowing you to add and

    • Differences between Zoho Books and Zoho Billing

      Without a long drawn out process to compare these. If you were looking at these Books and Billing, what made you opt for one and not the other. Thanks

    • unable to import transactions into zoho books

      I download a csv with separate columns for deposit and withdraw. The sample has zero's in the blank spaces so I ensure mine does too. When I try to import it says the fields must have values greater than zero.

    • Zoho Forms Unable to Save Account Numbers with a Leading Zero

      We are using Zoho Forms to for rental applications. It is working well, except for one thing:  when a user enters their bank account information, and that account number actually starts with a ZERO (like 00123456) the Zoho form will return the value without

    • How to include GST% in PO amount?

      Currently when I raise PO, the basic price of the item is used. However, the GST is not calculated and added along with the basic amount. I have added a Custom field for GST in the PO but I need Zoho Inventory to calculate the GST amount and add it with the Basic price to give me the final PO price.

    • sitemap in zoho sites not updating

      I checked my sitemap and it has not added any updates. Do I have to generate one manually all the time or is zoho sites suppose to generate and update it?

    • I trying to connect our PM tool but API shows failure

      Hi All, in ZOHO CRM when an enquiry stage is moved to WON then I have created a rule to trigger POST URL to thrid party AP and then create a function for mapping with below code void automation.kytesfunctions(String enquiryId) { // Fetch enquiry details

    • Sample Ticket - Created from Bot Preview

      Why is Zoho desk adding bot created tickets?

    • Webhook data is not being received

      We’ve set up the webhook with a public URL that returns a 200 status on Postman. However, when we ran a test, we didn’t receive anything in the req.body object or see any data from the POST request. As a team of freshers still learning the ropes of development,

    • Number of Workflow runs

      Is there a way in Zoho desk to see statistics regarding workflows, rules and other automation objects? Would be nice for several reasons: You could ensure that your workflows are actually running. You could determine which ones weren't being used so you

    • Mail is no longer populating CRM contacts

      Hi! For the last few days, my mail hasn't been populating my CRM contacts. Even people I email multiple times per day. In fact, it keeps trying to send mail to myself. Notice, I started typing Amy and only got as far as, "Am" and it suggested myself.

    • Zoho Support is indeed shocking and difficult to get a response with

      All our business emails have an auto-foward set up on them so that they also go to our GMAIL accounts so that we receive them to the relevenat people. The emails are indeed auto forwarding and arriving to our GMAIL accounts but when you log into your

    • How to get a list of selected records into a button-function? Here is how!

      So, you might know already how to get a button on a page somewhere and perform actions with a function when pressed, but how about a button that only works with the records you selected in the list view? The button selected is a custom button in the modules

    • How to Add Break line / Return on button click

      I need to return the text concate with difference field from lead with line break i try "\r" ,"\n" "<br>" return "ali \r\n <br> baba"; None of above work.  i expected result something like this  ali baba but got this  ali \r\n <br> baba so, how can i

    • How to get batch number of item by api?

      Hi there, Is there any way to get batch number of item by api? Batch number is the batch reference number in https://www.zoho.com/inventory/help/advanced-inventory-tracking/batch-tracking.html . When I call the https://www.zoho.com/books/api/v3/#Items_Get_an_item

    • Announcing new features in Trident for Windows (v.1.18.6.0)

      Hello Community, Trident for Windows is here with some new features to elevate your workplace communication. Let's take a quick look at what's new. Ask and send read receipts for emails You can now request read receipts for specific emails while composing,

    • Dialing Microsoft Teams Phone Service via Zoho CRM

      I am using the VOIP option in Microsoft teams for my office phone system. I was hoping to have a way to dial numbers directly from Zoho CRM, but don't see anything in the Teams Integration or in the Telephony integration that will enable this. Does anyone

    • Increase subscription prices for existing subscriptions

      Hi, Does anyone know how we could achieve the ability to increase the subscription fee for our existing customers based on a % increase. We are not yet using Zoho Billing (Subscriptions) and I'm not sure if it is a good fit for us. But we would need to

    • Why developing custom function development made so difficult for Zoho Projects!!

      Hi Zoho Team, I am trying to write function to automate a process but whatever API name or Column Name I use, the API isn't populating certain fields. Even the standard fields aren't getting populated through API. It's already exhausting to find all API

    • Data not visible in sheet cells

      I'm having an issue where my data is not visible in my sheet cells. If I click on an individual cell, the data does display above in the little "fx" box. But all the boxes in the sheet just look blank. My collaborators do not have this issue. I have checked

    • Function #20: Custom calculation in item table of invoices

      When you create an invoice in Zoho Books, the 'Amount' of a line item is typically calculated as the product of the "Quantity" and the "Rate" of the item. For instance, if an item has a sales rate of $50 and a quantity of 5 is sold, then the amount would

    • PO receive limitations

      It is VERY common to receive more or less that the PO quantity. It's totally ludicrous to limit the maximum receive to the PO quantity! What if the receive is 0.00001 less than the PO quantity - it leaves the PO as "Partially received" The current options are to edit the PO manually before finalizing the receive, an outrageous situation ! Please Zoho guys - this is an infuriating oversight & can be easily resolved by introducing the option as shown in the attached document ......

    • Why don't we have better integration with Mercado Pago or Pagseguro?

      Currently, the integration between Zoho Commerce and Mercado Pago for Brazil is very poor... Since it is old, it does not include the main payment method in Brazil today, which is PIX. Is there a date for this to finally be launched? There are numerous

    • Why is there no integration with native Brazilian shipping methods?

      Zoho Commerce is a powerful platform for e-commerce, but its lack of integration with native Brazilian shipping solutions is a significant limitation for users in Brazil. Integrating with popular shipping providers like Correios, Frenet, and Kangu would

    • Alert for Back Navigation in Zoho Creator Widgets on Mobile Apps

      In Zoho Creator widgets, when a user navigates back on mobile devices, the data within the widget is reset. This leads to a loss of any unsaved changes or inputs, causing frustration for users. To enhance user experience, we need to implement a confirmation

    • Mapping Zoho Projects into Cliq Channels

      why arent all the Zoho Projects listed from the drop down menu when trying to Map them into Zoho Cliq Channels. The system doesnt allow me to type the name of the project but gives a drop down of a list of projects however it doesnt give me a list of

    • Input GST Reversal for damaged goods

      In our line of business, some items are damaged and we are doing inventory adjustments to remove them from stock. However, as per GST guidelines, there is a specific rule that we have to reverse Input GST availed for such items and needs to be reported

    • Develop and publish a Zoho Recruit extension on the marketplace

      Hi, I'd like to develop a new extension for Zoho Recruit. I've started to use Zoho Developers creating a Zoho CRM extension. But when I try to create a new extension here https://sigma.zoho.com/workspace/testtesttestest/apps/new I d'ont see the option of Zoho Recruit (only CRM, Desk, Projects...). I do see extensions for Zoho Recruit in the marketplace. How would I go about to create one if the option is not available in sigma ? Cheers, Rémi.

    • Canadian Anti Spam Law

      In order to be able to comply with the new Canadian Anti Spam Law, I need to send out a Confirm Subscription email to all of our existing contacts. If I use the Subscribe tag, the user gets the following message: Registration Failed. Sorry! This contact is already present in the selected list. You can check this with your update profile link. If I include an 'Update Profile' link, it then sends an email which does not arrive immediately. Can you provide a tag or URL I can put in a Campaign Email

    • How to bulk update lookup fields

      "I have a primary key named Product SKU in one form called Master SKU (which contains details like price, color, size, etc.). I also have another form called FBA, which has the same primary key, Product SKU, and contains stock quantity information for

    • Change work hours per day for employees

      Hello, Is there a way to modify the work hours per day for employees in Zoho projects? This would be helpful for resource allocation to more accurately see when an employee who works 35 hours a week vs 40 hours has a full schedule. Thanks.

    • Record GST Paid for Imported Goods

      In Australia, goods that imported from overseas needs to pay GST per invocied value. In most case, the freight forwader (logistic agent) paid this on behalf of importer (us), and invoice us in together in their freight invocie.  How do we setup a proper

    • Unable to produce monthly P&L reports for previous years

      My company just migrated to Books this year. We have 5+ years financial data and need to generate a monthly P&L for 2019 and a monthly P&L YTD for 2020. The latter is easy, but I'm VERY surprised to learn that default reports in Zoho Books cannot create

    • Bulk Editing Multiple Invoices with Overwriting at time of upload

      Hello, I would like to edit a few 100 invoices. Only the HSN needs to be updated. When I am trying to upload the excel sheet with the data updated, I get an error: The Invoices are skipped as they already exist. I know the invoices exist but I would only

    • Oauth Redirects me to sign in page

      I am developing a postman script for me to securely get my credentials via Zoho Vault. With that, I need to authorize my postman to be able to access Zoho Vault. I am currently on Step 1 in this Zoho Vault | API Reference which redirects me to this guide

    • Here's why you should refrain from using EasyShip

      This is a screen recording which shows EasyShip performance issues. Note well! While we do use the Zoho-to-Easyship integration, the problems are wholly on the EasyShip side. The actual integration of data to EasyShip, and status updates back to Inventory,

    • How can I create a billable expense.?

      Hi, I've a bill of an expenses related to printing and stationary account but it recorded in non-billable expense category. How can I record this expense in billable category. Below is the pathway I've used to record the expense. Purchases. Expenses Click

    • Introducing Sub-Accounts in Zoho Books!

      Hello Everyone, Sub-Accounts is LIVE! Yes, you read it right. The much needed and most requested feature is now live in Zoho Books. The sub-accounts feature in Zoho Books will help you to classify your accounts further which will give you a more detailed view of your accounts while running reports. You can create sub-accounts for the below Accounts: Asset Cost of Goods Sold Expense Liability Fixed Asset Other Asset Other Current Asset Long Term Liability Other Current Liability Other Liability Other

    • Next Page