Calculated Field

[Mike CPB]

Hi all. New to Filemaker, but getting somwhere day to day has been interesting.

If ( Account = "New" ; "XXXXXXXXXXX" ; "")

I have a field calculation that if the corresponding field contains certain text it will result in specific text in the calculated field. So far that works just fine, as long as the reference field contains that exact text ( at least at the beginning of the cell )

What are my options to search the within the cell for a match? I can't seem to use * as a variable in the calculation.

Maybe this is a limitation, or better yet, I'm uneducated.

Thanks in advanced.

Regards, Mike C.

[Mike CPB]

Guess that didn't take long... GO GO Gadget patterncount...

Thanks anyways, sure I'll have more questions.

Regards, Mike C.

[Ocean West]

Welcome Mike,

You can use the Exact function to be explicit where you wish to make sure the field is an exact match. http://fmforums.com/forum/showtopic.php?tid/194162/post/285587/hl/exact/fromsearch/1/

If ( Exact ( Account ; "New" ) ; "XXXXXXXXXXX" ; "")

or you may try PatternCount() to determine if the Field matches some pattern string that you are expecting.

hope that helps.

[Mike CPB]

That's a good idea... I'll try that too...

I have another question.

Is there a way to modify a script based on option/ctrl click?

If I option/ctrl click a button the script will perform alternate?

Regards, Mike C.

[comment]

See:

http://fmforums.com/forum/showtopic.php?tid/177234/

[Mike CPB]

If [ Get ( ActiveModifierKeys ) = 1]

Delete Record

Else

Create New Record

End If

Complements Dwayne Wright & Google... Sorry for wasting time.

Regards, Mike.