cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

calculated value lookup nintex

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 page3.PNG

Labels: (1)
0 Kudos
Reply
4 Replies
Highlighted
Nintex Newbie

Re: calculated value lookup nintex

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?

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: calculated value lookup nintex

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.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: calculated value lookup nintex

page1.PNG

these are the two cascading list. page2.PNG

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: calculated value lookup nintex

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.

 

 

0 Kudos
Reply