Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Find script with quotes


futility
 Share

Recommended Posts

I have a find script based on user variables and just realized that some finds are coming up with more records than I'd like.

 

My basic find is:

Set Error Capture [on]

Enter Find Mode []

Set Field [Table::field;$$Variable] (this is so my users can't access records they aren't supposed to)

Go to Field [Table::field]

Pause/Resume Script [indefinitely]

Perform Find[]

 

Problem is that when the variable for someone is set to Red I'm also getting Red Rock.

 

How can I make my search have quotes so that I won't have this problem?

Link to comment
Share on other sites

In FileMaker a double equals sign means "exactly this value, not any value starting with this value":

 

Enter Find Mode []

Set Field [Table::field; "==" &$$Variable]

Go to Field [Table::field]

Pause/Resume Script [indefinitely]

Perform Find[]

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use