Hey Kurt,
for sure I can. In terms of steps, what I did was:
- create a field “picture already resized?” with a checker box
- create an automation than run on schedule. To start with, run it every 15 minutes. I was able to compress about 5000 records with images in one night.
- find all record with images and for which “pictures already resized?” is false
- create a loop for the records found (at first, you will have 100 records everytime, and your automation will fail due to the time it takes), but don’t worry, it’s only because AirTable limits the overall automation run to 5 minutes I believe.
- for each record, create a script that:
- retrieve the record field(s) where you have your pictures. For each field, create an empty future attachment object.
For each attachment in your field, check if it’s a picture, and if yes, take the attachment.large file and add it to your created object. Otherwise, just re add the normal attachment if it’s a pdf etc (note that you could use some external API otherwise to compress this kind of files potentially).
once the object is ready, update your attachment field with it.
if successful, update the picture resized? field to true.
With this, I was able to go from 12Gb to 3.5Gb on my base. And now, I let this script run once every 3 days so it does not cost much in terms of automation per month.
I’m pretty sure this will be enough details to get your script done with chat gpt 😉 but if ever, feel free to reach out again, happy to help. And congratulations for your future boy! 😃
