calculated value lookup nintex

[Patience]

hello, I am new and I have been struggling. I created a form for list of banks, bank transit and branch. I created three list: Banks, BRANCH&TRANSIT and banks. I got the banks and branche selected to work but I need the transit number to work. I can't get to work. can someone help me. thanks

[Tarf]

Hi,

with the given information we are not able to help.

Could you please elaborate?

What is the transit number? Is it a information in the branch and transit list? In this case a formula like this should work for you:

lookup("BRANCH&TRANSIT","ID",parseLookup([Your_Form_Control]),"TransitNumber")

How are the lists affecting each other? Are you using some sort of cascading lookups which fail?

[Patience]

hi,
transit number is a unique number that needs appear when they decided which branch. the transit number is in the branch&transit list.
Banks and branch&transit are cascading lookups, they did not fill it just I need to bring the transit column out as well.

[Patience]

these are the two cascading list.

[Tarf]

Have you tried my formula?

lookup("BRANCH&TRANSIT","ID",parseLookup([Your_Form_Control]),"TRANSIT")

where

"BRANCH&TRANSIT" is the name of the list

[Your_Form_Control] is the form control name for the branch

"TRANSIT" is the Ouput column, I have already changed it from my original suggestion.