› Forums › Cascading dropdowns › Filter field by Lookup
Tagged: cascading, Filter, vLookup cascading
- This topic has 3 replies, 2 voices, and was last updated 11 months ago by Alexander Bautz.
April 22, 2022 at 13:08 #35783SteveParticipant
I’ve been trying to solve this problem out for several hours and I think I’m missing something tiny.
1. I have got one cascading dropdown from which I can select about 10 values
2. When I choose one value, I need to init another cascading dropdown on the second data field to chose from filtered by the value above in the column.
1. I choose “Bread”
2. In the second data field, these values is shown “Butter bread, sunflower bread, etc..”
I also have a list that has these values, list items connected via vLookup Column.
See in the attachment below.
Could you also explain me, which properties dows vLookupColumn have?
I mean “FieldInternalName/Property”? I have not found any kind of list of properties that I can use on vLookup column.
Thank you Alex so much,
April 22, 2022 at 22:44 #35788Alexander BautzKeymaster
I think you might have misunderstood how this works. You just add the two fields in your lookup list in the “Comma separated list of fields in the lookup list” field and the two fields in the current list in the “Comma separated list of fields in the current list” field and the cascading from one field to the other is automatically applied.
Let me know if I have misunderstood what you are trying to do.
April 23, 2022 at 07:11 #35789SteveParticipant
yes, you were right. As I said, I was trying to do something else all the time than to use the basic functionality of cascading dropdown. For the explanation, I send some pictures, how I figured it out. Thank you so much.
I have also understood the description when the vLookup column is type of vLookup.
FieldInternalName/Property – I got it!
April 23, 2022 at 21:24 #35791Alexander BautzKeymaster
I’m glad you figured it out!
- You must be logged in to reply to this topic.