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.