Scripts like these need to be customized to the base and CSV files that they need to work with. I no longer offer custom scripting services, although that might change in the future.
Yes, this is possible with scripting. You can run an automation script when the form is submitted. I have written scripts that do this. However, this is not a script for a beginner to write. Here are some reasons why:
The script will need to get and parse the CSV file. There are multiple flavors of CSV, and parsing particular versions can be very tricky, especially if there are field values that can contain commas, quotes, or multiple lines. Scripting does not allow the use of libraries, so you cannot use a library to parse the CSV.
There is usually a slight delay before an attachment is fully uploaded, the automation script may need a slight delay before it does a fresh read of the record to get the attachment url.
Obtaining attachment urls is going to change in November. Full details on how the changes impact scripting have not yet been released. Depending on the changes, you may need to update the script then.
You may need to do data type conversions from the text in the CSV to the field write format.
This may also be possible without scripting using 3rd party integration tools. Perhaps one of the experts in those tools will chime in.
Scripts like these need to be customized to the base and CSV files that they need to work with. I no longer offer custom scripting services, although that might change in the future.
Yes, @MaryHartberg, for a no-code way of doing this, you could use an automation tool like Make’s CSV Parser tool:
You may also want to consider other ways of collecting the data. For example, JotForm offers a built-in spreadsheet widget that enables people to enter rows of data (up to a maximum number of rows that is prespecified). Then, that data can be sent to Airtable afterwards — either directly to Airtable or by using an automation tool like Make.com.
@MaryHartberg If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website:
