Hi, I am new to filemaker.
Sometimes, my clients would like to change the value of some fields for example, changing from a to b, c to d. In this case, I will write a script to find these records and replacing field contents/loop through all target records/Importing records. If I am going to use this script step to modify large amount of data. It may cause problem of the index so I am wondering is there other ways to solve this kind of issue or better practice to handle this issue.
I am using filemaker 17.