Script Step "Set Field"

[kenneth2k1]

Forgive my ignorance, but I need just a little bit of remedial help using the Set Field function. Vaughan once told me to use it, but the calculation aspect threw me off. Which functions in Specify Calculation do I use so that my end result in the script is [select, "Letters2", "1st FollowUp"]? Vaughan told me to look up SetField in the FM help, but it seemed of little help.

So what I guess Im asking is how should the calculation be to make it look like [select, "Letters2", "1st FollowUp"]? Once I get past this, I think I will be well on my way, and I can stop pestering everyone (Then I can pester you all with something esle!!)

Thanks again for all your help!!

[LiveOak]

I'm not sure what you mean by "[select, "Letters2", "1st FollowUp"]". How about telling me in English what you are trying to do.

The Set Field script step replaces the contents of a field with the evaluated result of the calculation you specify for it. Set Field does not depend upon whether or not the field is visible on the current layout.

-bd

[BobWeaver]

You would enter "1st FollowUp" as the formula.

I think that the "select" part only appears in a "insert calculated result" script step, not a "set field" script step, but if it does, you would click the select checkbox in the options area at the bottom of the script window.

HTH

[kenneth2k1]

Yes, that's what I was looking for. Its so simple. Thanks, Bob Weaver

[kenneth2k1]

What I mean is that, in a script, you select the Set Field function. Then when you specify, it brings up the Specify Calculation window. What do I put in the calculation to make the script set the field "Letters2" to have the text "1st FollowUp" in it. Im uneducated when it comes to these boolean calculations. Sorry

I hope I've explained this better. Thanks

[Rigsby]

If you use the “Set Field” script step, you don’t need to select the contents of the field first – the command will literally replace any information in the field with what you tell it! Rules to follow here are:

When you use the Set Field step, FM opens the set calculation window so you can enter what should go into the field. If the field is a text field,

Make sure you define the calculation result as text (at the bottom of the calculation window is a drop-down menu)

Make sure you put your text in inverted commas “Put me into the field”

Only use inverted commas on text!

If you are setting the field to a number or to a date, then you need to select this as the calculation result, instead of text.

Rigsby

[kenneth2k1]

I am so grateful to all the help I receive in this forum. Thanks all!

Ken