Script for checking completing fields.
I'm still fairly new to FileMaker and scripting but I'm getting better at both. So I'm working a databasee that has a list of about 20 names. To keep the question simple, let's say that the databse has only two fields: one called "names" and the other called "status".
I want to create a script that will check each name in the "names" field and input yes or no into the status field of the record if the name matches one of about 10 names. I need the script to be able to do this for each of the names.
I think I probably will have to write one script for each name. This is fine if that what it takes. Can this be done?