Hello Filemaker users,
I have a table in which there are three fields which are important for my question. These fields are: Category, Question, Answer. Each category has a button in the header part of the list-view layout. I want to be able to have the colour of a button change to green when all the questions have been answered.
I tried to create a variable that keeps track of the amount of questions and amount of Answers that are answered. when these values are equal the button's colour changes to green. This works for the particular button that has been pressed on. When I press another button the previous button's colour gets reset to blank.
Do I have to create a related table with the count values stored in fields? Or is there another way?