makingtrails Posted July 1, 2014 Posted July 1, 2014 Hey Guys, I'm new to the forum and also pretty new to Filemaker 13 so please be nice! I am using Filemaker to help manage my inventory of a website (ecommerce) but finding it hard to find details on using an external image server (aka image directory of website) So far I can managed to get the images to display from my external server (images.website.com/image1.jpg) using the Web Viewer and also managed to removed the borders and fix the scaling by adding in HTML code into a field called ImageCode data:text/html, <html> <body> <img src='images.website.com/image1.jpg' style='width:100%; height:100%'/> </body> </html> Now I would like to link the field content of Product::Image1 (this is where my url is located) to replace "images.website.com/image1.jpg" link which I manually entered into the ImageCode field. Can anyone advise the best way to do this? or if there is a guide for designing filemaker db's for use with external image servers. Thanks J
greerso Posted July 1, 2014 Posted July 1, 2014 I think what you want to do is make ImageCode a calc field where the calc is: "data:text/html, <html> <body> <img src='" & Product::Image1 & "' style='width:100%; height:100%'/> </body> </html>" If Product::Image1 is a full url including "http://" this calc will not work. That field would need to contain "images.website.com/image1.jpg" without the quotes for it to work.
makingtrails Posted July 1, 2014 Author Posted July 1, 2014 Thanks Man. That has worked! although I did have to amend my Product::Image1 fields to include http:// infront of the images.website.image1.jpg like you said but that was easily done! I'm very much beginning to like FileMaker! Thank you for your help
greerso Posted July 1, 2014 Posted July 1, 2014 You can have your calc remove the http:// using any one of the many text functions. Here are some simple examples: Right ( Product::Image1 ; Count ( Product::Image1 ) - 7 ) That counts the number of characters in the field, then displays all but the first 7. That wouldn't catch https:// and if it didn't contain a http:// it would remove the first 7 when you dont want it to. Substitute ( Product::Image1 ; "http://" ; "" ) Looks for "http://" and if found replaces it with nothing.
Recommended Posts
This topic is 4071 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now