hello,

 

I have a button ('pod' = proof of delivery) who creates a mail with a pdf in.

The PDF is not created by a lay-out but a scanned document.

every record must have a document (POD)

This functions works good

 

question

When I push the button he goes to a map and takes the file...

What I don't see (before pushing the button) is if the scanned document for that record is in the map.

so I want a checking script for each record that tells me if the document is already available.

I wanne work with colors

Not available = button green

available = button red

 

attachment = script of 'POD'

What do you mean by "map"? 

 

 

This allows you to check if a field contains a value - or in the case of a container, an object:

 

Not IsEmpty (table::field_with_PDF)

 

You could use this function with conditional formatting, or if you have FileMaker 13, you could hide the entire button if no PDF is available.