auto enter picture in container field possible?

[curious99]

Hi,

I use a plugin from newmillenium to export pictures. The one problem I am having is that when a record has an empty container field, it gets filled in with another record's picture. I wrote to newmillenium about it and I am awaiting an answer. That prompted me to want to put a default image in my field that says "picture not available yet". Is there a way to auto enter that?

Thanks in advance

Luc

[transpower]

Case ( IsEmpty (container_field ) ; picture_not_available.jpg ) (auto-enter calculation with result container). (I'm on 7, not 6, so cannot test, but should work.) The file picture_not_available.jpg should contain your default picture.

[curious99]

Hi Transpower,

Thanks for the prompt feedback.

If I understant correctly, the file "picture_not_available.jpg" would be in a folder somewhere on my hard drive? If so, that could be a problem as I'm on a network with 13 other users and using FMSErver as well.

Am I out of track with that assumption?

:-)

Luc

[J]

Did you get this working? I am actually trying to show a picture in a field based on a calculation.

Thanks,

J

[otterboy]

Did you get this working? I am actually trying to show a picture in a field based on a calculation.

Thanks,

J

I've been trying to do this as well, only in FM7, since the client doesn't want to upgrade. I understand it can be done in 8 with a variable. Any ways to do this in 7?

[otterboy]

I've been trying to do this as well, only in FM7, since the client doesn't want to upgrade. I understand it can be done in 8 with a variable. Any ways to do this in 7?

I feel a little stupid, but I'm replying to myself, as I got this working in FM7, thanks to this post here:

helpful message board posting

This was the most helpful part:

"The calculation must result in a string representing the file path in the

same format used by the "Insert Picture/QuickTime/File" script commands.

(Just an in any calculation, literals must be enclosed in quotes.) Supported

formats for the pathname include the following:

file:directoryName/fileName

filemac:/volumeName/directoryName/fileName

filewin:/driveletter:/directoryName/fileName

filewin://computerName/shareName/directoryName/fileName

image:directoryName/fileName

imagemac:/volumeName/directoryName/fileName

imagewin:/driveletter:/directoryName/fileName

imagewin://computerName/shareName/directoryName/fileName

movie:directoryName/fileName

moviemac:/volumeName/directoryName/fileName

moviewin:/driveletter:/directoryName/fileName

moviewin://computerName/shareName/directoryName/fileName

"

The posting mostly sums up how to do it. I just did a Set Field Calculation for the container field that had the correct (calculated) path. The kicker for me was getting the path format correct enough so that the container field would accept it, and set up the reference.

Anyway, I hope that helps someone else out there! And thanks to the original poster whoever they may be.

Sorry for the slight hijack of this thread, but it seemed related.

Edited November 18, 2005 by Guest