Scripting Proudly
One of my co-workers left me a list of fixes she needed for the database I'm developing for her group and when I read it the first time I didn't think I'd be able to figure out one of the things she wanted. She wanted the database to search to see if when a new person or organization is entered whether they already existed in the database.
I was able to write a script that finds the combined first and last names or organization name and if there are more than one record in the found set, you get a message saying that you've entered a duplicate name. I was quite proud and excited. Now we'll see if it works when they try to use that script for real.
Nice work! What scripting language are you using to do that?
ReplyDeleteThis is all in FileMaker. I'm lucky that I also have a database that someone else created that I can copy scripting elements from. Then I don't have to make everything up from scratch.
ReplyDeleteFor this script I used Status(CurrentFoundSet) which I never would've known about had there not been a similiar script in my other database.