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?
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.
Understood. So they are editing the copy, and the column is not updating.
What was the solution?
Here:
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
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |