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?




                        Zoho Marketing Automation
                                • Sticky Posts

                                • 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
                                • Writer Designer's Update 2018: What's Changed with Page Settings

                                  Hey there, Writers! =] As a part of the Writer Designer's Update 2018, here's everything new and improved with Tables in Writer: 1. Customizable horizontal lines  While horizontal lines act as separators for different sections in a document, they also make your document more visually appealing and easier to read. Keeping that in mind, we've now added some handy customization options for horizontal lines in the form of line weight, color, pattern, and alignment. 2. Beautiful page borders Give your
                                • Zoho Clipboard App has been discontinued

                                  Hello there! Thanks to everyone who wrote to us. We could see you had trouble installing, and using both Zoho Writer and Zoho Clipboard Apps at the same time via Chrome Web Store. To avoid this conflict, we have decided to, as you've already guessed, discontinue the App, and bundle it with the Zoho Writer App itself. Chrome users will only need the Zoho Writer App now to enable Copy and Paste on right click. Here's the how to remove the Clipboard App: 1. Go to your Chrome Apps page by clicking on
                                • First Look: The New and Improved Zoho Writer

                                  Preview the all-new Zoho Writer to see our cleaner, more stylish, and more intuitive interface. Click the Try New Version link on top of your Writer window and switch to a better experience.  Here's all that's new: Revamped UI With a brand new look, comes a whole new approach – introducing modes, a simpler way to write. The Compose mode gives you a space to write without distractions. Switch to the Review mode when it's time to add other people to the equation, and get feedback from your peers. When


                                Manage your brands on social media



                                        Zoho TeamInbox Resources

                                          Zoho DataPrep Resources



                                            Zoho CRM Plus Resources

                                              Zoho Books Resources


                                                Zoho Subscriptions Resources

                                                  Zoho Desk Resources

                                                    Zoho Projects Resources


                                                      Zoho Sprints Resources


                                                        Qntrl Resources


                                                          Zoho Creator Resources


                                                            Zoho WorkDrive Resources



                                                              Zoho Campaigns Resources

                                                                Zoho CRM Resources

                                                                • CRM Community Learning Series

                                                                  CRM Community Learning Series


                                                                • Tips

                                                                  Tips

                                                                • Functions

                                                                  Functions

                                                                • Meetups

                                                                  Meetups

                                                                • Kbase

                                                                  Kbase

                                                                • Resources

                                                                  Resources

                                                                • Digest

                                                                  Digest

                                                                • CRM Marketplace

                                                                  CRM Marketplace

                                                                • MVP Corner

                                                                  MVP Corner

                                                                • Word of the Day

                                                                  Word of the Day


                                                                      Design. Discuss. Deliver.

                                                                      Create visually engaging stories with Zoho Show.

                                                                      Get Started Now