Just a quick question about adding each row of the API data into the Excel doc…
As far as I can see, I would actually need to create a collection of the API data, then set a timer or counter to go through each record of that collection, and add that specific row. (It’d be nice if I could increment the record without creating a visible collection, but it doesn’t appear that I can automatically increment or manipulate the record numbers shown when binding to the API. For example, when using the Add Row, and binding to my Airtable API items, I can see that I’m viewing the first of 11 records, but I can’t automate the ability to go to the next record and add that row)
Also along these lines, there doesn’t appear to be any way to grab the total number of records from the API or the collection it feeds into. It’s not super necessary, but it could be useful.
I’ll keep working at it, but I was curious if there may be a different or easier way than I’m approaching this method.
**Update: I’m not sure this is actually possible anymore without the ability specify the record number to be updated from within the API data.
The only way I can see to sequentially update each item from API data into each row of excel is to create a button inside the API Data’s collection itself. The button inside the collection has an awareness of which record it is on, and therefore can add it’s own record data into a new row of excel. However, buttons inside collections cannot be triggered or manipulated, so there doesn’t appear to be any way to ‘automate’ this.