I have a scenario where a record is created in one Airtable database based on data from another Airtable database. During this process, a file from Field 1 in Airtable 1 is also transferred to Airtable 2.
The current process is functioning effectively: I retrieve the file using the HTTP Get module, upload it to Google Drive, and then utilize a webhook to bypass the Google Drive quota limitations with a brief scenario. This method works seamlessly.
However, in field 2 of Airtable 1, I have multiple files. To successfully add all these files into Airtable 2, I need a way to process all file links from field 1 (a collection of files). The goal is to generate a separate URL for each file, then concatenate all these links into a single string with plain URLs separated by commas, as suggested by a solution I found on the Airtable community page.
I often find working with arrays and collections challenging. How can I replicate the process that works perfectly for a single file to handle the collection of URLs in Airtable 1, and concatenate them so that I can add multiple files to Airtable 2?