I have a calculation field "deleteButton" that always returns the value "delete". When it's okay to delete a record (according to a set of rules) the value appears in the color assigned to the field. But when it's not okay to delete a record, the value appears in a "grayed out" color.

How can I have my Delete script check the color of the value in that field?

I suppose that's possible, but I suspect it would be much simpler to check the same set of rules that the calculation field does.

Hi Michael,

Nice custom function. It does exactly what I want (once I figured out that the :paragraph: at the end was tripping me up in the calc in my script)

...but I suspect it would be much simpler to check the same set of rules that the calculation field does.

But then if the rules change I'd have to update them in 2 places.

Attached is a sample of what I want, utilizing your CF to do so. Can you think of a better way to accomplish what I'd like to do? I'm certainly open to suggestions.

Thanks for your help!

RGB_Test.fp7.zip

But then if the rules change I'd have to update them in 2 places.

True, but now if you want to change the colors, you need to update the script - which is much less obvious.

How about something else?

RGB_Test.fp7.zip

Very nice!!

It took me a while to figure it out. I'd never paid much attention to "Format As Boolean" in the Number Format dialog before. This is a great technique.

Many thanks, Michael!

:qwery: Now if there were just a way to define mouse-over behavior at the script level (beyond Button Setup dialog)...