Make script show text when a field has data

[AlanP]

I'd like to have a script that says "File Attached" or "Issued", etc. in red text when certain fields are occupied and not show any text when there is nothing in there.

So basically if a container has a file in it you would see text that says "File Attached" but if no file is in it, there would be no text. Or if a field has data in it there will be text, no data no text.

Has anyone had any experience in doing this type of script? THANK YOU in advance to anyone who responds!!!

[Slobey]

Where would you like this text to be?

If you want a separate field to show "File Attached" then you can just use a calculation field instead of a script.

if(not isempty(container field;"File Attached";"")

[-Queue-]

Michael has it, except for a missing close parenthesis after container field. You probably do not need the 'else' null ("") result either.

[AlanP]

Thanks guys!

I keep trying it but I get "too many paramaters" error message. here is what I'm using:

if(not isempty("Attachment";"File Attached")

The field is titled "Attachment"...am I doing something wrong?

[-Queue-]

Remove quotes around the field name, so that it is not interpreted as text, and put a closing parenthesis after Attachment.

[AlanP]

Got it...thank you!

If( not IsEmpty ( Attachment );"File Attached";"")   

[AlanP]

Hey I had one more question on this....I know I've seen this done (sorta) on a filemaker pro 7 sample db.

Is there a way to say 'how many' records/attachments,etc (I'm using portals for all these). so for example if there was 5 attachments it would say "5 Attachments", 1 attachment "1 Attachment", etc.

Thanks for any ideas!!!

[-Queue-]

You mean Count(relationship::containerfield) ? I have not tried that with a container field, but it might work.

[AlanP]

You mean Count(relationship::containerfield) ? I have not tried that with a container field, but it might work.

Worked great! Thanks! If anyone is curious you have to put this in a seperate field (not in the same one talked about earlier in this thread).