› Forums › Modern DFFS › Creating a cascading lookup with lookup field
- This topic has 5 replies, 2 voices, and was last updated 3 weeks, 1 day ago by Alexander Bautz.
May 5, 2023 at 01:27 #36778
I know this is a simple question, but I have 2 lists Category and Sub Category. I want to create a cascading dropdown so that the choice of category changes the available options in the category.
The Category list contains ID, and Title
The Sub Category list contains the ID, the Category (as a lookup), Title
There is another list that contains the Category and the Sub Category and this is the list I want to add the dropdowns.
Here’s the code I currently have (and it doesn’t work)
Category.LookupValue -eq ‘[[fieldValue:Case_x0020_Category.LookupValue]]’
May 5, 2023 at 12:33 #36779
Not sure if this is the only problem, but there should not be a dash before eq. Change your filter like this:
Category.LookupValue eq '[[fieldValue:Case_x0020_Category.LookupValue]]'
If that doesn’t help please share some screenshots of the configuration so I can see what you are trying to do.
May 7, 2023 at 02:34 #36789
Thank you for the reply. I have added a couple of screenshots which show the child lookup table. I have also included the code from the original dffs that shows how the tables were linked.
Our parent table category has id, title
Our child table sub category has id, title, category (lookup to parent table)
I’m sorry that I’m asking such an obvious question.
May 7, 2023 at 08:18 #36792
OK, I think it should work if you just change your filter parameter on the “Sub category” field like this:
Category eq '[[fieldValue:Case_x0020_Category.LookupId]]'
May 7, 2023 at 08:33 #36793
Thank you very much. I tried that combo yesterday, but stil had the eq with the – in front which is why it didn’t work!
May 7, 2023 at 09:57 #36794
I’m glad it worked – I have update the user manual with an example to make it easier to set this up for others.
- You must be logged in to reply to this topic.