Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiple text files with fileAsync

Topic Labels: Scripting extentions
501 1
Showing results for 
Search instead for 
Did you mean: 

Pretty new to Airtable and Javascript
I’m trying out Airtable to see if I can organize my organizations data better.

When importing new data to our database I would like to read from many text files, collect the data from the files (which unfortunately isn’t organized too great), and insert the data into tables.

Is there a way to queue multiple text files to read with fileAsync? There are hundreds of files, so doing one at a time is not useful.

1 Reply 1

The docs only describe a function to “import a file”, input.fileAsync:

Have you considered concatenating your files into a single file and uploading the result?

Alternatively, if you’re more comfortable with other programming languages or tools, you could reformat that one large file into CSV, and then import that into your Airtable Base directly (i.e. without the use of the Scripting Block).