Can't get Reset on edit to work

[1minManager]

I have a table where the user wants to use the “Copy a record and Edit the Copy” action. That bit works fine. But in the copy, the user wants to be able to change a column called [Location] which then automatically updates a column called [Tower]. [Location] is a Ref to the Location table, in case that matters. [Tower] is set up as follows:

Type = Text
Require = TRUE
Initial Value = [Location].[Name]
Editable = TRUE
Reset on Edit = TRUE

So this issue is changing [Location] does not cause [Tower] to recalculate. It’s not possible to use an App formula in [Tower] as we have actions than need to be able to modify [Tower] However, whilst the App needs to be able to change [Tower] automatically, we don’t want the users to be able to change it directly.

Any ideas?

[Gowtham]

Reset on edit? is applied only for edits after the initial row creation. When we using the copy-and-edit action, the edit of the copy is treated as an initial row creation.
@1minManager A similar thread discussion is there, please look into the @Suvrutt_Gurjar suggestion.

"Reset on edit?" is not triggered by "Copy and edit" action? Questions

Not sure if this is a bug, but I have a table for which I use the built-in “Copy this row and edit the copy” action, as I need to be able to duplicate a row multiple times but with the ability to edit each row (if necessary) before saving it. However, as there is a single column in each row that I do not need to copy over, I hoped it would work by marking that column as “Reset on edit?” since this erases the content of the column when the row is edited, but apparently this reset is not triggere…

[1minManager]

Understood. So they are editing the copy, and the column is not updating.

[Daryl_Zernick]

What was the solution?

[Joseph_Seddik]

Here:

"Reset on edit?" is not triggered by "Copy and edit" action? Questions

Not sure if this is a bug, but I have a table for which I use the built-in “Copy this row and edit the copy” action, as I need to be able to duplicate a row multiple times but with the ability to edit each row (if necessary) before saving it. However, as there is a single column in each row that I do not need to copy over, I hoped it would work by marking that column as “Reset on edit?” since this erases the content of the column when the row is edited, but apparently this reset is not triggere…

[Viktor]

Yes, because it doesn’t trigger on the initial copy of the row. I solved the problem using @Suvrutt_Gurjar’s solution, which is quite simple