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?