October 2, 201213 yr 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?
October 2, 201213 yr Author 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.
October 2, 201213 yr 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): Create the ‘I declare variables’ text box as indicated (with conditional formatting) (learned from Comment). Be sure to Arrange > Send To Back Create a button and place it behind the row (also with conditional formatting) Create script with single Freeze Window (learned from Mr_Vodka) and attach as script trigger to layout OnRecordLoad To get field highlight (the yellow): Make all your enterable fields with a fill of your desired highlight color. 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, 201213 yr by LaRetta
Create an account or sign in to comment