I have a product table and on product detail page I want to display โlikeโ or โunlikeโ depending on whether the user already like the product. I have set up a likes table that contains column Like and Email. Then tried using this formula but its not working as I want it to
IF(and([Likes].[Like]<>0,[Likes].[Email]=useremail())=false, โLikeโ, โUnlikeโ)
Any ideas or suggestion on how to go about it?
Solved! Go to Solution.
I ended up with the following formula which is working perfectly. Thanks all
IF(in(useremail(),SELECT(Likes[Email], ([Product Id] = [Likes].[Product Id])))=true, โUnlikeโ, โLikeโ)
What if you remove the portion =false ?
that wasnโt working either. thanks
Good to know that you have it working, please mark the working formula as per your post as acceptable answer.
I ended up with the following formula which is working perfectly. Thanks all
IF(in(useremail(),SELECT(Likes[Email], ([Product Id] = [Likes].[Product Id])))=true, โUnlikeโ, โLikeโ)
That expression is still a bit confusing to me. I presume you have a table called Likes with two columns โ Product and Email.
How about something like this:
IF ( COUNT( SELECT(Likes[Email], AND([ProductId] = [_THISROW].[ProductId], [Email] = USEREMAIL()))) > 0, โUnlikeโ, โLikeโ)
Perhaps you already have a virtual column Likes on the Products table which is a list of refs to all Likes for the productโฆ If so โฆ
IF ( IN(USEREMAIL(), [Likes][Email]), โUnlikeโ, โLikeโ)
User | Count |
---|---|
33 | |
30 | |
29 | |
20 | |
18 |