Can we store an update in the spreadsheet

[jomphon101]

Is it possible to store an update into the spreadsheet? I’m working on the Survey application that records the unit of houses that have been sold. For example, today I went to one of the House projects and see that 10 units have been sold today so I record it. Then a week pass by, I came back to record the additional units sold and I found that 5 units have been sold this week so I update it. I wonder if I could store the record of the update I have made or not? This is how I want it to store

[LeventK]

help.appsheet.com

Before and After Values

You can see the value of a column both Before and After it was updated.

help.appsheet.com

Workflow

Send Email, SMS or Notifications on Add, Update, or Delete.

[MultiTech]

Welcome @jomphon101; I have a question:

• Why do you want to store the previous value inside the current value?
  • You’ve already got that previous value in the other record; you’re essentially duplicating data.

[jomphon101]

Hi

I wanted to keep the transaction of updates to see the trends.

Do you have any suggestion ?

Thank you,

[MultiTech]

jomphon101:

I wanted to keep the transaction of updates to see the trends.

If you make each record in your table = one transaction, then over time you’ll accumulate that data and can use that for insights.