Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Nov 20, 2020 03:39 PM
Hi there!
I was wondering if it possible to have a form that allows the user to attach a file (csv or xlsx) then using automation, take that attachment and populate the matching columns - as well as do any update.
Basically would be the CSV Importer but instead of dropping a file, it would consider the values from the attachment.
There is Spreadsheet importer: Airtable Scripting but not sure how to make it work.
Thanks!
Nov 25, 2020 01:37 PM
As far as I am aware, there is no direct way to read the contents of an attachment using an automation. I looked into this once and gave up on the idea.
However, this may in theory be possible. Perhaps someone else on the forums has done this already and can provide more details? This method would require the use of an external service to read the file contents and return it back to you in a format that you can use (JSON perhaps). Here’s the concept:
Caveat: assuming this works, you would need to be mindful of time limits on automations. The service would need to send the data back to you quickly so that you don’t hit the 30 second max execution time.