I have a layout where the records are in list view. I have created a container field that contains a color. I would like to have a script change the color of a selected record through a button action. What has me stumped is how can I change the selected record back to no color when another record in the list is selected.

thanks in advance - Sam

Sam,

I have done something similar for the company I work for. Instead of removing the highlighting I left it highlighted so they can highlight multiple records. My best guess would be add a global field of number type. When you click the button have it set that global field to the record's ID. Then using a self join of the global field to the record ID you could change the "color" of the old highlighted record and then add the "color" to the new record.

Fields: record_id, record_color, global_select_id

Relationship: {Name: SELF, Type: Self Join (a relationship back on to itself), Fields: global_select_id::record_id}

Scripts: {Script Name: RUN_SELECT, Pseudo Code:

Setfield[sELF::record_color to ""]

Setfield[sELF::record_id to ""]

Setfield[record_color to select color]

Setfield[global_select_id to record_id]

}