Hi all, I need some tips cause I would like to create a survey form but with “unique values”.

Let me explain:

Assuming we have a team, and we want to make a voting (es. a number from 1 till 5…) .

I know that I can manage it by many types of fielad (rating, single select menu etc…). But for me is important that the value of vote is “unique” (like a bullet ) so,for example if Tom uses the number 5 into a field he can’t use it anymore in the same record ( in this example Tom remains with 1, 2, 3, and 4 to use and so on…). Of course others people can use each one the 5 value but always one time only like Tom doing…

Do you think it could be possible to manage this with a right use of Airtable?

Thanks