Inserting an Omit Recrods In a pre-generated script.
I'm working on a lighting database for a theatre show. I would like to omit records automatically that have a certain field that is blank for a report. Script below that I have tried.
--Enter Browse Mode
--Go to Layout ["channel Hookup" (Rocky Horror)]
--Sort Records [Restore; No dialog]
--#Go to Preview mode for earlier versions which do not support summary reports in Browse mode.
--If [GetAsNumber (Substitute ( Get ( ApplicationVersion ); "."; "x" ) ) < 1000]
--Enter Preview Mode [Pause]
--Enter Browse Mode 
--Go to Layout [original layout]
BELOW IS MY ADDITION, ABOVE IS FILEMAKER GENERATED WHEN REPORT WAS FIRST CREATED.
--Else if [IsEmpty ( Rocky Horror::Dimmer )]
--Set Field [Rocky Horror::Dimmer["*"]]
--Perform Find 
I've done a bunch of searching, but I'm at a loss. Looking for what ever help anyone can give. Not used to Filemaker's scripting language. And sort of a newbie with Filemaker Pro.