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

Set a Field Value with a List Lookup Control

Jump to solution

Hello;

Could you help me please with this case : 

i have a list with States and Capitals : states are in a drop down( Lookup control), Capital on single line;

On the form "o365", i want to select a state and show the capital associated in the list on a single line filed.(Disabled, user cannot modify the capital)

Thank you for you help in advance;

Ahmed.

Labels: (1)
0 Kudos
Reply
5 Replies
bashyarajan
Nintex Newbie

Re: Set a Field Value with a List Lookup Control

Jump to solution

Hi ahmed,

   You are looking for a Cascaded Dropdown . here you go Cascading Drop Down – With Nintex Form in O365 . This worked for me . Please try this too https://community.nintex.com/external-link.jspa?url=https%3A%2F%2Fyoutu.be%2FCPUtIMWkyWE     

 nintexforms‌ custom development‌ cascading dropdown‌ forms for o365‌

Thanks 

Bashya Rajan A

0 Kudos
Reply
asadki
Nintex Newbie

Re: Set a Field Value with a List Lookup Control

Jump to solution

Thank you Bashya for your response; I know how to do cascaded Dropdown, no Issues;

But;

For my case, I have only 1 value returned, so i want that value on a Text box not on drowpdown list.(to avoid click on the dropdown list then select the only value)

any idea how i can do that ?

Thank you Again

Ahmed

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: Set a Field Value with a List Lookup Control

Jump to solution

You can do this with a Calculated Value! There is a runtime function called "Lookup" and the syntax is lookup("title of the other list", "column to filter on", "value to filter on", "output column").

So you can have a box labeled State then a label that says "Capital" and have the calculated field under that. They're not editable. So yours would be something like lookup("states and capitals", "State", state, "capital") .  Make sure when you pick the "value to filter on" field, you pick it from "Named Controls", not "Item Properties." 

0 Kudos
Reply
asadki
Nintex Newbie

Re: Set a Field Value with a List Lookup Control

Jump to solution

Thank you so much Courtney, this is exactly what i was looking for, i was sure this will work for me before testing.

I have 1 more question if you could help me with : How can i filter on 2 fields at same time ?

ex : Filed    Country : US or Canada :

                 Cities: both have vancouver

                  size : to lookup

List: country  | city            | size

            US     |vancouver  | 2222

        Canada | vancouver | 5555

please find my case with all details at below URL :

Dropdown cascading lookup with 2 filters fields !! 

Thank you Again Courtney

Ahmed

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: Set a Field Value with a List Lookup Control

Jump to solution

I replied to your thread; can you go ahead and close this one by marking an answer as correct if your question has been answered?

0 Kudos
Reply