I have created an agenda application and I’m having problems with the filtering.
We have two tables, one which contains all the sessions of the event, and a “personal agenda” with specific sessions chosen by the user.
To register for an event, we have created an action (the blue button)
We want to show this button only when the remaining seats is higher than 0 and when the user is not registered. (If the user is registered we should show a “unregister” button). The formula that is used to filter does not work, if we are registered for an event, the button keeps appearing… and it’s strange because we are using this formula in another application witch is working fine…
This is the formula: AND(NOT(IN(USEREMAIL(),SELECT(Responses [User],[SessionName]=[TOPIC]))),[Remaining seats]>0)
On the other hand:
I have created an slice for “my agenda” but is not working either.
This is the row filter condition: IN([topic], SELECT(Responses [SessionName],[USER]=USEREMAIL()))
When I test this formula on the expression assistant, it works, but the UX view for this Slice is not showing the data.
I have spend a lot of time trying to resolve this problems but i haven’t found a solution…
Could you please help me?