Scripting current record (or field) to change color upon entry

[Jarvis]

Not sure where to put this question.

The only way I can think of to achieve my goal is with script triggers so I thought I would start here. I am sure there is probably a more efficient way to do this.

I have a database that makes extensive use of GO TO RELATED RECORD.

Most of my time is spent on a list type layout monitoring design issues for my cabinetshop.

Periodically I need to toggle to a memo field on another layout then back to the list layout.

Both directions of travel are based on GO TO RELATED RECORD.

When I return to the LIST layout It is hard sometimes to find my current record.

Is there a way to make the current record (or field) change color upon entry into the field?

Would like accomplish this without a monster sized script.

Anyway to color the the current record or script then erase the color upon exit?

[bcooney]

http://fmforums.com/forum/topic/53590-highlight-active-row-in-list-view/

[Jarvis]

Thank you Bcooney.

That thread is five years old.

I would have thought filemaker would have come up with a way to do this natively.

It seems like such a useful attribute.

[LaRetta]

There are easier ways – even in version 11 (please see attached showing both techniques). Use one or the other or both ...

To get the row highlight (the green):

1. Create the ‘I declare variables’ text box as indicated (with conditional formatting) (learned from Comment). Be sure to Arrange > Send To Back
   
2. Create a button and place it behind the row (also with conditional formatting)
   
3. Create script with single Freeze Window (learned from Mr_Vodka) and attach as script trigger to layout OnRecordLoad
   

To get field highlight (the yellow):

1. Make all your enterable fields with a fill of your desired highlight color.
   
2. Attach conditional formatting as indicated with only formula of 1 and make the field fill white (or your normal field fill color)
   

But why are you using Go To Related Record so much? I was going to address how to maintain your record place on the parent but I do not understand the relationship between your table the list is based upon and that memo field. If you fill me in, we can probably eliminate that issue as well. :^)

UPDATE: Added blue for clarity

OOOPS: I neglected to hide the I Declare Variables. File fixed.

HiliteRow.zip

Edited October 2, 2012 by LaRetta