Solved: Reference without duplicates from dropdown - Page 2

Djigi · 09-28-2021 02:36 AM

Hi Everyone,

I’m not sure if this is the best way to approach this, but let me try to explain the situation:

productid, productname, productseasoning
1 , cashew , salted
2 , cashew , smokehouse
3 , almonds , salted
4 , almonds , smokehouse

This list is bigger, but in this example I would get 4 choices if I reference to productid.

What I would like is to have a choice between cashew or almonds and than another choice between salted or smokehouse. By using valid_if I do get the choices, but that does not work as a reference. Is there a way to reference to a certain product id without having to pick between a list of of “duplicates”, but instead having two narrowed down choices?

Aurelien

Hi @Djigi

Not sure what you need, but this is probably barrier language for me.

you need to adjust the dropdown in the product ID:
This is what you made yet, so in the Valid_If expression you probably have:

FILTER(“Production Products”, 
  AND(
    [Product ingredient] = [_THISROW].[Product ingredient], 
    [Product seasoning] = [_THISROW].[Product seasoning]
  )
)

you need the app to pick in the dropdown without needing the user to enter the field.
Here, you should keep the previous setting, and set an additional one: you need to wrap the previous expression with an ANY(), in the Initial Value field.
So, that will be:

ANY(
  FILTER(“Production Products”, 
    AND(
      [Product ingredient] = [_THISROW].[Product ingredient], 
      [Product seasoning] = [_THISROW].[Product seasoning]
    )
  )
)

Let us know if that works for you

View solution in original post