AnsweredAssumed Answered

Conditional formatting based on active record

Question asked by trialuser1111 on Aug 3, 2009
Latest reply on Aug 3, 2009 by mrvodka

Title

Conditional formatting based on active record

Post

In my database, I have a table that lists out meetings with fields for firms and contacts.  Currently, the firm field and contact field are set up as buttons to take you to another layout detailing the relevant info for that particular firm or contact.  While this makes navigation easier in some regards, it inhibits data entry since people have to remember which fields you can click into directly and which fields you have to tab over to from another field.

 

What I'd like to do is replicate the functionality and behavior of the little gray arrows in iTunes.  These only show up when a song (in our case, record) is the active/selected song/record, and you can click the arrow to re-direct to the iTunes Store or manipulate the text within the field.  Is there a way to create a conditional formatting formula that makes the arrow visible when that record (not necessarily that field) is active, or to hide it/make it match the background color when not?

Outcomes