- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 30, 2022 04:45 PM
I am trying to generate an Invoice for line items in Airtable. New Google docs creation automation is very helpful but it lacks basic formatting functions.
So, I use Microsoft Word module in Make but do not know what format I should use in this “Raw values” field. Could anyone please give me an example?
I know this is not really a Airtable question but documentation on this module is quite limited.
My Word templates :
{{invoice_number}}-{{invoice_date}}
{{buyer}}
{{#details}} {{item_code}} {{item_description}} {{unit_price}} {{/details}}
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 30, 2022 05:03 PM
Yeah, Make.com has some of the worst help documentation that I’ve ever seen, and their support is slow.
I don’t know if anybody here will be able to answer your question since I haven’t heard of anybody in these forums using Make with Microsoft Word, so I would recommend opening up a support ticket with Make and reporting back here with whatever they say. That will help future people solve this same problem.
Alternatively:
- Make.com also works with Google Docs, which might be easier to figure out.
- On2Air: Actions works with Google Docs, and has great documentation and support.
- If you only need to generate PDF files instead of Word files, you may want to explore DocuMint, which has a fantastic document template builder and also has great documentation and support.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 31, 2022 05:50 AM
Thank you Scott,
I will submit a support ticket as you suggested. It seems that Microsoft Word is rarely used in the automation workflows
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 03, 2022 08:49 AM
Hi Trung,
I was too looking for more information on the Word module for Make just to see if I can achieve more than today.
When I started in July I found it very undocumented. I managed to find the right information from a Youtube tutorial. It is with Excel not Airtable, but it gives good stuff on the Word module.
I finally added a pdf.co module after the Word module to convert word in PDF.
https://youtu.be/AkV1MDUKrQA
I hope this helps although it’s been some time from your initial question.
Christophe
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 07, 2022 05:39 AM
Thank you, Christophe!
The video is really helpful. I learned something new from it. I managed to solve the problem. It took a senior technician from Make to make it work
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 07, 2022 05:41 AM
Please post a screenshot of how you solved this, so future people can learn how to do this.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 07, 2022 06:44 AM
This is similar to the example of Make’s documentation:
My scenario:
Word module setup:
And this is JSON string:
{
"values": [{
"key": "name",
"value": "Trung Nguyen",
"valueType": "value"
},
{
"key": "contact",
"value":[{
"entry": [
{
"key": "supplier_name",
"value": "Test",
"valueType": "value"
},
{
"key": "email",
"value": "test@gmail.com",
"valueType": "value"
},
{
"key": "phone",
"value": "0123456789",
"valueType": "value"
}
]},
{"entry": [
{
"key": "supplier_name",
"value": "Another Test",
"valueType": "value"
},
{
"key": "email",
"value": "another@gmail.com",
"valueType": "value"
},
{
"key": "phone",
"value": "9876543210",
"valueType": "value"
}
]}
],
"valueType": "loop-section"
}
]
}
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 07, 2022 07:08 AM
This is fantastic information, @Trung_Nguyen!! :grinning_face_with_big_eyes: :raised_hands:
Thank you so much for posting all of this! This will be invaluable information to help many people in the future!! :blush: :sparkles:
I haven’t yet used the Microsoft Word modules in Make, so this might help me in the future as well! :slightly_smiling_face:
p.s. If anybody signs up for Make & Microsoft Word, please consider clicking on my referral links below to help reward me for my time volunteering in these forums:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 07, 2022 07:17 AM
Hi Trung,
I am happy to help :blush:
In fact I got into sending a ticket about the Word module some days ago. Indeed the support is quite basic. Well, as I am still in a free plan, I cannot really complain.
Yet, no one explained clearly the functioning (and the UI programming) of the Condition choice.
Anyhow. Keep well.
Christophe
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2022 07:01 AM
Hello,
I wonder what you give to the “parse json” module as input?
Thanks for your feedback.
P.S.: I try to reproduce the same use case, and I get stuck. My scenario, does not give me a table but as many files as rows…