Boa tarde
Criei um appsheets paracontrele de uma planilha de bonificações.
Porém preciso salvar o historico de edições realizadas pelos usuarios res´ponsaveis de cada área e não estou conseguindo.
Como posso fazer?
You’ll need separate tables for this.
- One table for the Bonificações, the one you already have.
- Another table where your users should enter their changes. Columns of this table can for example include: Current value (from Bonificações), New value, a timeStamp, and the USEREMAIL() of the user making the change.
A bot would then trigger upon each addition to this Changes table and update the corresponding row in the Bonificações table.
Boa tarde
Seria possivel me enviar mais detalhes para esse processo.
essa é minha tabela
Agradeço muito se puder me enviar um passo a passo, pois sou iniciante ainda no appsheet
OK, let’s take it step by step. First, which column in your table you want to keep edit history for?
Ola,
Preciso o historico de todas as colunas, se o historico for individual por colunas dai peciso fazer os pssos para todas elas.
-
Add two columns to your existing table, and put the corresponding expressions respectively in the App Formula of each column:
- User: USEREMAIL()
- Timestamp: NOW()
-
Have a new table, name it for example changeLog, and make its column structure identical to your original table.
-
Make a bot that is triggered by any data change to the original table. This bot should launch an action of type: Add a row to another table using values from this row. The values you should put in each of the rows are the following:
- User: [User]
- Timestamp: [Timestamp]
- For all other columns, you should put the following expression:
IF(
[_ThisRow_Before].[column] = [_ThisRow_After].[column],
“”, [_ThisRow_Before].[column]
)
Now, each time a user changes a column, you’ll have the old value registered in a new row in the changeLog table, along with the email of the user who did the change and the timestamp of the change.
