Hey-ho, all--

Can anyone tell me why this script is not auto-inserting the text into the chosen field when the appropriate condition is met? After creating a record and entering M30001 in the Press field I can then perform the script manually and it works properly.

What am I forgetting?

Duh, the first thing I forgot was the script:

[color:black]Script Title: Auto Insert M30001 WG

[color:red]If [ ImposeCoverSheet::Press = "M30001" ]

Perform Script [ “M30001Webgrowth” ]

End If

Script mentioned above:

[color:black]Script Title: M30001Webgrowth

[color:red]Insert Text [ ImposeCoverSheet::Web_Growth; “M30001 - Y web = use "Web Growth 0.5_Base Yel"” ]

Thanks,

Roger Kidder

RR Donnelley - Wells Division

Edited June 28, 200718 yr by Guest

The Insert Text script step only works when the field is on the current layout.

Change it to Set Field, it has no such limitations.

More to this question than meets the eye.

http://filemakertoday.com/com/showthread.php?p=54335#post54335

Even when the field exists on the layout, it must still be editable in browse mode.

Use the SetField function instead - doesn't require field on layout.

Thanks to all for your input.

I did not realize repeating fields were such an issue when it comes to scripting. Since the consensus is that I should not use repeating fields, given my novice status, I have recreated 10 individual instances of the field "Press" labeled "Press01" through "Press10". Now, please tell me I won't need to create 10 different scripts to insert the desired text into the one "Web Growth" field.

I don't think that would work anyway, since it would add the text to the Web Growth field with every instance of M30001 in the Press fields, yes? I only need it to be entered on the first instance no matter which Press field it appears in.

All help is greatly appreciated and I hope y'all can understand what I am talking about.

As an aside, can anyone suggest resources to get a better handle on FileMaker for the novice, including classroom instruction via internet or brick and mortar (in Maine, US)? I am interested in learning a lot more about FileMaker.

I am quite computer savvy and unafraid to plunge right in, having been a Pre-press Systems Administrator for over ten years, but, for some reason I have a difficult time wrapping myself around some of the concepts of FileMaker. I kind of expect the scripting to act like the old BASIC programming language which I learned 35 years ago. What is my problem?

Roger Kidder

RR Donnelley - Wells Division

Oops

Michael

Edited June 29, 200718 yr by Guest

Roger here is a simple sample file demonstrating a lookup. Note the relationship. That isw what allows the lookup to take place. It should get you started.

Michael

AceRoget.zip