How to use value of an input of a cell to in another one in appsheet

[ctrlcostnow]

Hello Everyone.

Please can someone guide me on how to call up the input value of a cell in appsheet?

Basically, I want to filter a column, but I like the keyword to be based on the value the user chooses. 

[Aurelien]

Hi @ctrlcostnow 

"Basically, I want to filter a column, but I like the keyword to be based on the value the user chooses. "

Did you consider using this filter feature for your user ?

[ctrlcostnow]

My question is how do I call up the value that the user entered in the previous cell as the condition to use to filter the column. I don't know if I am asking the right question. totally a new bie

[Aurelien]

Are you talking about a dependent dropdown ?

If so: Dependent drop-downs - AppSheet Help

[ctrlcostnow]

Not exactly.

What I want is to call up information entered somewhere in the form in another cell. For example, I have two questions 

1 Are you male or Female?

2 I want to call up the answer the user entered in Q1 to use as the key word in valid if function.

[jrullan]

So... 

Can't you enter the column name of the first question here?

like [Question_1]="Male"?

[ctrlcostnow]

didnt work.

Kept getting all sorts of error.

[Aurelien]

Can you share a screenshot of the error ?

[Aurelien]

@jrullan got it right 🙂

@ctrlcostnow You may want to enter an expression such as this one in the Valid_If field:

If you wish a list:

FILTER("yourTable",
  AND(
    [GenderCriteria]=[_THISROW].[Q1],
    yourSecondCondition
  )
)

If you wish a check:

[Q1]="Male"

For reference:

Check form input validity (Valid_If) - AppSheet Help

FILTER() - AppSheet Help