I have an excel sheet with the following fields-

 

Product Name (ABC123)

Image View (Front)

Image location (x:myimages/photo1.jpg)

New Name

 

How would I go about asking file maker to

1. Retrieve the image from its current location

2. Rename the image using the Product Name and Image View (ABC123 Front.jpg)

3. Save the image in a new location (example C:/NewImage/)

4. Record the new image name.

 

Could you advise me of the scripts and functions I would have to study to learn to do something like this?

Thanks for any help in advance.

 

 

 

 

One thing to keep in mind is that FileMaker cannot rename a file on import. Although it can on export. So you would import from the current location into a container field and export with the new name to the new location. But in order for the file within the database to have the new name you would then need to reimport the newly named file.