Is there a way to do a calculation that says

If X is BLANK (where blank is an empty field) then so and so...

Looking for the Syntax of BLANK (empty field).

Thank you!

Moosh

IsEmpty ( theField )

... used thus:

If ( IsEmpty ( theField ) ; then so and so )

... or within Case() or as boolean (and more). Reverse would be If ( not IsEmpty ( theField ) ...

If we can help with the full calc, let us know.

LaRetta :wink2:

Hi -

I am very new to databases, FMP, this forum... I am a volunteer trying to build a viable solution - utilizing starter solutions - for a bookstore at our church. I have been reading through these forum posts and find them to be very helpful -- thanks to you all for taking the time to share your expertise and help those of us who are new.

LaRetta, I especially appreciate your input. Clear, concise, thorough, encouraging, very very helpful.

SharonK

LaRetta,

The calc you listed above seems like something I was looking for. I am trying to show all records and if a particular field is empty I want to automatically delete that record. Would the calculation you listed above work for me? If so, how would I finish it? I've tried a few different ways with no results.

(Ditto what SharonK said)

Thanks,

Kevin

Hi Kevin,

If used within a Find, try this script:

Allow User Abort [ Off ]

Set Error Capture [ On ]

Perform Find [ Restore ]

On Perform Find, specify a new Find Request as:

1) Select the field to omit with blank value

2) Type = into the criteria and add it

3) Action popup above should be set to Omit Records

LaRetta :wink2:

My apologies - I didn't read the delete part. Change that to:

Allow User Abort [ Off ]

Set Error Capture [ On ]

Perform Find [ Restore ]

If [ not Get ( FoundCount ) ]

Show Custom Dialog [ "No records to delete" ]

Show All Records

Halt Script

End If

Delete All Records [ ]

On Perform Find, specify a new Find Request as:

1) Select the field to find with blank value

2) Type = into the criteria and add it

3) Action popup above should be set to FIND Records

You say you want to automatically delete the record. That's okay - just click 'Perform Without Dialog' checkbox on the delete script-step.

Thanks LaRetta,

My boss just walked in and dumped a ton of other work on me. I will have to try your suggestion next week. I appreciate the response.

Have a great weekend.

Kevin

LaRetta,

It works. Many thanks.

Kevin