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

(Simon Knott) #1

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) #2

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) #3

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) #4

@Aleksi_Alkio Thanks Aleksi works like a charm.

(Aleksi Alkio) #5

You’re welcome