Hello and thanks for reading. Hope you’re having a great weekend.
I have the following code in a procedure and it works as expected:
…pulling P1Skills into the search database from the tracker database. However, what I really want to do is a bit more complicated.
In the search database, there is a field called Order, and the value of Order can be P1 or P2. What I’d like to say is “If the Order field matches P1, get P1Skills, else P2Skills.”
This is one of my failed attempts at the formula:
Thank you for any help with the syntax, and have a great night.