Hi

I'm new to scripts in Filemaker and would like to start getting my head around writing a script to help me in creating a daily report.

I have created a database where I record information for a film project to track shots that need effects work done on them.

I have set up the database to so I can input various data based around the number of cameras used on a particular day.

I need to create a daily report that pulls in all the shots for the current day that requires an effect. I fill in a field for each camera if the particular camera shot requires an effect. Camera's without effects I leave the field blank.

My idea is that I perform a find

Enter Find Mode []

Set Field [ table::date field ; Get (CurrentDate) ]

New Record/Request

Set Field [ ]

Omit Record

in the set field, if their is no entry in the specific field how do enter it so it will omit the record (or cameras without effects)

any help will be most appreaciated.

Thank you

I'm not sure I follow this fully - how about:

Enter Find Mode []

Set Field [ table::date field ; Get (CurrentDate) ]

Set Field [ table::effect required ; "*" ]

Perform Find []

Hi thank you for responding.

I don't see how you can enter the "table::date field ; Get (CurrentDate)"

into the set field[]

and table::effect required ; "*"

into the set field []

thanks

The Set Field step has two options: 'Specify target field' - this where you select the field to set, and 'Calculated result' - this is where you specify the content.

For the first Set Field step, select your date field, then enter Get (CurrentDate) in the calculation formula. For the second step, select the effects field, and enter "*" as the criteria.