AnsweredAssumed Answered

Inserting an Omit Recrods In a pre-generated script.

Question asked by Stilts15ak on Nov 11, 2014
Latest reply on Nov 11, 2014 by Stilts15ak

Title

Inserting an Omit Recrods In a pre-generated script.

Post

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 )]

      --New Record/Request

      --Set Field [Rocky Horror::Dimmer["*"]]

      --Omit Record

      --Perform Find []

--End If

 

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.

Thank You!

 

Outcomes