Thumbnail URLs change

[beeurd]

My website has several custom databases using Pages, and for organisational purposes I need one to have a list of links that goes through to another database.

In one database I have a field that has the URL to the other database entry's thumbnail image.

However, I have hit a snag where the thumbnail URL changes every time the database entry is edited, meaning I need to update both databases anyway so it doesn't save me the time that organising it this way would have in the first place.

 

Two questions:

1. Is it intended behaviour for the thumbnail URL to change every time an item is edited?
2. Is there a better way to do this? 

 

For reference, in case it explains why I am doing this better, these are the two databases in question:

1. Star Wars Timeline, with categories for Canon, Legends, and chronological subcategories:  https://www.galacticbasic.net/star-wars-timeline/
2. Star Wars Media Database, categorised by media type (book, movie, etc.) : https://www.galacticbasic.net/star-wars-database/

[opentype]

12 minutes ago, beeurd said:

 

1. Is it intended behaviour for the thumbnail URL to change every time an item is edited?

I don’t think so. The files are generated during upload and then it should stay untouched. 

I am also not sure why you would manually store the URL elsewhere. 

 

[beeurd]

15 minutes ago, opentype said:

I don’t think so. The files are generated during upload and then it should stay untouched. 

I am also not sure why you would manually store the URL elsewhere. 

 

 

Well, I couldn't find a way to automatically pull the thumbnail from a database while viewing the list of records for a different database. ?

I'm sure it should be possible, I'm just not fluent enough to get it working. The issue only comes up because the two databases have different category structures.

[Mack_au]

I know the regular filenames don't change, I have a database that is regularly edited, that is also used to create a forum thread.

Instead of thumbnails, could you instead use HTML to show a smaller version of the regular file? eg:

<img src="smiley.gif" alt="Smiley face" height="42" width="42">

Although this would assume you are using the same aspect ratio for all your images. So that might not work. But you might be able to code it individually per database entry.

An alternative would be for the person who creates the database, to stop using URL's and instead upload it's own specific version of the image to separate the two databases entirely (so you aren't linking URL's from another database). At least in that case, when you make the "thumbnail" you can just upload an edited version of the image with the appropriate sizing.