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:
- The base of block of text is standardised and simply needs to be repeated according to how many entries there are in the subform
- 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.
- 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?