Bypassing validation for a column while updating corresponding column

[Neeraj_Malik]

Stuck in typical situation, where I’ve got following columns in a table

1. [Debit Amount] and [Status] columns are editable and the other two columns are having formulas
2. Debit amount has validation where it is valid if [Debit Amount]<=[Balance Left]
3. While adding a row Initial value of column [Status] is set as Pending
4. Status has to be changed to Received through an Action created for updating column [Status]

Now update action is failing for second row as per above table due to validation error [Debit Amount]<=[Balance Left]

Looking for option to bypass the validation during update so that [Status] value can be changed from Pending to Received. Or any other solution to overcome this situation as the given validation is a must requirement

Pls guide.

[Steve]

This sounds pretty straight-forward, so I’m probably missing something.

OR(
  ("Received" <> [Status]),
  ([Debit Amount] <= [Balance Left])
)

[Neeraj_Malik]

Somehow this is not working.
To me it looks like, at the time of update, all columns values are being recalculated considering existing values as fresh one and at that time [Balance Left] is already or greater.

There has to be a way only one column is being updated without looking at other columns.

[Steve]

Please post a screenshot of the error message, and of the Debit Amount column configuration.

[Neeraj_Malik]

Error is the validation error message

[Steve]

Sorry, I wasn’t clear: please post a screenshot of the error displayed by the app. I want to see what the app looks like when the error occurs.

[Neeraj_Malik]

It’s just validation failure error

[Steve]

Hmmm… Okay, so what did you do with the app that causes the error to display? You mentioned an action? It might be useful to see the action configuration.

[Neeraj_Malik]

![image|690x476, 75%]

[LeventK]

Do you have a ZWL Debit column in your Auction table?

[Neeraj_Malik]

Yes, ZWL Debit is nothing but the Debit Amount

[LeventK]

What kinda expression do you have in the Valid_if property of that [ZWL Debit] column?

[Neeraj_Malik]

Also tried [ZWL Debit]<=[ZWL Amount Available]

[LeventK]

When your actions sets the [Status] column value as “Received”, the Valid_If statement for [ZWL Debit] column returns FALSE value and therefore you received the Invalid Error property’s message text.

[Neeraj_Malik]

I understand that and looking for solution for the same

[Neeraj_Malik · Accepted solution]

After days of struggle, could figure out the issue

Debit amount validation shall continue to have the same valid if [Debit Amount]<=[Balance Left] like [ZWL Debit]<=[ZWL Available Balance] in my case
The error was in [ZWL Available Balance], where the value of App Formula should actually be the Initial Value
Also need to ensure that the Reset on edit in Update behaviour should be unchecked.

[LeventK]

Thanks for the feedback and glad to hear that the problem is solved. Congrats @Neeraj_Malik

[LeventK]

@Neeraj_Malik
A step in your Behavior Action disvalidates one of the conditions of the Valid_if, therefore the action fails.