Trying to Accomplish
I have an app where that you’re picking people from a list/roster. Then the people you pick are stored to a “Picks” data set. I want to limit the number of times you can pick a person from the list/roster to two times. Then once you’ve reached that limit of two, the person would no longer show up or be available to pick from the list/roster.
What I’ve tried
I have no idea how to do this. I’ve tried creating a count field and sending the pick from the roster to a data set called picks and adding a 1 to a “number of times picked” field. Where I struggle is increasing that count to 2. ie. it will just create a new row with the same pick and another count of 1.
What I need it to do is search for a previous pick with the same name if it finds that this person has already been picked then increase the count to 2, otherwise create a new entry with a count of 1.