Solved: A formula that give an option of what text display... - Page 2

Arthur_Siloka · 04-09-2020 05:37 PM

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?

Arthur_Siloka

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”)

View solution in original post

A formula that give an option of what text display in row