Graphic container fields

[Frasier13]

I'm trying 2 figure out how to store a graphic in a repeating global container field.

If you refer to this link http://www.fmforums.com/threads/showflat.php?Cat=0&Number=113016&an=0&page=37#113016 you will understand more what i'm trying to achieve.

I just can't get the image to load and i know I must be doing something fundamentally wrong even though i've done it once before several weeks ago.

Can someone help

Regards

Dave

[David Holmberg]

Do you want do to the same thing as in the earlier thread but with the difference that you store the graphics in a repeating field?

Then the calc field should look something like this:

GetRepetition(Graphic;

Case( Status = "Active";1;2))

alt

Case( Status = "Active";

GetRepetition(Graphic;1);

GetRepetition(Graphic;2))

Remember to set the calc field result to container (do this in the same window as the one you write the calc in).

[Frasier13]

Im basically trying to achieve exactly as in the previous string. But for some reason I can't get it to work.

I can't remember how Filemaker know's which image it's using that's what is really confusing me.

[-Queue-]

Another alt

Case( Status = "Active";

Graphic; GetRepetition(Graphic; 2 ) )

just to demonstrate that GetRepetition( field; 1 ) = field.

[David Holmberg]

Not sure I understand what the problem is, will give it another try but otherwise you will have to wait for the big shots to give there opinion.

Read in your later post that the problem was to get the file into the container field, you should be able to just paste it as usual or chose insert picture. Can't see the problem there. Are you doing it in browse mode with the field defenition set to allowing data input?

In the previous post Fitch wrote:

Case( Status = "Active", ActiveGraphic, ClosedGraphic)

This means that you have four fields:

Calcfield (calculation)

Status (text)

ActiveGraphic (container) (global storage)

ClosedGraphic (container) (global storage)

The calc means that - case the text in status is "Active" filemaker gets the picture from ActiveGraph and puts it in the calcfield, otherwise it gets the picture from ClosedGraphic.

My alternatives uses the same principle but with a repeating field.

[Frasier13]

Hi David

I have managed to insert the images i'm working with into FM7 by going to 'Insert > Picture'.

I also have the fields:

ActiveGraphic (container) (global storage)

ClosedGraphic (container) (global storage)

Do I need to somehow get the relevant image into the relavent field? If so this seems to where i'm having the trouble.

If what I mentioned above about storing the image inside the relevant field is incorrect then i'm confused as to how FM7 references the images and then uses the correct one.

What's annoying is I have actually done this once before about a month or so ago and im buggered if I can replicate it. I even tried just duplicating and re-referencing everything accordingly since I thought that maybe FM7 would get confused if I have more than one reference the same so this recent attempt simply adding a '2' on the end of each reference but still can't get it to work.

I bet your cringing aren't you as to how dumb I must sound lol. I'm not even one of those people that has no idea about how to use software etc. I've been using a Mac for about 13 years and I even learnt how to use Director in 2 weeks... so my point being is that I don't think im thick, and im sure that either something isn't working or there is just something fundamentally wrong that im doing.

But I appreciate your help or any ones for that matter.

Regards

Dave

[David Holmberg]

Well, since you are an experienced software user this shouldn't be a problem.

I work on windows xp and you wrote that you are a mac user, maybe these commands are different?

You'll have to get the image into the relevant field. If you've placed it directly on the layout, you must have done that in layout mode. Cut the image and change to browse mode (use dropdown list or ctrl+. Then you should be able to right click in the field and then paste the image (or chose paste from the menu). Or you could go to browse mode, click in the field and use the same command as you did earlier ("insert > picture").

And you have the "calc field" and the "status field" of course.

calc field - container type

status field - text type

when you have inserted the pictures in the container fields you can define the calculation as mentioned earlier.

Case(StatusField="Active"; ActiveGraphic; ClosedGraphic)

No questions are dumb, if it ain't working it ain't working.

Queue>>You're right

[Fenton]

Frasier, after reading your posts I still have no idea what mechanism you're using to switch the graphics. The simple calculation David posted will work, I've used similar many times. In your last post you appear to be dropping the repeating fields for 2 separate fields; that's fine, but either way should work.

Are the graphics not being inserted? Can you see them in the global fields? You probably do not want to Insert as reference.

Or is it the mechanism for picking the image that is the problem? Is this a calculation? If so, what is the "trigger" field? I would suggest a Boolean checkbox, with a value list of 1 for a simple toggle.

Is the result of the calculation "Container"? (the default is Number).

[Frasier13]

Hi David

Just like to thank you all so much for your help. It's working. After reading Davids last posting about pasting the image into the container field in browse mode!! That was the only thing I hadn't done or understood.

Once again thank you.

Regards

Dave

[remixculture]

I have a different inquiry... I have a database that we have the images for an online store. Instead of saving all the images I have ~ 1500 images embedded as images in container fields. Now I can copy and paste into like Fireworks or something no problem. I am trying to export all the images... export them both as text (eg. productimage01.jpg) and to have Filemaker save the corresponding image file and in a certain specified folder (eg. images/productimage01.jpg).

HELP PLEASE