Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 16, 2022 07:46 AM
We’re getting right at the upper limits of our attachment file size (20GB for the pro plan). It’s not going to make sense to upgrade to Enterprise, and we have plenty of space left for more records (35K now, and we will be archiving old records before we hit that limit). We’ve used
Calculate Airtable Attachment File Sizes to figure out the biggest attachments and remove and archive them just as a stopgap until we systematically archive. My question is, when you have an attachment in one table, and look it up in another table, does that attachment count twice against your attachment size limit or only once?
Feb 16, 2022 01:25 PM
It should only count once. You may want to look into the available integrations with services like Google Drive or Dropbox – you could add and remove attachments using an automation, for example, to keep your attachment space usage in check.
Feb 16, 2022 04:25 PM
You can use my script to quickly evaluate size of all attachments in tables of all base. Lookups shouldn’t count, but when you remove some records and they still stored in history and available to restore, it still counts (script doesn’t add them).
const inMb=(bytes)=>(bytes?`${Math.round(bytes/Math.pow(1024,2))} Mb`:'');const ts=[];
for(var table of base.tables) ts.push(await count(table))
if (sum(ts)) {output.table(ts.filter(n=>n).map(x=>(x?{size:inMb(x.size),name:x.tname}:{})));
output.markdown(`**Total: **${inMb(sum(ts)?.size)}`)}
function sum(arr){return (!arr||!arr.length||!(arr.some(n=>n)))? null:
{size:arr.filter(n=>n).map(x=>x.size).reduce((x,y)=>x+y),tname:table.name}};
async function count(table){
let flds=table.fields.filter(fld=>fld.type.includes('Attach'));
let query=await table.selectRecordsAsync({fields:flds});
return sum(flds.flatMap(fl=>query.records.map(x=>x.getCellValue(fl)).map(sum)));}
Feb 20, 2022 09:01 AM
@Alexey_Gusev This script is great. Thank you for sharing. Previously I had to look in each table on the bottom of the page in the summary footer to see the total attachment size (it’s per field total only).