I have a CMS in Filemaker where the fields that remain to be filled in by the user are highlighted in red through conditional formatting. Is there a way to determine which fields on a layout are coloured red, so that when the user tries to exit the record I can check that all the necessary fields have been filled in?

Or is there another way to organise this?

Many thanks in advance,

W.

Well most likely the same condition that you use apply the conditional formatting will hold true for your check.

In this case is it most likely IsEmpty(Field). Therefore you can check if every field is empty.

A quick way to make sure that all the fields are not empty is to add them up.

If [ Sum ( IsEmpty (Field1); IsEmpty (Field2); IsEmpty (Field3) ) ]

Show Custom Dialog [ "Not Done" ]

Else

Do next routine

End If

If any of them are empty, then it will return a number so the boolean check of If will be true.

You may also want to use Trim to make sure that they didnt type a space as an extra precaution.

Sum ( IsEmpty (Field1); IsEmpty (Field2); IsEmpty (Field3) )

How about:

Count ( Field1 ; Field2 ; Field3 )

True that would work better.

However it still doesnt give an opportunity to check for unwanted spaces so I would still recommend perhaps using Trim ().

OK. Thanks. Unfortunately it's a bit more complicated than empty or not. So it seems I am going to have to duplicate the logic.