Write a fairly simple Filemaker Pro script to find all Deaths and Deceased where the death field has a date format and the deceased field has a text format
Note: the AHSAA database has a field named "Death" formatted as a date field. Kirk and I did this in 2024 so it would be easier to sort deaths by date and also force the date format to be uniform. There is a second field "Deceased" that is a text field which has all the deaths were the exact date of death (DoD) is unknown or partially known. If no date is known then it has the text "Deceased" in the field. If a partial date is known, then, for example, it might have something like 1/00/2024 in the field etc. These would be all text in this field. So you can search by the text wildcard "*"
Find all Deceased + Death
- Go to Layout [ “Death Copy”; Animation: None ]
# Make sure to enter Find mode or you might overwrite a field
# Pause off will not pause the script and continue without pausing - Enter Find Mode [ Pause: off ]
# Set the death field. This is to find all records were Death Field is a wildcard. Note death is a date field so you specify //2025 to find all deaths in 2025 or //* will find all death dates - Set Field [ AHS Alumni::Death; "*/*/*" ]
# next find all records were the Deceased text field is not empty
# Do a new request and this will add to the last Set Field - New Record/Request
# Now set the Deceased field which is a text field to * to add to the above death find. This is the second request on this find. - Set Field [ AHS Alumni::Deceased; "*" ]
# only do one find for the 2 requests above. This will find all the deaths plus all the deceased - Perform Find []