While I now understand it wasn’t my best idea, I have several hundred rows in a table and each row has a File column with 3 to 6 images uploaded. Beating my head up against the wall with how to rename them and then download without having to manually do it all. I will need to create a sample doc and provide but I’m urgently seeking help. In this process I’ve learned how to get the image URLs and came across the fantastic File Saver tool, even have an Apps Script but it’s not finding attachments or URLs to upload to Google Drive. Tips and suggestions much appreciated!
1 Like
hi @Kathy_Womack1 , it has been a while since we saw you here, welcome back!
a first step could be to distribute the files over rows as you can see below, from there you can get the names of the files 
a sample doc is the way forward, it takes minutes and spares volunteers like me the time to set up our own examples.
Cheers, Christiaan
2 Likes
HI, @Kathy_Womack1 .
I think the best way to achieve what you want is to use the Imgix API as it hosts all Coda’s images.
You can do a lot of magic with it including renaming and resizing.
As @Christiaan_Huizer have said, it’s a good idea to distribute the files over the rows in a new table. The idea is to have one URL for each roll and a column for the new file name.
Then you apply the formula bellow to get a new Url:
thisRow.URL.Substitute(“``https://codahosted.io/docs/","https://codaio.imgix.net/docs/”
).Concatenate(“?w=1200&h=1200&dl=”).Concatenate(thisRow.[File name])
In order to download the images in a batch, I use a freeware Windows app called Uget
GitHub - ugetdm/uget-windows-installer: uGet Installer for Windows.
**
ps. I forgot to mention. In order to get the public codahosted url, you have to use some black magic with hidden formula:
thisRow.Image._merge().ToText().ParseJSON(“$.publicUrl”)**
3 Likes
Thank you so much! Here is a link to my sample doc: Login - Coda
1 Like
Thank you so much! I posted a link to my sample doc and am digging into the recommendations from both of you now.
2 Likes
@Kathy_Womack1, I created a mock doc for you 
See it if it serves your needs
2 Likes
This is awesome, thank you so much! I probably should have mentioned that I’m using a Mac. Going to try and get this going in Parallels, presuming that’s best?
1 Like
Also curious if there’s a way to pull back the renamed image?
1 Like
Actually, you’re not renaming the images in the server.
You’re just informing, in the url, the name of file to be saved when downloaded.
1 Like
I think any app that does batch downloads given a list of URL will do the job.
2 Likes
I just wanted to send a huge thank you to @Christiaan_Huizer, @Breno_Nunes, and @Felipe_Arnhold for your willingness to help and offer guidance! It’s due to your efforts that I’m there with a solution to get the images out of my document and NEVER do this again. LOL
After working with all of your ideas, I was able to put my panic away and think through more clearly as well. I now have multiple images in a single column that are being “split” to a new table with a new naming convention plus a Google Apps Script that uploads them to Google Drive and puts the drive link into my table.
Thank you, thank you, thank you!!!
4 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.