Hi folks, I am wondering if there is a way I can do a lookup on lists and set a value automatically. For example, have a list that if a particular string, or reference is found in a large list, it sets another field, or generates a popup or notification. For example, I have a list of customers that I type a string in, it looks up and returns a response, so if the customer exists in list A, it sets field A accordingly, however, if they are on list B, a notification of some description pops up. I know triggers and automation allow a list of a handful of phrases or words, but I suspect this won't be appropriate for large volumes. Perhaps there is a plug in which can achieve this?
Please sign in to leave a comment.