For each user { get value in field "color" if the value is "red" { display username } }