Using a script populate empty field

[jerepjohnson]

Is there a way to have a script insert text into a certain field that is blank? I need the script to find all records that have this field blank and then insert a value into the field. Is it possible?

[bvo12585]

I would do something like this:

Enter Find Mode

Set Field [Field; "="]

Perform Find

Replace Field Contents [Field; "Value you want entered"]

Using "=" in your find will find all records with nothing in that field.

[Lee Smith]

[color:red]jerepjohnson Welcome to the Forum,

[color:blue]Please complete your Profile for your Operating System and Version of FileMaker

To do this, use the Menu [color:red]My Profile and Select the Option of "[color:red]Control Panel"

[color:red]Profile Options



Public Profile

Private Info

Change Password

Signature

Avatar Settings

Display Settings

Email Options

[b]FileMaker Questions[/b][color:blue]Select this[/color]

[/color]

This way we can tailor our replies to your set up better.

Enter Find Mode

Set Field [Field; "="]

Perform FindYou are already working with the Found Set

Replace Field Contents [Field; "Value you want entered"]

You can do this without a script.

Do a find in the field for = as suggested by bvo12585

Type in the new value for the field you want to change it to in the first record, and

Then use the Replace in Main Menu under [color:red]Records then hit the Replace Button at the bottom.

HTH

Lee