Required if when a specific action button has clicked

I was wondering to know if I could make required some fields only when I’m triggering an action,

Example: I have three actions in my AppSheet

When I click Open, I want the job_id required.

But my cancel button cannot make require the job_id

I tried using context and the new value for the status as required_if of my job_id field

and(in([status],list(“Open”)), CONTEXT(“ViewType”) = “Detail”)

But even using [_thisrow].[status], AppSheet didn’t understand the new status I’m assigning inside the action

Does anyone ever face this?

1 Like

Are you specifically wanting to use INPUT()? You can easily make a column required in only a particular form view with CONTEXT(). I’m a little confused about exactly what you’re asking or wanting here.

1 Like

The question is - How can we make a column mandatory when taking as input using Advance Input. There is no specific form.