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 ...
What does it mean “Synced tables update method”?
For example, if my main table is in “PRO WORKSPACE” and synced table in “FREE WORKSPACE”, will my synced table updated automatically?
In contrast, if my main table is in “FREE WORKSPACE” and synced tab...
Let’s say that there are 2 customers: A and HA.
I have this “customer” field as a linked field to a text field on another “CUSTOMER” table (one to one - each item belongs to 1 customer only).
To filter out items for customer “HA” is fine with conditi...
I have two table:
InvoiceProduct
Is there any way to create a form where user can enter Customer, date (INVOICE table) and choose one or many Products for this invoice?
Hi Patrice,
Nothing special at all, mostly concatenation. This is mine:
'{"item_code":"'&{Mã hàng}&'","image":"'&{Image URL (first)}&'","description":"'&{Mô tả (from Mã hàng)}&'","size":"'&{Kích thước}&'","quantity-ctn":"'&ROUND({SL (KIỆN)},2)&'","qu...
Hi Patrice,
I do not know your exact requirement but the idea is to populate JSON String for each “row” of Word table:
Then, use a Rollup field type in the tables which these rows are linked to:
This value will then be used as the input for Parse J...
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"
},
...
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
