Return to FileMaker.com
How to replace an empty field with a value
I found the need to add field to one of my layouts, rather then go back throug all of the records, and add in the needed value in the field, how can I do a find and replace on an empty field?
Enter FInd Mode enter an "=" equal sign - this will find records with empty field.
Under Records Menu is "Replace Field Contents" - will replace contents in a selected field in the found set.
Retrieving data ...