Change field if list of fields


I would like to change one field to yes/no in User data type only when all fields in records created in another data type by this user is yes or no. Is it possible? How to accomplish that?

Explore backend workflows base on a database trigger event