How can we make a column mandatory when taking as input using Advance Input.

[sandeep138]

In my table of ~30 columns, I want to capture "Rejection Reason:" when a user click on "Reject" action. 

The field is not mandatory at all, but is mandatory on when taking this input. How can this be achieved?

[TeeSee1 · Accepted solution]

The only way I can think of doing this is

• you have a "status" field,
• an action - set the values of some columns - sets this status field to "REJECTED" as well as Rejection Reason to INPUT("Rejection Reason","")
• put an expression [status]="REJECTED" to the required-if property of Rejection Reason