Setting Multiple Fields at Once

[Calantha]

Hello,

I have just imported 223 records into my database which didn't contain the field "Mailing List" which is a value list with the values "yes" and "no".

I need to set all of the records that have an email address in the email address field to have "Yes" checked on the mailing list field.

I have tried doing scripts with if statements (i.e. if email address is valid then mailing list "yes" otherwise "no".) I've tried using the set field function as well as any other functions that seems to work.

Is it possible to do this?! Or am I going to have to click "Yes" for all 223...?

[Reed]

Just use a find to create a found set with all the records having valid email addresses, and use replace field contents to set all those values to yes. You could also do this with a loop, but replace is generally faster.

[Calantha]

You mean Find/Replace under Edit or the replace field contents in a script?

Because i've done it within a script and it doesn't work...

Nothing seems to happen at all. The mailing list field is still blank.

[Calantha]

I got it to work for another field but I just cannot get it to work for the mailing list... and now whenever i check anything on my mailing list field it says it's only supposed to hold specific values, use this one anyway... whereas before it was working fine!

[Calantha]

Ok, I ended up deleting the field and then placing it back on the layout and now it worked.

Thanks for your help.