Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

Featured Replies

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"?

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.  

  • Author

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.

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?

  • Author

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. 

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 ]

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).

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.