Jump to content

Script to Change Value in Value List


hociman

This topic is 6161 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am using FileMaker 8.0. I have a database with a value list field whose options are "Yes" or "No". I would like to write a script that will go through all records in the database and change any instances of "Yes" to "No". Is this possible? I tried doing it the following way but was unsuccessful.

Show All Records

Go to Field [Contact::RSVP]

Set Field [Contact::RSVP; Contact::RSVP = "Yes"]

Go to Field [Contact::RSVP]

Perform Find/Replace [No dialog; Contact::RSVP = "Yes"; Contact::RSVP = "No"; Replace]

Thanks for reading!

Link to comment
Share on other sites

Here is but one way of doing it:

Show All Records

Go to Record/Request [ first ]

Loop

If [ field = "Yes" ]

Set Field [ field ; "No" ]

End If

Go to Record/Request [ next ; exit after last ]

End Loop

Link to comment
Share on other sites

This topic is 6161 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.