Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Can't see my conatiner field


dino
 Share

Recommended Posts

Hi,

 

Maybe I'm missing something basic here but i have made a container field and have placed it onto my layout with the Insert>Field command. But I can't see the field when i return to Browse Mode so naturally I can't use the Insert Picture command.

 

What am I doing wrong?

 

Thanks

Dino

Link to comment
Share on other sites

you'll need to turn borders on for the field. In layout mode, right click the field and choose field/control-> borders, and ensure top/left/bottom/right borders are on. Now with that on you can give the field some line width & colour to be able to see it.

 

Also , if that does not work, ensure the field can be entered in browse mode. Again field/control -> Behaviour , ensure browse mode is ticked.

Link to comment
Share on other sites

Thanks! That did it.

 

This is my way of trying to get around FileMaker's non-support of BLOBs with external datasources, in my case MySQL. I assume that's the case with FMP 10?

 

I have subject images as low res previews as a blob in a MySQL table and would dearly love to access those but can't. So I have to think of another way...

 

I have the path to the image and the image filename so I'm hoping to be able to utilize that to go to the server and pick up the original image. I'm thinking I can make use of scripts for that. Any ideas?

Link to comment
Share on other sites

If you have the path to the image, you do not NEED a script. Or at least you do not need a script unless you intend on importing the image itself (as opposed to merely displaying it) into the database. You can DEFINE a calculation field of result type = "container" with the field def being "imagemac://" or "imagewin://" plus the path.

Link to comment
Share on other sites

  • 2 weeks later...

Just a followup question on this...

 

If I have a container field as described above I can certainly enter an image path and name as a full UNC network path eg imagewin://sideshow/SchoolImages/Mater-Cristi/100.jpg

 

But I need to have a different path and image for each record because each record has a different photo. How can I do that? I know the path and image number because they are in a text field but I need the imagewin: formula to change for each record

 

Thanks heaps

Link to comment
Share on other sites

pretty much in the same way AHunter described above, calculation, result type of container, and the container is set to a calculated path.

 

"imagewin://" & PathField & FileName

 

Something like that……

Link to comment
Share on other sites

Yes I did that and I get one image in and it's the same for each record. I need each record's image to be different though.

 

Basically I have a subject's table and in there is a field with the imagepath and filename which I can concatenate into one field - no problem there. But each record has a different path/filename so how I do I get that dynamic path into the one calculation?

 

Sorry if I'm sounding thick!!!

Link to comment
Share on other sites

PathField and FileName are two FileMaker Pro fields. They should have values that are different in each record, reflecting the path and the filename that are appropriate to that record. The calculation field is therefore also going to end up being different for each record.

Link to comment
Share on other sites

Guys,

 

Thanks to you both for your help. I really appreciate it. I have it working now thanks to you.

 

If only Filemaker Pro supported BLOBS this would be so much easier!

 

Dino

Link to comment
Share on other sites

They've come a long way very fast in supporting SQL data sources as equal partners (after, admittedly, years of languishing away with FileMaker-4 / FileMaker-5 calibre functionality); maybe 10.1 or 10.5 will support BLOBs.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use