In the AgendaTable(Parent Table) which has many differernt options in OptionTable(Child Table) needs to be voted by users, of which they go into VoteTable(SubChild Table) to cast their vote and the vote is recorded using USERMAIL().
I want to limit 1 vote per user per Agenda so if they have voted to any Option, than they are not allow to voted again.
I’m using Action to link the user to voting page.
The expression I use in the OptionTable(Child Table) to count if they have voted worded
COUNT(SELECT(OptionVotes[AgendaOptionID], AND([AgendaOptionID] = [_THISROW].[AgendaOptionID], [ByWhom] = USEREMAIL()), TRUE))
but this can only count 1 individual option, so how do I make it to where all options can be counted for that Agenda