Hi,
I am trying to set up a scenario that will read (up to 50) records (each record has 15 fields) from an airtable base, batch the records into groups of 4 and write the information to a new Microsoft word document based on a Microsoft word template. When all the records have been processed the individual documents should be merged into a single document.
I am struggling to work out the modules/logic I need to achieve this.
The attached blueprint shows my approach so far - get the template, get the records, iterate (ideally in batches of 4), aggregate all the fields (60) write the new document, save to onedrive. I have ignored the requirement to merge the documents for now.
The aggregator is needed to aggregate the 4 records (x 15 fields = 60 fields) into 1 “block” to be written to the new document.
My problem is twofold:
- Even though the iterator is working as expected I cannot work out how to get the iterator output aggregated before the write operation.
- How do I set a limit of 4 records to be processed.
I’m sure I’m missing something simple here?
Any pointers will be greatly appreciated!
Thanks,
Tony
dddd.blueprint.json (36.9 KB)