detail view: how to change the content of a field "x" depending on the value of an other field "a"

[Joachim_Mund]

Hi all,

in a detail view with edit option, I would like to change the content of a field "x" depending on the value of an other field "a" and have the possibility to edit field "x" with the fille value.

 - a bot will not immediately update the value in "x"
 - initial value formula will not work, because the record exists (detail view with edit)
 - App formula will not work, because the column will not be editable

Any other idea how to fill the field "x" depending on the value of "a" which is editable in detail view?

Thank you, Joachim

[Suvrutt_Gurjar · Accepted solution]

If understanding of your requirement is correct, please try 

1. Set the reset on edit of field [x] as [_THISROW_BEFORE].[a]<> [_THISROW_AFTER].[a]

2. In the Initial value of field [x] , have an expression that you want to set based on value entered by user in the field [a] such as [a]*5 or whatever as per your requirement. 

[Joachim_Mund]

Thanks Suvrutt_Gurjar, that is a perfect solution, I did not know.

Great!!