Issue with Action Button

[Yeyo1976]

HI, I have a big problem.

I have a table called "Pagos" where the customer register the payment for the service.

As the customer enters their page with their email address, and I already have the data saved, I want their name, Rut, and email to be displayed automatically.
So far, so good.

The problem is that through an action I want (as ad amin, not customer) to register that service as paid, but when I do so, it changes the data in the database to that of the person who confirms the payment.

What can I do to change only the "Estado de Pago"  column and keep all other data as it was before the action?

I need some orientation here, because I'ts a key attribute in my app.

[TeeSee1 · Accepted solution]

For Cutomer email, use Initial Value rather than app Formula.

App Formula updates every time you update the record whereas Initial Value remains the same unless you explicitly update it

[Yeyo1976]

Woa... Thanks a lot!!!

[Gianlucapozza]

A solution that I use in all my apps is to create a table only to archive and manage users info in my app using as key value  their email address. In your case you could create said table with more informations regarding their bank info, name, surname etc.

If the user needs to update a payment row the "Apoderado" column could be computed based on user email, but every other field can be referenced from the users table as initial values

[Yeyo1976]

Hu, thanks!

But the solution was so simple: put the formula in Initial Value.

Thanks to @TeeSee1