6 Replies Latest reply on Aug 19, 2014 9:36 AM by philmodjunk

Need help with first FMP11 Script

DarrenC Aug 18, 2014 4:08 PM

Title

Post

Hi all! I'm a longtime FM user, but have no experience with scripting. For my first script, what I am trying to do appears fairly straightforward, but I'm having trouble finding the right syntax.

Here's what I want to do:

In a database in table view, I wish to perform the following function:

if [field A] contains [this text],

print [this text] in [field B]

Basically checking the value on one field (column) and then printing a note in a separate notes field (column).

This also represents the script results, if "Apple" was the Field A value and "Yes" was the print to Field B value.

Field A Field B

Apple Yes

Orange

Apple Yes

Many thanks for taking a look...

1. Re: Need help with first FMP11 Script

DarrenC Aug 18, 2014 4:44 PM (in response to DarrenC)

If it wasn't clear, this script would perform the check row-by-row. Check for [text] in field A, and if that specific text is present, print [other text] in field B on the same row.
Like Show 0 Likes(0)

Actions
2. Re: Need help with first FMP11 Script

RickWhitelaw Aug 18, 2014 6:44 PM (in response to DarrenC)

"Print" prints records, not fields. Perhaps I'm not understanding this correctly . . .
Like Show 0 Likes(0)

Actions
3. Re: Need help with first FMP11 Script

DarrenC Aug 18, 2014 6:48 PM (in response to DarrenC)

     Sorry. I was thinking in another language. ;) I just can't find its equivalent in the scripting syntax.

     By "print" I mean I wish to enter a text string in the corresponding field.

     In this case, if "Apple" is found in Field A, then enter the text "Yes" in field B.
Like Show 0 Likes(0)

Actions
4. Re: Need help with first FMP11 Script

philmodjunk Aug 19, 2014 12:06 AM (in response to DarrenC)

     Field B could be defined as a calculation field that evaluates as "yes" when Field A = "Apple".

     But a scripted approach might be:

     Enter FInd Mode []
     Set Field [YourTable::FieldA ; "Apple"]
     Set Error Capture [on]
     Perform FInd []
     Replace Field Contents [No dialog ; YourTable::FieldB ; "Yes" ]
Like Show 0 Likes(0)

Actions
5. Re: Need help with first FMP11 Script

DarrenC Aug 19, 2014 9:32 AM (in response to DarrenC)

     Many thanks for the solutions. The script solution worked like a charm.

     I'm curious about the first solution you mentioned (using a Calculation). I'm going to explore that as well.

     I've got a long way to go, so perhaps you could point me toward a learning/training resource that addresses scripting solutions similar to this?

     Regardless, thanks a million. This got me going in the right direction.
Like Show 0 Likes(0)

Actions
6. Re: Need help with first FMP11 Script

philmodjunk Aug 19, 2014 9:36 AM (in response to DarrenC)

     Field B could be defined as a calculation field with text as a result type:

     If ( FieldA = "Apple" ; "Yes" )

     It could also be a text field with an auto-entered calculation.
Like Show 0 Likes(0)

Actions

Go to original post