Flag or marker

[KevinRan]

I work for a printer. I have a database that tracks the print jobs that come into our office. I'm trying to figure out a way to get some kind of flag (like a large red square) to appear in the layout if a particular check box or radio button field is selected. The scenario is this, I want something bright to indicate this client ordered a proof sent to him before we print the job. An ordinary check box is missed too easily.

Thanks in advance,

Kevin

[Lee Smith]

You can do this with a container field and a calculation that returns the Repetition of the container based on the checkbox.

The attached quick little sample show what I mean.

HTH

Lee

[KevinRan]

Thanks Lee, I'll give it a try. However, I don't see the attachment you're referring to.

-Kevin

[Lee Smith]

Oops

Here

Ck_Bx_Flag.fp7.zip

[KevinRan]

Thanks Lee, I've been working all morning on the concept and haven't figured it out. Now that I have your example I think I'll have better luck. I really appreciate the help.

[KevinRan]

Hi again,

I got the function to work fine with just one checkbox. Is it possible to make the flag appear when the field refers to a value list containing more than one item? I messed around with it and was unable to make it happen with more than one.

Thanks, Kevin

[Lee Smith]

I'm glad you got that part working.

Yes, you can have it react to different words in a value list. However, I used a number field, you will need to change the value list to words, and "Hard Code" the words into the calculation.

See the Phase II layout and the fields involved

HTH

Lee

Ck_Bx_Flag.fp7.zip

[KevinRan]

Lee,

Thanks again. Your samples are great. I think I'll have time to work with this one today. I'll let you know how it goes. You have really helped me learn alot!

Kevin

[KevinRan]

I got the flag to work fine. I have learned a lot in the process. Thanks for your help. Now on to my next project. I have to create an estimating program for our company. I love this stuff!

Kevin

[alcam]

This sounds like something I'm trying to achieve. Problem is - and to my shame - I only have FM Developer 6 (yes, I will upgrade soon). Is it possible, Lee, for you to paste the script as text into the forum? It would be much appreciated.

[Lee Smith]

It is not a script, it is a calculation.

I have attached a v5 file that does the same thing.

Ck_Bx_Flag.fp5.zip

[alcam]

Thank you Lee for taking the trouble - it works perfectly. I am forever in your debt.