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
+8
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?
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.
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.
+8
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.