Hi,
I did such thing, With automation and with script. Airtable supports uploading 1000 attachments at a time, so I had to create uploader with several rows.
please describe your upload process. you have a folder of files with each named by client or client ID and you need to batch upload such folder from time to time? how much files and how often?
do you have enough automation runs if each file will be loaded with 1 automation run?
I don't think Find Records limit (100 recs) matters in your case unless you are going to update more than 100 records with the same file.
Hi,
I did such thing, With automation and with script. Airtable supports uploading 1000 attachments at a time, so I had to create uploader with several rows.
please describe your upload process. you have a folder of files with each named by client or client ID and you need to batch upload such folder from time to time? how much files and how often?
do you have enough automation runs if each file will be loaded with 1 automation run?
I don't think Find Records limit (100 recs) matters in your case unless you are going to update more than 100 records with the same file.
Hi @Alexey_Gusev ,
My process is as follows:
I have two attachments - one price list, and one update list - that must be attached to all records in my database. These files are all the same for all clients.
So, when for example, the price list is changed, I must delete the old price list from all records in the database, and replace it with the new price list - the same file for all records.
Our database has close to a thousand records.
You should use Linked records in such case, and nothing more. And that's really easy.
Create a new table for attachments, with one record and four fields,
Primary - single text (type anything there, like 'Images', or 'lists') , other two - attachments, price list & update list. fourth will be linking field. Click in linked field and link to first record.
Now switch to the table with 1000 records, find linked field (unhide if needed) and select cell with link 'images'. Copy cell, select whole field and paste. It tooks a few seconds. Now right click on linked field header, choose 'add lookup fields' and add both image fields.
That's all.
p.s. You can join then in a single cell, if needed.
also you can turn primary cell from single text 'Images' to formula with LAST_MODIFIED_TIME() or whatever, so it will be shown on links. but I would just hide linked field.
When adding new records you should provide that link will be copied there as well.
You should use Linked records in such case, and nothing more. And that's really easy.
Create a new table for attachments, with one record and four fields,
Primary - single text (type anything there, like 'Images', or 'lists') , other two - attachments, price list & update list. fourth will be linking field. Click in linked field and link to first record.
Now switch to the table with 1000 records, find linked field (unhide if needed) and select cell with link 'images'. Copy cell, select whole field and paste. It tooks a few seconds. Now right click on linked field header, choose 'add lookup fields' and add both image fields.
That's all.
p.s. You can join then in a single cell, if needed.
also you can turn primary cell from single text 'Images' to formula with LAST_MODIFIED_TIME() or whatever, so it will be shown on links. but I would just hide linked field.
When adding new records you should provide that link will be copied there as well.
Thanks so much! That worked 🙂
