AnsweredAssumed Answered

Need help with first FMP11 Script

Question asked by DarrenC on Aug 18, 2014
Latest reply on Aug 19, 2014 by philmodjunk

Like • Show 0 Likes0
Comment • 6

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

philmodjunk Aug 19, 2014 12:06 AM

Correct Answer

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

See the reply in context

No one else had this question

Outcomes

DarrenC Aug 18, 2014 4:44 PM

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.

Actions

RickWhitelaw Aug 18, 2014 6:44 PM

"Print" prints records, not fields. Perhaps I'm not understanding this correctly . . .

Actions

DarrenC Aug 18, 2014 6:48 PM

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.

Actions

philmodjunk Aug 19, 2014 12:06 AM

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

Actions

DarrenC Aug 19, 2014 9:32 AM

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.

Actions

philmodjunk Aug 19, 2014 9:36 AM

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.

Actions

6 Replies

DarrenC Aug 18, 2014 4:44 PM
Mark Correct
Correct Answer
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 Likes0
Actions
RickWhitelaw Aug 18, 2014 6:44 PM
Mark Correct
Correct Answer
"Print" prints records, not fields. Perhaps I'm not understanding this correctly . . .
Like • Show 0 Likes0
Actions
DarrenC Aug 18, 2014 6:48 PM
Mark Correct
Correct Answer
     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 Likes0
Actions
philmodjunk Aug 19, 2014 12:06 AM
Unmark Correct
Correct Answer
     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 Likes0
Actions
DarrenC Aug 19, 2014 9:32 AM
Mark Correct
Correct Answer
     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 Likes0
Actions
philmodjunk Aug 19, 2014 9:36 AM
Mark Correct
Correct Answer
     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 Likes0
Actions

Need help with first FMP11 Script

Title

Post

Outcomes

Related Content

Recommended Content