Input doesn't appear in output after every troubleshooting step I can think of - Microsoft Word Template

What are you trying to achieve?

I want to aggregate all completed tasks from Airtable into an annual Word report.

I’ve already used this module successfully in the past. This time, I needed to involve a higher level of formatting and heirarchical structure, so I’ve tried a bunch of different combinations to try to get the desired output. For this iteration, I’ve rolled up all of the results with markdown formatting in Airtable, and I’m trying to input a huge wall of text as one variable. (I’m aware that the module reads it as a single line and will remove all line breaks… I’ll tackle that later I guess.) Even though every module’s input/output is working exactly as expected, including the Microsoft Word Template one, the actual downloaded document is only including some variables. The date fields land in my document, but my text field doesn’t. The Airtable module sends the text field only to a Markdown to HTML converter, which sends to the Text Parser module (to try to get rich text formatting).

Steps taken so far

  1. I thought it might be that I was pulling data from two different modules, even though that’s worked in the past, so I used an array aggregator. No change.
  2. This was the longest text field I’ve tried to pass by far, so I made a new text field that was only a few words. I passed it through the same Markdown > HTML > Rich Text flow. No change.
  3. I thought it might be the Markdown > HTML > Rich Text part, since that was also new to this scenario. I tried the short text field being sent directly to the array aggregator and Word module. No change.
  4. I tried changing the names of the variables in the template, just to kind of force a refresh. No change.

Throughout, the Word module has shown the proper values, it just didn’t show up. Is it possible it’s related to needing the refresh various things in various orders? I’m sure it’s just because it’s new, but I truly cannot understand when/how to update modules or the scenario. Half the time I’m struggling with something, I realize one module is displaying old values or sending something from previous attempts. Insanely frustrating.

Screenshots show what I’m seeing. Note that the “progress section” inputs/outputs show the right thing, they’re just too long for screenshots if I open them.

Screenshots: scenario setup, module configuration, errors





For anyone who’s reading this because they’re looking for help with the Microsoft Word Template in the future: consider saving yourself the trouble and using the Google Docs template options instead. Word’s is better in two ways:

  1. Your template can be a Word document, which might work better for clients.
  2. It has a built-in loop type for variables.

But if you needed nesting loop types, it won’t work. If you want to have multiple lines of text as one input, it won’t work. It doesn’t connect to anything else and has no extra flexibility.

The Google Docs modules allow you to use HTML (or markdown converted to HTML), multiple lines (so I would suggest aggregating your loop outputs in Airtable or something first, and passing the whole thing at once as one variable), and you can download it at the end as a .docx file anyway.

1 Like