Insert Picture based on text field

[SimonK]

I'm trying to write a script which inserts a picture into a container field based on the text in another field. Not having any luck with either the Insert Picture command or the Set Field command.

 

Any help?

[FileMakin' Tom]

Place your pictures in a global repeating container. Then create a container calc:

 

Case[FieldA = "Ishkabibble",

GetRepetition[Container,1],

 

FieldA = "Frumbubble",

GetRepetition[Container,2],

 

etc. etc. etc.

 

Tom

[-Queue-]

Note: GetRepetition( field, 1 ) = field, when the calculation is non-repeating.

[SimonK]

Thanks for the help. I don't yet understand all of the abilities of global repeating containers, didn't even realise you could have a container calculation.

 

But what I'm after is:

 

Retrieve the ImageName

 

FieldImageName = "123_4AB.jpg"

 

Insert picture file 123_4AB.jpg into the ImageContainer field for that record.

 

Then I will just create a loop to work through all the records in the database.

 

There are over 5,000 records in the database.

 

Thanks again for the answers...