Action updating incorrect colums

[antproberts]

I have a table that records the issuing of key which records date, site, name of person issuing, name of person being issued etc.

I have an action in my app then when clicked show should update 3 columns showing the return of a key.

When we click this action the columns update but the original column with who issued the key also updates but incorrectly and not in line with what the actions states?

Any ideas?

[TeeSee1]

You have a Formula defined for [key issuer] (which I assume is the column you are referring to  that 'incorrectly' updates.).

The Formula is reevaluated when you modify the row and my guess is that is what is happening. It is hard to tell what exactly is going on without knowing the formula you have defined for the column.

[antproberts]

The formular is a lookup so what you are saying makes sense maybe if I switch it to the initial value that will stop the formula re evaluating?

[TeeSee1]

Correct. Initial value, unless reset on Edit is checked, remains unchanged.

Suggested value also works.