Solved: Image - Filename - Page 2

DaveWillett · 11-26-2024 02:46 AM

Hi all

I have an image table containing guess what, images. We are all aware the filename is set by Google for each image, I need to be able to rename an image in a sequential format. I have the sequence working in the following format: 12345-1.jpg, 12345-2.jpg....-3.jpg and so forth. The [12345] is taken from a [JobID] and the sequence is worked out using a counter column: MAX(SELECT(Images[Counter], [JobID] = [_THISROW].[JobID])) + 1

However, I can not see a 'filename' property which could take a concatenation to combine everything. The questio is , is there a filename property or setting to allow me to rename the image?

Many Thanks

DaveWillett

It seems I had the answer all along close by.

I changed my ID column from UNIQUEID() to CONCATENATE([JobID] ,"-", [Counter]+1) which resides in the INITIAL VALUE setting, problem solved, my images are now created with [JobID] [Image1] [Timestamp] which I can now use the image in my VB6 project.

View solution in original post