› 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.
-
AuthorPosts
-
-
May 5, 2023 at 01:27 #36778
Tanya Edgar
ParticipantI 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), TitleThere 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
Alexander Bautz
KeymasterNot 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.
Alexander
-
May 7, 2023 at 02:34 #36789
Tanya Edgar
ParticipantThank 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.
Attachments:
-
May 7, 2023 at 08:18 #36792
Alexander Bautz
KeymasterOK, 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]]'
Alexander
-
May 7, 2023 at 08:33 #36793
Tanya Edgar
ParticipantThank 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
Alexander Bautz
KeymasterI’m glad it worked – I have update the user manual with an example to make it easier to set this up for others.
Alexander
-
-
AuthorPosts
- You must be logged in to reply to this topic.