Merge Subforms data into repeated text a set number of times

Merge Subforms data into repeated text a set number of times

Hi

I am using Forms to input data and then merge data from a subform into what I would like to be dynamically repeating blocks of text into Zoho Writer (and will also add to the CRM).

The block of text to be dynamically repeated has several instances of placeholder text that should be replaced by some of the information from the subform. 

I have my form how I need it so don't want to make changes at this stage.

The issues I am facing are:

  1. The base of block of text is standardised and simply needs to be repeated according to how many entries there are in the subform
  2. The placeholder text needs to be replaced by some of the information in the subform, but by using merge I can only get this to function by adding every instance in the subform. 
  3. I can't use a table to display any information as it must be readable as sentences on the final documents
I have figured out a way to get these blocks of texts into the document, by using IF AND statements but this will be very long-winded to setup and will mean I will also have to alter the form to collect the data as individual inputs instead of via a subform, and show/hide according to how many are required, adding further questions to the form and what seems like unecessary complexity. 

I also have other blocks of text to be used with other debt types, e.g. loans, overdrafts, etc. but happy to simply add additional IF AND statements for those types. 

Can anyone think of a way I can have a block text repeat dynamically according to how many data rows are in the particular subform, and also allow me to include the individual data points from the subform into the repeating text?



      • Sticky Posts

      • Deprecation of certain URL patterns for published Zoho Writer documents

        Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their

      • [Announcement] Insert image from URL changes in Zoho Writer

        Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from

      • Introducing plagiarism checker in Zoho Writer

        Zia, Zoho Writer's AI-driven writing assistant, now highlights plagiarized and duplicated content in addition to offering contextual grammar and writing suggestions to help you write clearly and concisely in English. Zoho Writer's plagiarism reports Here

      • [Important announcement] Impact of Google's new email guidelines for Zoho Writer automation users

        Hi users, Google has recently announced new guidelines for sending emails to Gmail and other Google-hosted domains. These guidelines will be effective starting Feb. 1, 2024, and can impact the delivery of emails sent from Zoho Writer. Your organization

      • Transitioning from MS Word to Writer: A complete walkthrough

        Hello everyone! We understand moving to a new word processing tool can be difficult, especially if it means switching from a legacy software like MS Word. That's why we've organized an exclusive webinar where we talk you through ways to make your switch from MS Word to Writer as easy as possible. In this webinar, you'll learn: - Why Writer is a simple yet powerful alternative to MS Word. - How to locate your favorite MS Word features and functions in Writer.  - How to migrate your Word documents