Find

[mhudd]

I have a calc field that places a small graphic (red arrow)from a Global Container Field in a field called "urgent"

Now what I would like to do is find all records that are urgent. This is not date dependent. I'm not sure if I can run a find on a calc field...

[LiveOak]

Why try? Even if you could, I doubt FM could index an container field and finds would be slow. Just create another "Flag" field duplicating (almost) the calculation for your container, except make the result a "1" if the urgent conditions exist. Make sure this field is stored so it will be indexed. Perform your "urgent" find on this new field.

-bd

[mhudd]

Wow... dupicate (almost). I'm not quite sure what that means...

[Fitch]

(...puts on mind-reading turban...)

It means your original calc is probably something like this:

Case (House = "On Fire", Urgent)

So you could use almost the same calc:

Case (House = "On Fire", 1)

The latter returns a number result rather than a container.

I'm wondering if you'll need to do this, though. What are the conditions of your original calc, the one that sets the "Urgent" graphic? Could you just script a search based on that? I.e., in the example above, I could just search for "On Fire."

PS: Yes, you can search on calc fields, but not containers. (Certain types of calcs cannot be stored/indexed, so you want to avoid searching them, it can be sloooooow.)