Newbie: Need help to add URL path in front of ImagePath script
I'm completely new to FM and am trying to figure out how to add some static information in front of the results of the script below.
The script calculates the name of an image in a container field. I need to add a path in front of the resulting text like "graphics/product_images/". (The path is used for the website i'm exporting the database records to.)
So if the file name of the image in the container field was KD33.jpg, the resulting information in the calculated filed would be "graphics/product_images/KD33.jpg".
Can anyone help me figure out how to add this into the script below?
// Transform the contents of a container field named Images into text
ImageRef = GetAsText ( Images);
FileName = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/"))
Middle ( ImageRef; FileName + 1; Length ( ImageRef) - FileName)