Hi All New to AppSheet and I am trying to fi...

[Simon_Knott]

Hi All

New to AppSheet and I am trying to figure something out when it comes to Dependant dropdowns.

I have succesfully setup a dependant dropdown using the VALID_IF=TableName[Field] function on 2 inputs however I need to replicate this for another 2 inputs used in my app is this possible?

All 4 inputs are used in a row for example:

Content Stock Type = Paper weights[Type]

Content Stock Weight = Paper weights[Weight] Cover Stock Type = Paper weights[Type]

Cover Stock Weight = Paper weights[Weight]

The problem I have is that it is linking the Cover inputs to the content inputs, is there a way I can make the dependant fields work over just the first 2 then work seperately for the 2nd 2?

If I havent explained myself clearer please let me know!

Thanks very much.

[Simon_Knott]

For those who are also stuck on this, My workaround is that I added the table in again as another datasource called it Paper weights2 and put the logic in as

Content Stock Type = Paper weights[Type]

Content Stock Weight = Paper weights[Weight] Cover Stock Type = Paper weights2[Type]

Cover Stock Weight = Paper weights2[Weight]

[Aleksi_Alkio]

No need to do that. when you want to cut the dependent process, you can write the formula like…

Cover Stock Type = SELECT(Paper weights[Type],TRUE)

Cover Stock Weight = SELECT(Paper weights[Weight],[Type]=[_THISROW].[Cover Stock Type])

[Simon_Knott]

@Aleksi_Alkio Thanks Aleksi works like a charm.

[Aleksi_Alkio]

You’re welcome