Reset on edit doesn't work with a dependent initial value

[Robinthebest]

Conditions:

currently i have two cells related to each other

[Bank name] and [Bank Account No.]

When I choose a bank in [Bank name], which is ref to a list of bank names, [Bank Account No.] will put out the bank code of the bank as initial value, but sometimes it is being left out for further edit.

When I get the bank info and decided to edit the row, when i choose [Bank name], the [Bank Account No.] will stay empty, i tried is not blank and it is only resetting when there’s already value input on that cell, I want it to update when I choose the bank name when i modify the case.

[Marc_Dillon]

What is your Initial Value expression, and reset_on_edit expression, for [Bank Account No]?

[Robinthebest]

initial value i got: [Refund Bank].[the value i wanted to show]

reset on edit: ISNOTBLANK([Refund Account No.]), but no matter if i choose ISBLANK or ISNOTBLANK it still only works if the field was not left blank at first

[Marc_Dillon]

You could try to just turn reset_on_edit on, without any expression. That may not make sense for your situation though, I’m not sure.

Or, you could try an expression that looks at the value of the Ref column, something like:

[_THISROW_BEFORE].[Refund Bank] <> [Refund Bank]

[Robinthebest]

Both doesn’t work, maybe let me try explain more clearer.

I have [Bank Name] which is a ref, [Bank Account] linked to each other, when i choose a bank name in the app, a bank code will be shown in [Bank Account] as the initial value.

If I just turn reset on edit on, it doesn’t give out any initial value in [Refund Account No.] when i do anything on the [Bank Name]

[Marc_Dillon]

Oh, there’s a third column in the mix here? Now I’m confused. Show screenshots of all 3 column configurations.

Or rather, 4 columns…

Robinthebest:

[Bank name] and [Bank Account No.]

Robinthebest:

[Refund Bank]

Robinthebest:

[Refund Account No.]

[Robinthebest]

I’m sorry that I’m confusing you.

As you can see there’s only 2 columns, so when I pick an option on the refund bank column, an initial value “012” will comes up in the refund account no. field.

After saving it, if I wanted to edit the row, when I choose a new bank, a new initial value wont comes up on the refund account no. field.

[Robinthebest]

another image is here as i can only embed one image each post

[Marc_Dillon · Accepted solution]

[Refund Account No.] 's Reset_On_Edit =

[_THISROW_BEFORE].[Refund Bank] <> [Refund Bank]

[Robinthebest]

thanks! can u explain the expression for me?

because i don’t see there’s any place that explains [_THISROW] types of expressions.

[Steve]

help.appsheet.com

Before and After Values

You can see the value of a column both Before and After it was updated.

help.appsheet.com

Accessing column values before and after an update

Access the value of a column before and after a record is updated.