Is it possible to perform a find of contents of a calculation field?

[hartmut]

If i have a calculation field  called "UNIQUE" which calculates text from two other fields --- can I direct filemaker to find that content

 

example field unique content  is "red23"

Is there a way to tell filemaker to find the content of the field "unique"?

[doughemi]

Your description is a little vague.  Do you mean that the calculation in unique is something like ColorField & NumberField?  Do you want to reference it in some other calculation?

 

If so,  I think Evaluate(unique) will do what you want.  

[hartmut]

Well usually I can write a script that will allow me to copy and paste a find request. I don't understand how you mean using Evaluate.

[eos]

Why don't you just describe exactly what you want, and try to be more precise with the terminology?

 

If i have a calculation field  called "UNIQUE" which calculates text from two other fields --- can I direct filemaker to find that content

 

e.g., do you want to find all records that have the same value in that field as the current record?

[hartmut]

Thank you

I want to find a way to find all records that match the current record in the field called 'Unique'

so the find is all records that contain the content of "unique" but the contents are from the current record.

 

To me this is a calculation  and I am asking how to use the results of a calculation field in a find mode. 

[eos]

To me this is a calculation  and I am asking how to use the results of a calculation field in a find mode. 

 

Not differently than any other field type; store the value in a variable while in Browse mode, then use it in Find mode, e.g.

Set Variable [ $searchValue ; YourTable::unique ]
Enter Find Mode
Set Field [ YourTable::unique ; $searchValue ]
Perform Find

but since you're just looking for a single, unmodified field value, a much easier way is

Find Matching Records [ YourTable::unique ; Replace ]

[comment]

If i have a calculation field  called "UNIQUE" which calculates text from two other fields --- can I direct filemaker to find that content

 

example field unique content  is "red23"

Is there a way to tell filemaker to find the content of the field "unique"?

 

This doesn't answer your question, but I suspect it may serve your purpose better:

 

Define UNIQUE to be a Text field, auto-entering a calculated value (replacing existing value) =

FirstField & "|" & SecondField

and set it to validate as Unique.

 

 

Do you want to reference it in some other calculation?

 

If so,  I think Evaluate(unique) will do what you want.  

 

I think not (said Descartes and vanished).