I am trying to create a dependent dropdown menu. The first 2 questions come from a table called ‘Services’ and the rest will come from another table called ‘Media’. Both tables have ‘Media Type’ column.
If I select a service type of ‘Vehicle Graphics’ and an Application type of Basic (which are from the services table), there will only be one media Type option available i.e. Polymeric.
I need to get that value and find a match in the Media Menu, then display the dropdown options from the new table.
I need to do something like.. if services[Media Type] = Media[Media Type] show a list of all media types from the Media Menu that match i.e. polymeric.
How can I do this?
The next few questions come from a table called ‘Media’, this has many columns but it also has the ‘Media Type’ column.
Basically I am trying to go through the dropdown menu until I get to Media Type (I don’t need this as a selection or to be seen, it’s just there so I can use it to match the records from the Media Table). Once I know what the media type is, I want to display the list of brands that match that. I then want to continue asking question from the media table that will show me a price.
I know this may be confusing. I’ll translate to you what your expression says.
“Select a list of Brand fields from the Media table if the list of all items of field Media Type on Services table is exactly the same string as the list of all items of the field Media Type on the Media table”
First, you have to indicate a Dataset[ColumnFromThatDataset]. Dataset may refer to a table or slice.
Second, you have to make a Yes/No expression that has to make sense. This Yes/No is evaluated for each of the rows (pretty uneficient) to decide whether it should be included or not.
Third, an optional Yes/no expression to decide if you want to just take unique values from the resulting list.
That’s why we engourage to read the docs, the answers are there, just read them slowly and calm, without the need to solve and forget
I appreciate your help and I appreciate that the question has been asked time and time again but reading the docs slowly still isn’t helping, I’ve also searched time and time again through this page looking for scenarios like mine and although I have found similar, nothing is working. I’ve learnt basic Javascript quicker than this, I’m sure once you understand it it’s easy but when you’re starting out there’s a lot going on. I’ve found this to be the same when working with Wordpress Sites, it takes longer to understand than it actually takes to code a website from scratch but when you do, it’s easy.
I’ve read through the links provided and used this code:
The dependent dropdown feature only works if the Valid If expressions are of the format
table[column]
and the Valid If expressions of all of the dependent dropdown columns refer to the same table. If you need more complex logic, such as involving another table, you cannot use the dependent dropdown feature. Instead, you’ll have to provide full expressions to provide the more-complex logic.
