Two Initial values with If

AppSheet AppSheet Q&A
, , , , ,
1

Hello everyone

When a seller is filing in an order, he/she picks an item name, special feature and then color of that item.

for color I used this initial

LOOKUP([_THISROW].[Item Name],“Items”,“Item Name”,“Color”)

can I use two conditions so to speak in initial value? like:

►► if special feature is … then color initial is…

but should be used side by side with this formula

LOOKUP([_THISROW].[Item Name],“Items”,“Item Name”,“Color”)

maybe with the help of or, and & any…ets

any hint plz

Thanks indeed

2

See this:

Dependent drop-downs - AppSheet Help

1 Like
3

Thank you @Joseph_Seddik

I believe what you said is already done.

Please see this image below

The special feature is already set to (black leg) and the color automatically to (walnut).

black leg.jpg
black leg.jpg370×485 19.9 KB

Now see this image below.

If I select (white leg) in the special feature column, it keeps showing the color of the previous selected special feature which was the (black leg). (walnut color)… it should sow another color (cream)

is there a way to auto manage that

white leg.jpg
white leg.jpg367×502 21.7 KB

4

You are using the Valid if, now also use the Suggested Values field.

1 Like
5

@Joseph_Seddik

But isn’t there a way to to show specific color automatically once I select the special feature value.

6

Put the relevant expression in Suggested Values

1 Like