Solved: How to reset/make blank an Enum column when anothe... - Page 2

StephenMattison · 08-19-2022 06:40 AM

Howdy! I have two columns in the same row [Person assigned to Role] (Ref type) and [Confirm your role] (Enum type). When PersonA enters a negative confirmation of "No can't attend" into [Confirm your role] column, we will then enter a new PersonB into that [Person assigned to Role] and wait for them to enter their confirmation choice in [Confirm your role]. When PersonB is entered into [Person assigned to Role], I need the [Confirm your role] column to reset back to blank. I think I need a _THISROW_BEFORE _THISROW_AFTER expression for the [Confirm your role] column based on the [Person assigned to Role] column. TYVM!!

WillowMobileSys

Oh no! Egg on my face!! I hate that!!

You are so right! And now that I think of it, I believe I have taken advantage of that once before.

THEREFORE, you can use the [_THISROW_BEFORE] and [_THISROW_AFTER] checks.

So I just tested this with the following "Reset on Edit" expression:

[_THISROW_BEFORE].[Test1] <> [_THISROW_AFTER].[Test1]

The Initial Value of number column was set to zero. Opening the existing row and changing the Test1 column value resulted in my number column being properly reset to zero.

View solution in original post

StephenMattison

Great news! This is the solution!! It's working perfectly, and with my Quick Edit, Delayed Sync & Automatic Updates set up, it works live, on the fly as I change the [Person assigned to Role] column, and it even updates the Conditional Formatting that I use for [Confirm your role] column! Yes, this is awesome, SO simple, TYVM!!

In my Update Behavior >> Reset on edit expression for [Confirm your role] column, I used this

[_THISROW_BEFORE].[Person assigned to Role] <> [_THISROW_AFTER].[Person assigned to Role]

So simple, so elegant! Thank you very much @WillowMobileSys !!

View solution in original post

How to reset/make blank an Enum column when another column data in same row is changed? TYVM!