I’ve a linked field that I want to compare to a lookup field. If any of the linked records in the linked field appears in the Lookup field I want to generate an error of some kind.
Linked field: Wishlist (Internal) (link to toy table)
Lookup field: Toys (lookup toy table)
Formula that I used: IF(FIND({Wishlist (Internal)},{Toys})<2, “ Wishlist updated
”, “
Wishlist has given toys
”)
It works if there’s only 1 linked record in the “Wishlist (Internal)” But it doesn’t work for multiple records. Is there any other way to do this?