Solved: Reset on edit doesn't work with a dependent initia...

Robinthebest · 11-13-2021 11:42 AM

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

[Refund Account No.] 's Reset_On_Edit =

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

View solution in original post

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

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

[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

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