I'm trying to create a cascading lookups overview in Nintex Forms for Office 365 by using only one list and different columns,
I need to know if that's possible and how ?
You can refer to my entry at the end of this thread:
Cascading Drop Down – With Nintex Form in O365
But what is necessary is that Lookup1 is the title column of your list. All the other columns in that list should be lookups-type columns pulling data from single column lists. And that in the list your form is creating items in - this should also use the same lookup columns.
Main Lookup List: Available Ice Cream and Topping Combinations
Title Topping-Flavour (lookup to Topping list)
Vanilla Strawberry Sauce
Vanilla Raspberry Sauce
Vanilla Chocolate Sauce
Strawberry Vanilla Cream
Raspberry Vanilla Cream
Mint Chocolate Sauce
Form-List:Choice of Ice Cream and Topping
Use the list lookup form control to use the Ice Cream Choice to filter the available Toppings (see my linked item for a screen copy on control settings here). The column setup would be like this:
Ice Cream Choice (lookup column to Main lookup list Title column) Topping Choice (lookup column to Topping list Title column)
As long as you regard the main lookup list as one list, it is possible to do cascading lookups - because the lookup is using the indexing and values from that list for filtering. It is important, I think that the first lookup is pointing to the title column of your main lookup list, and that the other columns (used in subsequent lookup controls) are also lookups used in the main lookup list.
I hope this helps. My own search for an explanation on this was long. And I feel I really had to figure out the mechanics of it myself in the end. Good luck, and have fun.
Thanks you shaunlub
You helped me a lot
Retrieving data ...