Get variables from array

[Javier_Llofriu]

Hi, I would like to convert an array with several fields into multiple variables to map an invoice in a sheet line by line. So, for example, Array 1 would contain product, price, and taxes; Array 2 would contain the same fields, and so on.

And how can i filter by operations?

[JohnSultant]

Hey Javier,

welcome to the community! It’s been a few days – did you get any further with this? If I assume correctly, your Iterator module produces the bundles which in the output of the Airtable module are listed as Operations 1-4. You can filter for a specific Bundle from the Iterator which corresponds to the operation in Airtable (the Iterator always gives you a IMTLENGTH and IMTINDEX (Total number of bundles and bundle order position) which can be used for further filtering.

On a bigger picture, if dynamic document creation ist what you are after, maybe take a look on this post, I gave an outline on how I achieve this by using the “Text Aggregator” module and html snippets.

Creating a proposal (offer) doc/pdf file with a dynamic table of positions

Hi Janecki, you could do this with only free tools (google docs) but you need to be able to somewhat understand html. This is a quick sketch, let me know if you need a more detailed instruction. Create your template with google docs, including one row of the positions table save/export as html open with browser and view the source code find the table portion of the row you want to loop and copy it into a „text aggregator“ module map to the source module so it creates the looped rows section m…

[Javier_Llofriu]

I finally filtered by the order of the bundle from the iterator and created a multiple variable set, which then allowed me to integrate them into the template.